Forum Discussion
Scheduled refresh greyed out
Hi Dave,
I really found something. Your URLs are parsed as web contents. So Power BI uses Web.Page() function, which requires a data gateway. Please refer to power-bi/refresh-data#power-bi-desktop-file.
>>>If you are using the Web.Page function, you do need a gateway if you have republished the dataset or your report after November 18th, 2016.
I would suggest you save the Google docs as XLSX format.
Best Regards,
Dale
Yes they are web connectors. It works now that I am running a personal gateway. See screenshots. They are public URLs where anyone can connect as anonymous. I was hoping there was a way to get the Power BI dashboards to refresh from these data sources without running a gateway service on my laptop.
Hi mr-budd,
Since they are all public resource, can you share the links here? Then I can make a test.
Best Regards,
Dale
Hi Dave,
I really found something. Your URLs are parsed as web contents. So Power BI uses Web.Page() function, which requires a data gateway. Please refer to power-bi/refresh-data#power-bi-desktop-file.
>>>If you are using the Web.Page function, you do need a gateway if you have republished the dataset or your report after November 18th, 2016.
I would suggest you save the Google docs as XLSX format.
Best Regards,
DaleThanks Dale,
For simplicity, let's assume we are using Google Sheets only:
https://docs.google.com/spreadsheets/d/1RdJ8rLxerU56eW_TN4l6hLKjG16S_f53goIkVQeN_jM/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1a8Zpku-1Onk1caAyaSSiLckq63bCOJ_oEMCBTYn9Ubs/edit?usp=sharing
Regards,
Dave
Hi v-jiascu-msft
I have the same issue but for a sharepoint site, should I also change it to an excel and how would I go about that?
