Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

Power query

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's avatar
    4 years ago

    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's avatar
    AtchayaP
    4 years ago

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

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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.

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    You will have to use Number Filters - Between