Create index from Custom Column

Question

Hi there,&nbsp;&nbsp;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.&nbsp;So how do I proceed in creating a index column that will be accepted as a native query? Thanks

v-piga-msft · Answer

Hi&nbsp;vehau1&nbsp;,
&nbsp;
By my tests and research, I'm afraid that the View Native Query is not supported for creating index column in query editor.
&nbsp;
You could refer to the blogs below which may help you know this feature better.
&nbsp;
https://www.mssqltips.com/sqlservertip/4563/power-bi-native-query-and-query-folding/
&nbsp;
http://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query&nbsp;
&nbsp;
Best Regards,
Cherry

vehau1 · Answer

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.&nbsp;

cooler1978 · Answer

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

Forum Discussion

Create index from Custom Column

3 Replies

Related content

Creating a custom column

create custom column concatenated

Creating Custom columns

Creating custom columns keeps returning a structured Table column

Create a custom column