Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys.
I am trying to create a report using Power BI Rest API to get the refresh schedules of datasets so I can setup Alerts which will later be used in Flow to trigger refreshes.
I've used the documentation from here https://docs.microsoft.com/en-us/rest/api/power-bi/ and have managed to compile the data.
In order to pass authentification and test, I've used the Try It button to get the Bearer Token and signed in Annonymously, passing the token through the header, but I am having trouble finding how to get that token automatically. I've been reading through every documentation possible but cannot get my head around how to do it.
Please can you help?
Solved! Go to Solution.
Hi @Anonymous
you have to use a custom connector in Power Query to access this API: https://github.com/migueesc123/PowerBIRESTAPI
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Anonymous
you have to use a custom connector in Power Query to access this API: https://github.com/migueesc123/PowerBIRESTAPI
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
I started using this but was not sure if this might be the right approach. From your response I can be sure thought that I am on the right path.
Thank you.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
20 | |
19 | |
13 | |
11 |