Forum Discussion
PowerQuery - Table.Profile() not able to calculate
Hello, I have the following problem with Table.Profile() function. Standard output is as follows: I need to perform Table.Profile() on table that has 130 columns and around 2 milion of rows...
Thank you for quick answer.
I did a manual work, but the problem is not solved. In order to perform transformations PowerBI needs to switch from Direct Query to Import Node so all calculations are performed locally. I did several tests but it takes too long, so can not accept it. Finally, we wrote a T-SQL procedure to calculate the KPI's