Dataset Won't refresh from OneDrive Excel file

[cgaine]

I've created a PowerBI dashboad to analyse all our Bell mobility cost and usage data.  The report works great, but when I update the Excel file with new data, I can't get the Dataset on PowerBI.com to update.

After I update the Excel file in One Drive for Business I can refresh the dashboard from PowerBI Desktop no problem.  When I go onto PowerBi.com and try to refresh the Dataset I get an error message:

Something went wrong.

Datasource has no credentials

The only way I can update the data on PowerBI.com so far is to republish the report once I've updated the data in PowerBI desktop.

I tried to add a Data Source to my Gateway using the SharePoint URL (there is no option for OneDrive)  But that is not working, I get an error that the file can not be found.

I can create the Gateway to the file using the local file path on my computer.  However I still get the same error when I try to refresh the Dataset. When I test the connection it passes, but it seems not linked to the DataSet I created.

If anywone's got this type sync working, please let me know what I'm missing.

Thanks,

[cgaine · Accepted solution]

I figured out the Dataset setting was linked to my PowerBI -Personal gateway which does not exist.  I updated it to use the data Gateway and its all working good now.

Thanks to all those who pondered over my issue.