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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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


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


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


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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors