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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mwegener
Most Valuable Professional
Most Valuable Professional

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

mwegener
Most Valuable Professional
Most Valuable Professional

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


mwegener
Most Valuable Professional
Most Valuable Professional

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.