Forum Discussion
On Premises Gateway errors when merging tables
Hi Anonymous
BigQuery is a RESTful web service that enables interactive analysis of massive datasets working in conjunction with Google Storage.
When your dataset have data from BigQuery and PostgreSQL database(on premise) merged, to refresh successfully in Power BI Service, please refer to this article and this similar thread.
These references point out that:
When we have cloud and on-premises data sources merged or appended in a single query, to refresh them,
Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply,
Under this gateway cluster, add any on-premises data sources used in your queries. You don't need to add the cloud data sources here.
On the Dataset settings page for the new dataset:
- For the on-premises source, select the gateway associated with this data source.
- For the cloud source,Under Data source credentials, edit the cloud data source credentials, as necessary.
Make sure privacy levels for both cloud and on-premises data sources are set appropriately to ensure the joins are handled securely.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
BigQuery is a RESTful web service that enables interactive analysis of massive datasets working in conjunction with Google Storage.
When your dataset have data from BigQuery and PostgreSQL database(on premise) merged, to refresh successfully in Power BI Service, please refer to this article and this similar thread.
These references point out that:
When we have cloud and on-premises data sources merged or appended in a single query, to refresh them,
Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply,
Under this gateway cluster, add any on-premises data sources used in your queries. You don't need to add the cloud data sources here.
On the Dataset settings page for the new dataset:
- For the on-premises source, select the gateway associated with this data source.
- For the cloud source,Under Data source credentials, edit the cloud data source credentials, as necessary.
Make sure privacy levels for both cloud and on-premises data sources are set appropriately to ensure the joins are handled securely.
Maggie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.