OneDrive Refresh in Power BI Service from data stored in OneDrive

[suebayes]

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.

[bdunzweiler]

@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]

@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.

[bdunzweiler]

@suebayes Is anything enabled in the Gateway Connection section?

[suebayes]

No because I don't want to use a gateway.  I can only have one gateway per domain on a machine as far as I can tell and I already have one set up with my personal bi pro licence, but this report is for another domain that I have another BI licence for.  

[bdunzweiler]

@suebayes yeah, I'm wondering if credentials are getting crossed.  I re-created your scenario and the dataset immediately failed for refresh with the same error.  However, my credentials section is enabled and I'm able to update it.  See below.  You might want to try opening it up in a different browser or use incognito/private browsing to make sure you using the correct set of credentials.

[suebayes]

It's still not showing the data source credentials even in incognito browser.  I wonder if you have to have a gateway connection.  do you have one gateway connection?  I have a call booked with a microsoft engineer tomorrow am so hopefully that might help ... Very frustrating though @bdunzweiler 

[bdunzweiler]

@suebayes  Correct, I only have one gateway available, which is the Enterprise version, not Personal.  It's on a separate VM.

[suebayes]

Thank you will try it now @bdunzweiler