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

So if I install the personal gateway, the report will refresh, but only if my laptop is powered on. So this is not a solution afterall :(

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    If its SharePoint Online, you wont need a gateway, but if its SharePoint on Premise you will.

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

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