Forum Discussion

cgaine's avatar
cgaine
Frequent Visitor
9 years ago
Solved

Dataset Won't refresh from OneDrive Excel file

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,
 
Need Help
  • cgaine's avatar
    cgaine
    9 years ago

    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.

1 Reply

  • cgaine's avatar
    cgaine
    Frequent Visitor
    9 years ago

    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.