Power BI Service Refresh from Shared OneDrive

[harpedb]

hi guys, hope you are well.

I have developed a dashbaord that connects to a onedrive folder. Power BI conencts to an excel spreadsheet whereby the uses can update their data (% completed of a task). The problem is on the Power BI service the data does not refresh and i have to republish the dashboard to the service. How can i ensure that once data updates in excel occur that the dashboard will refresh? 

[v-janeyg-msft · Accepted solution]

Hi, @harpedb 

Is your problem been solved? Have you connected to the gateway in the service and set refresh?

Reference: Configure scheduled refresh - Power BI | Microsoft Docs

If you still need help, Please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @harpedb ,

can you show the query that you used?

Did you connect on the local onedrive path (C:\users\...) or on OneDrive via Web?

Best regards

Denis