Forum Discussion

rosponda57's avatar
rosponda57
Frequent Visitor
10 years ago

Can't set data source credentials

Something happened with data sources, the "Data source credentials" menu for dataset is disabled.     i've checked if on few data sources and on few accounts, everyware is the same.   Is w...
Need Help
GarryFarrell's avatar
GarryFarrell
Advocate III
9 years ago

Hi,

 

I have been following this post by Chris Webb. https://blog.crossjoin.co.uk/2016/09/19/loading-data-from-multiple-excel-workbooks-into-power-bi-and-making-sure-data-refresh-works-after-publishing/

 

I have used several different methods to load data to PBI Desktop and publish it.

  1. Sharepoint Folder and accessing an Excel File in Sharepoint.
  2. Sharepoint Folder and accessing an Excel File in OneDrive.
  3. Directly using the Excel connection in PBI Desktop and connecting to an Excel File in OneDrive.

All of these methods end up with the same issue as outlined above. It is trying to use my personal gateway and will not allow me to specify the "Data source credentials". However, when I follow Chris Webb's post even though I am only using one file instead of multiple, i get the option to use the "Data source credentials". When this works this is what it looks like and I can Edit my credentials and the refresh works without the Gateway.

 

But my question is why does Chris Webb's method work and the other more standard methods not work. Is it the difference between using the online version and desktop?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I have done one more test.

4.  I connected from Power BI online to my Excel file stored in OneDrive and the result is different. "OneDrive Refresh"