Refresh dataset from daily excel file under folder Onedrive

[Anonymous]

I publish the dashboard which get the data from latest excel file under Ondrive folder.

Everyday, I uploaded the new daily excel file so that the dashboard will be refreshed with latest data.

I observe that the dashboard I see in the Power BI desktop is refresh with new data. However, the dashboard in Power BI Service is not. If I publish the dashboard from PowerBI desktop, it is OK

How we can get the latest data from PowerBI Service without the need to repulish the dashboard everyday. I think that we do not need to set up gateway because our data source is under OneDrive Business

I try to refresh dataset in the PowerBI service, and I got this message

Thanks for your help

[nitishsh91 · Accepted solution]

Hi @Anonymous 

If your files are under onedrive then please the path like a sharepoint url in below format:

https://domain-my.sharepoint.com/personal/firstname_lastname_domain_com

If you are confused on how to create this url then you can go to onedrive web and then try to find this url which works for you and use Sharepoint connector and then go level by level to find the file that you are using. Once you have changed the dataset, publish your report and then go to Datasource credentials and then Edit credentials.

This should work for you and then you will be able to schedule it at a said time under Schedule refresh tab.

[Anonymous]

Thanks, I just try it out.

I have 2 datasouces

- one csv file from onedrive --> for this, I can use sharepointlink as you mentioned

- a folder from one drive --> I try to copy the link  but it has warning message that the link is not recognized as folder. it said :"The folder path must be a valid absolute file path"

[nitishsh91]

For folder also try out the same thing, use the root path only then browse inside folder, you can't directly go to the Folder like this.

[Anonymous]

Thanks for your help. I got it and it is solved