Power BI REST API no-code options

how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

how to get the list of email ids by RLS roles using REST APIs. Please guide here

Hey Adam, Can you help me how to use a Scroll API with Recursion in PowerBI

Hello! great video!Do you know by any chance if there is a REST api to get the CONTACT of a PBI report? I just find the one about CreatedBy which is not giving me what I want! Thanks!!

Hi,

I am getting data from an API that has two parameters like below in the URL:

Param1930=2021-01-01&Param1931=2030-12-31&format=JSON

These are the start and end dates of the report that I have manfully set up in the API URL. But, how do I make it dynamic so that everyday that I refresh the data in Power BI connect to the API and pull the latest data? My current M code is something like below:


let
Source = Json.Document(File.Contents("C:\Users\Ali\AppData\Local\Microsoft\Windows\INetCache\IE\EHD7MHFN\1120")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"txtProvider",
"txtIncidentNo",
"FltDate",
"LogTime")

Hi Adam
I'm facing problem during api integrating in power bi.
The DMS team provide me the API but when use that in web it's showing an error like "A web API key can only be specified when a web API key name is provided.
Could you make a video on that with free API

🐐

Hello Adam, I don't have the try it button to try it. I already logged in.

Shows me an error 403

Is this video about how to make an API go faster? What video do i watch to make the API refresh faster?

Adam, Try it is gone in this April. any recommend alternative way to easy use PowerBi api?

'Try it' has gone 😞

Hey Adam! do you have any idea what happened to the try it button that the API documentation had?
I think I missed some update, I used to remove dataset from usage metrics reports when its update got stuck.

HI Adam , I want to know in PBI service can you use post method . I have 6 API calls and I am using Bearer token to get the most recent data. Data is refreshing in PBI desktop when i hit refresh button with new data comes in . However, i am facing issue ( API Calls is passing the token values i am calling in post method in power query first ) when i publish it and want to schedule the page refresh. It throws me dataset credential error . it seems like it's not taking token for those API Calls. If you have any solution then please let me know or provide me your email to discuss more . Thanks

Excellent Video. Question - Is there a Rest API or set of PowerShell CmdLets, which can be used to run a PowerBI Report and Export the Report results? Thank you, Dana

Will this work with PIPEDRIVE?

I could not find a download for the Power Shell code.

Can u explain how to post rows to the dataset

Great Video Adam!
Can we use the rest API without code to get metadata from Talend to Power BI?

Hi, Can you show REST API creating in dataflows