Forum Discussion

aspardo's avatar
aspardo
Regular Visitor
10 years ago

New to BI. Writing SQL queries to parse data. I am obviously missing something.

Started using Power BI on the recommendation of a friend. It looks well made and powerful, so I hope to stick with it.   I am pretty decent with SQL and can write some lengthy queries. My goal is t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

How can I edit the query when I'm using the BigQuery connector?

The bigQuery connector just allow me to select a table, but I need to make a different sql to correlate 2 tables with several gigabytes of data. The result has only 3800 rows and that is what I want to bring to powerBI.

 

I cannot change my odbc connections, but I can use the BigQuery connector.

 

Can I edit the SQL in PowerQuery advanced editor?

 

Thanks a lot

newpi's avatar
newpi
Icon for Helper V rankHelper V
6 years ago

Anonymous Not clear if you are asking a question. From what I understand you want to merge two tables using a query in Big Query and bring in only that data right which is 3800 rows. What you can do is write your SQL query in Google BQ Console and then save that data as a view under a project. Then in Power BI, connect to that view instead of those 2 tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for the quick answer newpi .

     

    I know I can proceed as you described. My question is if there is a way do specify the SQL in the connector configuration.

    As example, for oracle we can write in advanced editor:

    let
    Source = Oracle.Database("dbHost/db",[HierarchicalNavigation=true, Query="select field from table where condition"] )
    in
    Source

     

     

    Can I do the same with bigquery connector? how? I tried the same but the "Query" parameter does not work 😞

     

    I'm using:

    let

       Source = GoogleBigQuery.Database([BillingProject="projectid"])
          {[Name="projectid"]}[Data]
             {[Name="myDataset",Kind="Schema"]}[Data]

                 {[Name="myTable",Kind="Table"]}[Data]

    in

       Source

     

    Documentation is not clear nor can't find the possible options for the connector

     

    Thanks to all