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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

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

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors