google sheet

4 Topics

Google Sheets Connector doesnt refresh when published
I use PBI Report Server, I created a report in my desktop and can connect to google sheets with the appropiate credentials and works just fine, refreshing and everything. Google sheets is the only source used for the report. The problem comes when I upload the report to the server as it stops refreshing, it just shows the data available at the time of publishing, never to be refreshed again, and there is no option to set a scheduled refresh or modify the connection source (they are greyed out). What is the point of having a google connector when it only works in desktop mode (for report server at least)?
Solved
odonnelljuan
2 years ago Place Report Server
2.1KViews
0likes
2Comments
"Having trouble refreshing Power BI reports connected to Google Sheets. How can I resolve this issue
I am using Power BI Report Server, and all my data sources are stored in Google Sheets. I have published the report onto my personal report server. However, I am encountering an issue where I am unable to refresh the data. Manual refresh attempts are not yielding any changes, and the option for Auto refresh is grayed out. The error message I am receiving states: "Scheduled Data Refresh is not available for reports. The report does not have any external data connections defined or is using an unsupported data source." I would greatly appreciate any assistance in resolving this issue.
Kasra
2 years ago Place Report Server
859Views
1like
2Comments
Schedule refresh
I am receiving this error : The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Cloud data source refresh is not allowed in gateway setting."}}],"exceptionCulprit":1}}} Table: Total Calls per day. Also note : one of data source is google sheet manual refresh is working well, I tried to download gateway again If any one can help, thanks
Solved
MKYZ22
3 years ago Place Service
1.3KViews
0likes
1Comment
Google sheet connector in data gateway
Hi! I am using the google sheet beta connector in Power BI desktop and it's working great. However, I can't seem to add it as a data source to my On-premises data gateway, so I can't schedule a refresh. Does anybody know if there's a way around this?
Solved
Anonymous
4 years ago Place Report Server
4.4KViews
0likes
4Comments