Create index from Custom Column

[vehau1]

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 query, due to the large dataset and the limitations on my RAM and cache.

So how do I proceed in creating a index column that will be accepted as a native query? Thanks

[v-piga-msft]

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

[vehau1]

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. 

[cooler1978]

Hello.

If you still there, i have the same problem, how did you solved this problem?