Power query

[AtchayaP]

I have huge data around 47000 rows.I have to check all the datas , is that possible in Any other way? As I'm scrolling down it is taking time to load to scroll down

[Vijay_A_Verma · Accepted solution]

1. Insert one index column. Then you can filter your data on the basis of index...Say, if you want to see the data between 10000 to 11000 rows, put a filter appropriately on Index.

While this will not remove Scroll down, but you can reach to a record very fast if you know its position.

2. But I will tell you another way which I would have done. Right click on table name on right side in Power BI Desk - Copy table - Paste into Excel

Excel will offer very fast scroll down / navigation and also has analytical capability.

[AtchayaP · Accepted solution]

I tried with 2nd option but I haven't t got all columns

[Vijay_A_Verma · Accepted solution]

It will give you all columns which are shown in the display of Power BI. Hence, for example if you have removed 2 columns through the use of PQ, those will not be reflected. If you have filtered data, then filtered out rows will not appear.

There is a way to exract entire table from your Power BI model. You need open source tool Dax Studio. Learning curve is hardly 5 mins, it will extract all columns and rows of the table, hence if you have removed columns or filtered rows, that won't matter.

Just search for extract data using DAX studio on youtube and you will get plenty of results.

[AtchayaP]

Thank you

[Vijay_A_Verma · Accepted solution]

1. Insert one index column. Then you can filter your data on the basis of index...Say, if you want to see the data between 10000 to 11000 rows, put a filter appropriately on Index.

While this will not remove Scroll down, but you can reach to a record very fast if you know its position.

2. But I will tell you another way which I would have done. Right click on table name on right side in Power BI Desk - Copy table - Paste into Excel

Excel will offer very fast scroll down / navigation and also has analytical capability.

[AtchayaP · Accepted solution]

I tried with 2nd option but I haven't t got all columns

[Vijay_A_Verma · Accepted solution]

It will give you all columns which are shown in the display of Power BI. Hence, for example if you have removed 2 columns through the use of PQ, those will not be reflected. If you have filtered data, then filtered out rows will not appear.

There is a way to exract entire table from your Power BI model. You need open source tool Dax Studio. Learning curve is hardly 5 mins, it will extract all columns and rows of the table, hence if you have removed columns or filtered rows, that won't matter.

Just search for extract data using DAX studio on youtube and you will get plenty of results.

[AtchayaP]

 used index columns, but it is showing 1000 values reached.

[Vijay_A_Verma · Accepted solution]

You will have to use Number Filters - Between