Error in Connection Mixed Data Source (SQL Server onPrem and BigQuery)

[inversia]

Hi all,

thank you in advance.

Since I'm a beginner in Power BI.

I developed a Dashboard with tables from different Data Sources: BigQuery and SQL Server onPrem. The Tables are linked with many types of relationships.

On Power BI Desktop all works fine. When I try to upload on Power BI Service and start the refresh (almost all tables are incremental refresh configured), I receive Gateway Timeout.

I noticed that when I work on Power BI Desktop, Google Big Query Logs shows the dedicated service account queries, instead when start the PowerBI Service refresh nothing appears as if no one is querying the tables.

The suspicion is something is missing in the configuration, below is the gateway connection screenshot:

Could you help me, please?

Thanks,

A

[aj1973 · Accepted solution]

Hi @inversia 

Even though I don't understand the message of the Gateway but you need to add you Big Query to the Gateway

[inversia]

Thank you so much, now it's ok,

Alessandro

[inversia]

Sorry, just one question: if I update the dashboard, like changing measure, add element, and so on, what's happening to the tables? The power bi service drop the tables and reload data ? (all the tables are incremental refresh configured)