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

Thank you for your responses. Why does this code require a Gateway to be installed? Is there a way to allow the code to be refreshed without a gateway? I don't know if using the gateway is an option, as my computer is not always powered on.

 

I would like this to work without a gateway. I have a separate query that uses an excel file from sharepoint to create a report. This query refreshes automatically with some Sharepoint magic. Then, when I added the query above to the original query to get the time, it wouldn't let me automatically refresh with the Sharepoint magic. Does that make sense?

 

So is there a way to have the two queries together so that they both refresh automatically? 

 

Thanks.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Bezos,

     

    Actually, we don't need to configure the date gateway as your data source is online. 

     

    For online source, it will refresh automatically.

     

    However, if you want to set schedule refresh, you should set the data gateway. You could install your gateway in a server always online.

     

    Best Regards,

    Cherry

    • Bezos's avatar
      Bezos
      Regular Visitor
      7 years ago

      I'm actually unable to refresh the entire data set. This is what happens when I try and manually refresh the data from the workbook -> refresh now:This was my original question, why am I unable to refresh this data set?

       

       

    • newpi's avatar
      newpi
      Helper V
      6 years ago

      v-piga-msft I'm facing a similar issue. Unable to figure out why this is greyed out. I have connected to other data soruces successfully like Google BigQuery and my reports refresh daily. But now I'm using MYSQL query through an ODBC connection and after publishig the report on Power BI serivce, it shows greyed out and I cant seem to refresh.

       

      Can you help here? I'm seeking a solution without installing a gateway locally as my system would not be powered on always. And failing to understand why this is only hapening with this data source and not others?