Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a dataflow in the PBI service that hits several API endpoints to give me tables of all my dataflows, datasets, refresh times, and other metadata.
I have an idea to leverage the new Enhanced Refresh API in Power Automate to dynamically refresh my Power BI tables when they're refreshed at the source. My testing shows this is possible, but I need the Dataset table names and M query to make it work.
In my dataflow, I am generating a list of my datasets using the REST API. The table looks like this:
datasetName |
Dataset_1 |
Dataset_2 |
Dataset_3 |
Since there is no API endpoint to retrieve the tables/queries, I insert a new step to dynamically insert the datasetName into an AnalysisServices connector to retrieve the tables/queries.
AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/MyFakeWorkspace", [datasetName], [Query="select * from $SYSTEM.TMSCHEMA_PARTITIONS", Implementation="2.0"])
This works and returns all of the data I need, HOWEVER i am unable to save this to the service due to 'Dynamic Data Sources'.
I use ReferencePath for the web.contents API calls and that works fine (I had the same issue there and this fixed it), but I haven't found a way to get around this one. Per the MS documentation, I could use Power Query parameters but so far I still get the same error.
Any ideas?
Thank you!
Hey @jhayes0128 - It's a known issue with using APIs in Dataflows. You get the error esp. when you are trying to make the API calls dynamic. Please refer to tehw ork around below and see if it works.
https://community.powerbi.com/t5/Power-Query/REST-API-Dynamic-Datasource-aren-t-refreshed/td-p/18116...
Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
Thank you for the response. I do use RelativePath for calling REST APIs (works great), however there is no REST API endpoint for dataset table names and query definitions. So I need to use AnalysisServices.Database instead of web.contents. There is no RelativePath option on the AnalysisServices.Database connector.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
15 |
User | Count |
---|---|
32 | |
19 | |
19 | |
16 | |
15 |