Hi,
Would really love to see this works since i cant even think about all the possibilities.
Is it possible to call Power BI REST API from Power BI desktop?
I am creating admin documentation and listing all datasets within my tenant and want to join these to used Gateways. I dont want to list all manually since there are around 40 Gateways and a couple of hundred datasets.
My test was to create a function in Power BI desktop which retrieves Gateway ID from my list of datasetID from Power BI REST API - https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasources
BUT, it dont allow access when i try to invoke the function over the table of datasetIDs,
Is there something else handy i could do to get all of this information? Or am i thinking about this completly wrong? have googled alot but nothing unfortunatly so now i turn to the almighty community.
All the best
/D
Helpful resources
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
