Forum Discussion

inversia's avatar
inversia
Frequent Visitor
2 years ago
Solved

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:

 

 

Could you help me, please?

Thanks,

A

Need Help
  • aj1973's avatar
    aj1973
    2 years ago

    Hi inversia 

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

     

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    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's avatar
      inversia
      Frequent Visitor
      2 years ago

      Thank you so much, now it's ok,

      Alessandro

      • inversia's avatar
        inversia
        Frequent Visitor
        2 years ago

        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)