Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I'm trying to create an index column but unfortunately I'm getting the following error. I think it's because the data is coming from a Data Warehouse that it won't allow me to edit and create the index column as normal?
Is there a calculated column code I can use instead that will work?
Solved! Go to Solution.
@amitchandak Thanks for your contribution on this thread.
Hi @gbarr12345 ,
Which applied step did you get the below error message? According to the screenshot, it seems that it got error when got the data from the data source... If you fail to get the data, then you definitely can't do the following steps. Please make sure you get the data first. Could you please provide the applied codes in your advanced Editor and explain which step got the error for further troubleshooting?
Applied codes in Advanced Editor
In addition, ycan refer the following links to add index column:
In Power Query Editor:
Add an index column - Power Query | Microsoft Learn
By DAX:
DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft
Index_Column = RANKX(ALL(Table[Column]), Table[Column])
Index_Column = COUNTROWS(FILTER(Table, Table[Column] <= EARLIER (Table[Column])))
Best Regards
@amitchandak Thanks for your contribution on this thread.
Hi @gbarr12345 ,
Which applied step did you get the below error message? According to the screenshot, it seems that it got error when got the data from the data source... If you fail to get the data, then you definitely can't do the following steps. Please make sure you get the data first. Could you please provide the applied codes in your advanced Editor and explain which step got the error for further troubleshooting?
Applied codes in Advanced Editor
In addition, ycan refer the following links to add index column:
In Power Query Editor:
Add an index column - Power Query | Microsoft Learn
By DAX:
DAX 101: How to Create a Calculated Index Column in Power BI - Monocroft
Index_Column = RANKX(ALL(Table[Column]), Table[Column])
Index_Column = COUNTROWS(FILTER(Table, Table[Column] <= EARLIER (Table[Column])))
Best Regards
@gbarr12345 , In import mode, you can create an index column, it will not fold back to the source.
I think because only sample rows got loaded in last step- it just passed. Seem like it is erroring because of some data issue in step one when the index is created in step 2.
Increase the time out by using advance connection options and try
Hi Amit,
Where exactly would I find those in power bi?
I'm looking and can't seem to find them.
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |