Forum Discussion
Create index from Custom Column
Hi there, I have a large dataset that needs indexing. I don't want to use the Power Query Index Column, because it is not query folding. I want to have all of my operations done in the native qu...
Hi vehau1 ,
By my tests and research, I'm afraid that the View Native Query is not supported for creating index column in query editor.
You could refer to the blogs below which may help you know this feature better.
https://www.mssqltips.com/sqlservertip/4563/power-bi-native-query-and-query-folding/
http://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query
Best Regards,
Cherry
I guess then I'll have to create a custom key based off the columns I already have, in order to circumvent this problem then. But thanks for the confirmation.
Hello.
If you still there, i have the same problem, how did you solved this problem?
