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
Icon for Resident Rockstar rankResident 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