Forum Discussion
Error on the refresh from Google BigQuery data to power bi service report
Maybe I wasn't clear when I described the problem... Here's a clearer explanation. I used Power BI's built-in connector "Google BigQuery" on both the Desktop and Service versions but consistently encountered the above error message. Instead of using the built-in version, I opted for an ODBC/DSN connection with the Simba ODBC driver for Google BigQuery. With this, and after adjusting privacy settings to ensure consistency between the service and the desktop, I eventually managed to get the refresh to work on the service.
Hi boullen ,
Please try to merge on-premises and cloud data sources.
For more details, you could read related document: Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maybe I wasn't clear when I described the problem... Here's a clearer explanation. I used Power BI's built-in connector "Google BigQuery" on both the Desktop and Service versions but consistently encountered the above error message. Instead of using the built-in version, I opted for an ODBC/DSN connection with the Simba ODBC driver for Google BigQuery. With this, and after adjusting privacy settings to ensure consistency between the service and the desktop, I eventually managed to get the refresh to work on the service.