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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

How do I identify a DataSet with PBIX OneDrive refresh and find the PBIX source file?

Hi,

does anyone know a way how I identify DataSets with PBIX OneDrive refresh and find the PBIX source file in OneDrive or SharePoint Online? Can I use the Rest API for this?

Greetings
Marcus

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


5 REPLIES 5
GilbertQ
Super User
Super User

Hi @mwegener 

 

Ahh ok I see why this could be an issue. What happens when you try the API with this data source to see what it returns?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ ,

 

the API unfortunately only shows me the data sources within PBIX.

GetDatasources.png

 

The API "Get Imports In Groups" shows me the source, but unfortunately not the path.

 

GetImportsInGroup.png

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Thanks @GilbertQ , but in my problem OneDrive is not a data source, but the whole PBIX file is synchronized.

 

in my problem OneDrive is not a data source, but the whole PBIX file is syncronized.

 

Syncing Published Power BI Report Files Using OneDrive

https://youtu.be/qu6O2ySCeOA

Learn how to easily sync Power BI files (PBIX) between OneDrive and Power BI Workspaces. Allowing updates to the file on OneDrive to automatically sync to the workspace.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Has anyone found a solution to this? 
To find the path to the original sharepoint folder holding the pbix file that was first uploaded to the service.  This is important to be able to edit the original pbix and synchronise the changes to the service without having to download and republish a new pbix file.

GilbertQ
Super User
Super User

HI @mwegener 

 

Yes you can.

 

Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors