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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors