Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In Pandas (Python library), you can call an inspect() function which returns details such as the total number of rows and the number of nulls and errors in each column.
Is there any similar feature in Power Query?
In particular, I like knowing exactly how many rows there are in each query, as I can then use this as a quick way to check if a merge has worked as expected.
The attached photo shows an example of '999+' rows, which is not that useful! I appreciate that it may not be practicable to actually load millions of rows at a time, but surely just getting the number of rows is an easier task in computational terms?
Thanks.
Solved! Go to Solution.
Something else you can try @Anonymous is using the built in visual components of Power Query below. Check out the View Tab in Power Query:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHello @Anonymous
Try Table.Profile ( create a new query and input you queryname into this function). When you just need the rows use Table.RowCount.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thanks, will look into that solution asap and report back. Appreciated.
Something else you can try @Anonymous is using the built in visual components of Power Query below. Check out the View Tab in Power Query:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@edhans Thanks, that's exactly what I was after.
@Jimmy801 unfortunately I couldn't get your solution to work; I think I may have the syntax wrong?
For the table TestTable, I created a new blank query, but none of the following worked:
TestTable.Profile
Table.Profile(TestTable)
TestTable.RowCount
Table.RowCount(TestTable)
I am guessing I misinterpreted the intended formula? Thanks.
@Anonymous do this to get Table.Profile to work.
= Table.Profile(#"Added Index")
Then delete that step when done with your analysis.
You can also create a new query that will always profile given query:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting