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!
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
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 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.
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! 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
![ROSÉ(로제) - APT. (Band VER.) (With. 이영지) [더 시즌즈-이영지의 레인보우] | KBS 241129 방송](http://i.ytimg.com/vi/IW8qaemx74g/mqdefault.jpg)
Great work! Thank you so much for this video. With this example, I was able to do the same with multiple API connections.
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!
You guy you are also here...Great!!!
This was very useful, Thanks!!
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
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")
Can the whole process be automated?
Thank you! This was very helpful 💙
Thanks! How to import data using GraphQL?
Hello Sir, how can we fetch data from power bi as xml or json to my application using rest api
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)
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 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!
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.
really i used this video thank you god
Di you have a udemy course in power bi
thanks mate!
Rain, Rain Go Away...
very useful
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