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
Minseven's avatar
Minseven
Helper I
7 years ago

hi, did you find the solution?

I'm facing the same problem. My data are located in my Sharepoint environement, and I don't want to use a gateway (Thank you IT guy)

How to refresh my reports?

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

    I faced the same problem, and to fix this, I open the Power Query in PBI Desktop, and refresh all the query previews and then save the PBI desktop file again. and then when I refresh the PBI dataset in PBI services online, the warning goes away.

     

    Hope that works for you as well

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Bezos  The issue is that you have used Web.Contents in your source line and therefore need a gateway.  If you are using SharePoint online, you need to change your Source line in your M code to something compatable with "Connect Directly"