Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to test Power BI to see if it can suit our needs for dashboard and report creation, but am hitting my head against a brick wall whilst playing with it on my own.
I have connected to an ODBC datasource we have on premise, and I see the query editor with a preview of results.
Some issues I have are;
From the point of having datasource connected, how can I:
Create a query that returns only specific columns, where columns A, B and C are equal to some value?
Many thanks
James
Solved! Go to Solution.
Hi @Eds1989
As for your requirement "Create a query that returns only specific columns, where columns A, B and C are equal to some value”, i make a test as below.
let Source = Excel.Workbook(File.Contents("C:\Users\maggiel\Desktop\case\6\6.13\first query.xlsx"), null, true), Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data], #"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"col1", Int64.Type}, {"col2", Int64.Type}, {"col3", Int64.Type}, {"A", Int64.Type}, {"B", Int64.Type}, {"C", Int64.Type}}), keeprows=Table.SelectRows(#"Changed Type",each [A]=5 and [B]=5 and [C]=5) in keeprows
Best Regards
Maggie
Hi @Eds1989
As for your requirement "Create a query that returns only specific columns, where columns A, B and C are equal to some value”, i make a test as below.
let Source = Excel.Workbook(File.Contents("C:\Users\maggiel\Desktop\case\6\6.13\first query.xlsx"), null, true), Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data], #"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"col1", Int64.Type}, {"col2", Int64.Type}, {"col3", Int64.Type}, {"A", Int64.Type}, {"B", Int64.Type}, {"C", Int64.Type}}), keeprows=Table.SelectRows(#"Changed Type",each [A]=5 and [B]=5 and [C]=5) in keeprows
Best Regards
Maggie
Thank you for this!
Whilst I am not familiar with the query syntax for Power BI, this will obviously do the trick.
I think one thing I was struggling with, was that my datasource was giving me an error that prevented all rows from showing, preventing me from filtering on my required values.
After correcting the error at a database level, filtering through the GUI worked as expected too.
I also spotted the "Choose columns" button, to only show the fields I was interested in.
Am I correct in thinking, Power BI will always return ALL rows from a table, and then filter out the data? That seems inefficient compared to our other reporting tools, that filter directly in the qeury and only return the rows we have actually filtered for.
Thanks!
James
Can anyone help me?
The documentation Microsoft have provided around "Shaping Data", seems overly complex and not sure if it answers my basic queies.
Thanks
James
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |