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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.