Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
2 years ago
Solved

Scheduled refresh has been disabled

I have created a Power BI report that reads data from a folder stored on my OneDrive. I published it onto the workspace. When I tried to manually refresh the dataset on the workspace I received an er...
Need Help
Show and Tell
Tips and Tricks
  • HamidBee's avatar
    HamidBee
    2 years ago

    Thanks. I managed to find out what the issue was. The current Datasource is "C:\Users\Hamid\OneDrive....". The problem with using this is that it is directed to my C drive so Power BI thinks the files are stored locally even though technically it's stored in the cloud. So this method requires me to have a data gateway. Instead, I got the url link of that same OneDrive file which looks like: "htttps://organization.my.sharepoint.com/personal/hamid......". In using this Power BI knows it's online and I can set up schedule refresh without the need for a data gateway. 

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
2 years ago

Hi. This video is specifically for data on SharePoint my question is related to files on OneDrive.

christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

OneDrive is a facet of SharePoint. Your OneDrive site is a private SharePoint site on the back end.

  • HamidBee's avatar
    HamidBee
    Icon for Power Participant rankPower Participant
    2 years ago

    Thanks. I managed to find out what the issue was. The current Datasource is "C:\Users\Hamid\OneDrive....". The problem with using this is that it is directed to my C drive so Power BI thinks the files are stored locally even though technically it's stored in the cloud. So this method requires me to have a data gateway. Instead, I got the url link of that same OneDrive file which looks like: "htttps://organization.my.sharepoint.com/personal/hamid......". In using this Power BI knows it's online and I can set up schedule refresh without the need for a data gateway.