Thanks! Very useful. How PowerBI handle data updates? Can I tell PowerBI to refresh, rerun query every 30 minutes? Do I need to manually transform the JSON each time into a PowerBI table which would defeat the purpose of dynamic data loading... any help would be appreciated. Thanks!
Hello. I made my own REST API and I performed the same steps. Once the "Navigator" is open, I can see my data in "Web View", but not "Table View". Since it cannot be represented in the form of tables, it can't get loaded into PowerBI. Is there any way wherein this can be done? Please help. 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")
am trying to create a report puling the data from a REST API. The API however is secured using oAuth2, so in order to pull the data, an API call must first be made to /login/token API (using basic authentication) and the token returned needs to be used to authenticate the actual API call pulling the data. Is this possible with PowerBI
We have developed Angular and JAVA web application. We also integrated the Power BI Report via embedded token/URL, service principle, row level security etc. Able to access and display the Power Bi Report through iFrame in angular and java. Also successfully download the report in PDF and PPT etc. But we are looking for, how to implement the download report using bookmark or filter. Now we are able to download the report as whole not a bookmark or filter basis. How do we interact and pass the bookmark and filter information to download the report between Angular , JAVA and Power Bi Service Call. How we need to get the information of bookmark or filter from iFrame? Please let me know if anybody has any idea.
Hi my rest api needs a jwttoken for which i need to login to get jwttoken and then the token i valid for 2 hrs, after which we can get a new token maybe to get data. Could u please help for the same.
Hi, Thanks for sharing. I have a question with using APIs in Power BI. How to handle the access key or tokens that an API might need? Can this be done through Power BI easily? Don't forget to tag me when you reply. Thanks once again @Speedilytech Team.
hello Dhruvin Shah, my answer is a bit late but it may help others : You can add the token to access your API by adding the parameter "Authorization" and setting the value of your token to this param.
Hi! I’m interested for learn more. Could I pay you for any classes? What it is your email for contact ? I really need improve that knowledge ! I will be waiting your answer
Great work! Thank you so much for this video. With this example, I was able to do the same with multiple API connections.
Thank you! This was very helpful 💙
Thanks! Very useful. How PowerBI handle data updates? Can I tell PowerBI to refresh, rerun query every 30 minutes? Do I need to manually transform the JSON each time into a PowerBI table which would defeat the purpose of dynamic data loading... any help would be appreciated. Thanks!
This was very useful, Thanks!!
You guy you are also here...Great!!!
Hello. I made my own REST API and I performed the same steps. Once the "Navigator" is open, I can see my data in "Web View", but not "Table View". Since it cannot be represented in the form of tables, it can't get loaded into PowerBI. Is there any way wherein this can be done? Please help. 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")
Hello Sir, how can we fetch data from power bi as xml or json to my application using rest api
Can the whole process be automated?
really i used this video thank you god
Hi there, how do I get an api key from swagger. It is required in Power BI when trying to access the data on the API
thanks mate!
very useful
am trying to create a report puling the data from a REST API. The API however is secured using oAuth2, so in order to pull the data, an API call must first be made to /login/token API (using basic authentication) and the token returned needs to be used to authenticate the actual API call pulling the data. Is this possible with PowerBI
Can you please suggest on this ?
Probably just need to add the token as an HTTP request header (in the advanced button)
We have developed Angular and JAVA web application. We also integrated the Power BI Report via embedded token/URL, service principle, row level security etc. Able to access and display the Power Bi Report through iFrame in angular and java. Also successfully download the report in PDF and PPT etc. But we are looking for, how to implement the download report using bookmark or filter. Now we are able to download the report as whole not a bookmark or filter basis. How do we interact and pass the bookmark and filter information to download the report between Angular , JAVA and Power Bi Service Call. How we need to get the information of bookmark or filter from iFrame? Please let me know if anybody has any idea.
Hi my rest api needs a jwttoken for which i need to login to get jwttoken and then the token i valid for 2 hrs, after which we can get a new token maybe to get data. Could u please help for the same.
Hi, Did you find solution for this?
Hi,
Thanks for sharing. I have a question with using APIs in Power BI.
How to handle the access key or tokens that an API might need? Can this be done through Power BI easily?
Don't forget to tag me when you reply. Thanks once again @Speedilytech Team.
I appreciate your question, If you need learn with instructor visit www.speedilytech.com/
hello Dhruvin Shah, my answer is a bit late but it may help others : You can add the token to access your API by adding the parameter "Authorization" and setting the value of your token to this param.
@@imaneamouna936thanks a lot!
Di you have a udemy course in power bi
Rain, Rain Go Away...
not much helpful until you show how to handle pagination in API
Hi! I’m interested for learn more. Could I pay you for any classes? What it is your email for contact ? I really need improve that knowledge ! I will be waiting your answer