Can we connect OneDrive file to existing published dashboard?

[asifnazir]

Hi, We have created a Power BI dashboard from an MS Excel file using BI Desktop and published on a workspace on PowerBi web app. Dataset also published with that. Now we want to use auto-refresh using one drive. Do we need to created all dashboard again on workspace using IE. Or we can connect Onedrive file to existing published dashboard?

[Anonymous]

To refresh using OneDrive, you would need to make the files contained on OneDrive the data sources in your project.  Based on your description it sounds like you started in the Power BI desktop.  What you will need to do is open that project again through your Power BI Desktop and change your data source lines on each of your queries to reference your OneDrive version of your files.

When you publish, if all of your data sources are from One Drive, you will now have the ability to  "Connect Directly"

[asifnazir]

Still facing Auto-Refresh Issue. I placed the Excel file on OneDrive, Opened the PBIX file in BI desktop and changed data source lines on each of your queries to reference your OneDrive version, then saved PBIX file on OneDrive as well and published using desktop. Connected that workspace to OneDrive through "Get Data". But now we have two data sources over there and still it is not getting data refresh from OneDrive Excel file. Any suggestions please ..... ?

[Anonymous · Accepted solution]

The file you published to the service, are you able to refresh that file?  I've noticed you've added to the complexity by creating a 2nd project in the service using "Get Data".

My expectation is that you have a single project, whose only data sources are in your one drive.  You publish that project and set that project to refresh.

So, ignoring your second project, can you confirm that your original file only has data sources on your one drive?  You can check this in the data source settings, which will give you a concise list of all of your data sources in that project.

[asifnazir]

Thanks a lot Buddy, It is working now 🙂