Scheduld Refresh with Web Source Not Working

[DanielOrj]

Hi all.

I have a connection with Google Sheets and I can refresh my data with Power BI Desktop, but when I try to use the report server to create a scheduled refresh appear an error with the connection server, I put the credentials also and don't work.

any suggestions, thanks!

[Anonymous]

Hi Daniel,

Check below.

https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-connect-google-sheet-to-Power-BI...

[DanielOrj]

Hi @Anonymous 

I followed the link but the solutions are not available for 2019, my only issue is the Schedule Refresh with Web Source but actually, thanks for the help. I hope that somebody has any kind of solution for this.

[Anonymous]

Hi Daniel,

Can you use OneDrive or Sharepoint?

[DanielOrj · Accepted solution]

Hi @Anonymous 

I think that is the only viable solution right now, we create a shared folder and use xls or xlsx documents to refresh the file correctly. thanks for your help.