Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
inversia
Frequent Visitor

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

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:

 

Screenshot 2024-02-16 at 17.41.47.png

 

Could you help me, please?

Thanks,

A

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @inversia 

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

aj1973_0-1708130830342.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

3 REPLIES 3
aj1973
Community Champion
Community Champion

Hi @inversia 

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

aj1973_0-1708130830342.png

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thank you so much, now it's ok,

Alessandro

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)

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.