Forum Discussion

suebayes's avatar
suebayes
Icon for Resolver I rankResolver I
6 years ago

OneDrive Refresh in Power BI Service from data stored in OneDrive

I have created a report which extracts the data from a OneDrive for Business folder which I access through Sharepoint.Files in Power Query.  This all works great.  I have saved the .pbix file into OneDrive for Business and have published it to the Power BI service using Get Data from Onedrive and the Onedrive refresh is on and set to refresh hourly.

I have a csv file sent to a folder in the Onedrive for Business using Flow with the aim that this is added to my datamodel using an automatic refresh.  It's not happening and I don't know why. 

I already have a gateway enabled on this machine for another domain and I think I can only have one per machine so the onedrive refresh is perfect.  Any suggestions please.

 

 
Need Help

8 Replies

  • bdunzweiler's avatar
    bdunzweiler
    Icon for Helper I rankHelper I
    6 years ago

    suebayes  Does the portal show any errors or messages for the scheduled refresh?  Also, could you include the query used to extract data from files?  It might help with troubleshooting.

    • suebayes's avatar
      suebayes
      Icon for Resolver I rankResolver I
      6 years ago

       

      bdunzweiler  here's the error message.  The query works well in the desktop and refreshes no problem.  I think it must be something to do with staying in signed in with the Microsoft account which would explain why there is a problem with authentication.