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
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Bezos,

 

By my tests, if you install the Data gateway(personal mode) and edit the credential with Anonymous, then you could set up the schedule refresh.

 

 

Best  Regards,

Cherry

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