Forum Discussion

Bezos's avatar
Bezos
Regular Visitor
7 years ago

Data Source Credentials Greyed out

Hello,    I have a simple query that retrieves the time from a website. The query works in Power BI desktop and I can publish it to Power BI online Workspace. I want to be able to refresh the datas...
Need Help
Bezos's avatar
Bezos
Regular Visitor
7 years ago

No I couldn't find a solution :(

 

 

Ross73312:

Were you able to get it to work with the query I posted? Why doesn't this particular code work to automatically refresh??

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Bezos 

 

any luck in this issue? I'm having the same issue now. seems like this is an old post and I was hoping

there is already a work around..

 

Thanks..

  • emcus's avatar
    emcus
    Advocate I
    6 years ago

    I had the same error.

    My report already contained one data source (SQL) through on-premise gateway and one SharePoint online data source. Worked without a problem.
    I added another SharePoint online data source and merged this result with the SQL data in Power Query. After that I could not enter credentials for SharePoint, I was requested to add it to the gateway which can not be done since there are no organizational authentication and windows authentication doesn't work for SharePoint online
    I removed the merge in Power Query and instead added it to the data model and then it worked.


    Can it have something to do with privacy levels?

    • emcus's avatar
      emcus
      Advocate I
      6 years ago

      There is a checkbox on the gateway settings that says "Allow user's cloud data sources to refresh through this gateway cluster". I checked that and then the data source settings for the SharePoint source was enabled again on my dataset setting.