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
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