Skip to main content

Power BI

Needs Votes

Show filepath for OneDrive refresh datasets

Vote (20) Share
's profile image

on 13 Mar 2017 23:01:07

OneDrive refresh in the Power BI Service is a fantastic method for storing and updating files in an organized fashion. It's become my default storage and update process for Power BI. However sometimes files in the OneDrive get moved around or renamed. While the refresh keeps working despite these changes, it becomes harder to know which .pbix file in OneDrive the dataset in the Power BI Service connects to, especially if I renamed the dataset in the Power BI Service. It would be fantastic to select the dataset in Power BI Service and be able to see the filpath or storage location in OneDrive. Then I can clearly determine which file to overwrite to publish my updates.

Comments (5)
's profile image Profile Picture

Sebastian Hurley on 17 Nov 2022 14:55:59

RE: Show filepath for OneDrive refresh datasets

This would be a useful feature, but I have posted an idea that builds on this to allow modification of the file that the data set is connected to here:https://ideas.powerbi.com/ideas/idea/?ideaid=8270c5c6-8766-ed11-a76e-281878bd0b04

's profile image Profile Picture

Costas TTOFA on 25 Mar 2022 09:08:59

RE: Show filepath for OneDrive refresh datasets

Really need this. The connection to One Drive/Sharepoint for pbix and reports is great but there's not clear traceability. it can cause confusion where, for example, you cannot be sure whether a dataset or report in the online service is synced with one drive or was published using the "Publish" functionality in Power Bi Desktop.

's profile image Profile Picture

Fred Kaffenberger on 07 Aug 2020 13:38:12

RE: Show filepath for OneDrive refresh datasets

Not just datasets, but also reports built on Shared Datasets, certified datasets. This is really a prerequisite for composite reports over power bi and azure analysis services. How do you know where the report is? How do you know if it's up-to-date according to last changes? how do you fix it if it's not refreshing???!!!

's profile image Profile Picture

Fred Kaffenberger on 06 Jul 2020 00:16:26

RE: Show filepath for OneDrive refresh datasets

This topic came up in the Ask Arun Anything event.
https://community.powerbi.com/t5/Webinars-and-Video-Gallery/AAA-Event-Ask-Arun-Anything-February-25-2020/td-p/953536
~50:44 timestamp
https://community.powerbi.com/t5/Webinars-and-Video-Gallery/AAA-Event-Ask-Arun-Anything-February-25-2020/td-p/953536?attachment-id=12641

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:04:25

RE: Show filepath for OneDrive refresh datasets

This is a very good suggestion , On testing the One drive refresh I found that a user has the ability to rename both the .pbix file in one drive and the dataset and report on the service. They both keep syncing which is good. But you lose visibility of what's synced with what file. I wonder if View related in the service could be enhanced to show this ?