Forum Discussion

Mark_Ball's avatar
Mark_Ball
Frequent Visitor
5 years ago
Solved

Issue merging two tables from Biq Query

Good day, I am looking for help resolving an issue with merging a dimension table to my fact table. The data is being pulled in from Big Query. The two columns match data type in Power Query. When I...
Need Help
  • Mark_Ball's avatar
    Mark_Ball
    5 years ago

    Thank you Miguel, I did see that post when i was searching the web. Yesterday, I worked with our Google contact and he said it is the SQL query that PBI generates and passes to BQ that is causing the error (extra parenthesis and equal sign). Although not a solution, i am using a work around for the interim using an Inner Join. I just have to keep an eye on new GL accounts being added by our Finance team.

    The other solution Google offered was to use an ODBC connector and the Simba driver (link below) this way i can write my own SQL query that passes to BQ. I'll test this method out in the next couple of days.

    Simba link: https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

     

    Thank you,

    Mark

     

Mark_Ball's avatar
Mark_Ball
Frequent Visitor
5 years ago

Thank you Miguel, I did see that post when i was searching the web. Yesterday, I worked with our Google contact and he said it is the SQL query that PBI generates and passes to BQ that is causing the error (extra parenthesis and equal sign). Although not a solution, i am using a work around for the interim using an Inner Join. I just have to keep an eye on new GL accounts being added by our Finance team.

The other solution Google offered was to use an ODBC connector and the Simba driver (link below) this way i can write my own SQL query that passes to BQ. I'll test this method out in the next couple of days.

Simba link: https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

 

Thank you,

Mark

 

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Mark_Ball ,

     

    Good to know that you got an answer altough not a perfect one. If you think the solution is this one please don't forget to mark your answer has the correct one so it can help others.