Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
kdqdk
Frequent Visitor

Dynamically get own datasetID

Question: Is it possible, first time you publish a report, to dynamically get the created datasetID from the service into the semantic model?

Purpose: I have a dataflow where I pull all the scheduled refreshes in the tenant.
With this information, I can create a report, seeing what is the peak hours of scheduled refreshes, enabled/disabled etc.
On each of the reports I create, there is an information page, about data owner, report owner, contect etc....
I want to dynamically add the scheduled refresh to this info page, and for that reason I need to match my report datasetID with the datasetID from the dataflow.
Doing this will auto update the scheduled refreshes if it's changed in the service, and less manual maintenance is required in the report.

1 ACCEPTED SOLUTION
kdqdk
Frequent Visitor

Investigated a bit further, and as it is a cyclic event, then I don't think it is possible.
I made the solution so I have to get the ID after first publish, then I can set it using parameters, even in the pipeline.

View solution in original post

5 REPLIES 5
kdqdk
Frequent Visitor

Investigated a bit further, and as it is a cyclic event, then I don't think it is possible.
I made the solution so I have to get the ID after first publish, then I can set it using parameters, even in the pipeline.

v-achippa
Community Support
Community Support

Hi @kdqdk,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you @Akash_Varuna for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Thanks and regards,

Anjan Kumar Chippa

Akash_Varuna
Super User
Super User

Hi @kdqdk I dont think Power BI does provide a direct way to dynamically retrieve the Dataset ID of a published report into the semantic model from within Power BI itself.The workaround would be to use REST API Through Azure 
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

Yes, REST API is also what I expect.
However, I'm looking for the solution, e.g. code snippets, because I can't see a way for it to identify itself.

Hi @kdqdk Could you go through this 
https://community.fabric.microsoft.com/t5/Developer/Access-Power-BI-API-with-Python/m-p/189165?utm_s...
In this thread there are a bunch of links related to REST API

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.