Forum Discussion

emilyw316's avatar
emilyw316
New Member
6 years ago

Problem loading all rows of data

Hi,   I am running a large report that will produce 10,646 rows and 61 columns when complete.   My issue is trying to load all rows automatically without having to load them a few at a time. I al...
Need Help
Tips and Tricks
az38's avatar
az38
Community Champion
6 years ago

Hi emilyw316 

first of all we should define where exactly do you scroll the data

 

there are 3 options:

1. Power Query Editor mode. It is the only preview of data and it will be incomplete

2. Report mode Data window. It is the not the best way to copy data into Excel

3. Report mode visuals. It has Export data options. It will export to csv and after that you could split cell by delimiter. Read more here https://docs.microsoft.com/en-Us/power-bi/visuals/power-bi-visualization-export-data

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

  • emilyw316's avatar
    emilyw316
    New Member
    6 years ago

    Hi, Thanks a million for your responses. I unfortunately have "Data exceeds the limit" when I try to export to CSV by clicking the 3 dots in the visual. 

     

    I have a matrix in the Report view that is a little over 10.6k rows and 61 columns wide. I found the only way I can export data is if I copy and pase a column at a time into excel, which is incredibly frustrating. Not only is that tedius but before I can even do that, I have to load all the rows so I get all the data into excel. (if I do not load all first, it will only copy the loaded portion into excel.)

     

    To load all the rows I have to scroll to the bottom, more will load, scroll to that bottom, more will load, and so forth until all rows are loaded. then I begin my copy/paste hours of each column into excel. This takes almost 2 full working days to complete ! 

     

    Are you familiar with this issue and have any insight? I am (perhaps obviously) fairly new to Power BI and learning it for my company but running into these issues. 

     

    Thanks so much, appreciate you!

    • JarroVGIT's avatar
      JarroVGIT
      Resident Rockstar
      6 years ago
      Hi, what is your data source? The powerquery functions in PowerBi are readily available in Excel as well and if you load it to your datamodel in Excel it will create a new sheet with table holding all the information. That might work a lot better if you want to export to Excel anyway?
      Let me know if that works!
    • v-joesh-msft's avatar
      v-joesh-msft
      Solution Sage
      6 years ago

      Hi emilyw316 ,

      As mentioned before, I would suggest you use DAX Studio. An advantage of using DAX Studio is that it works great regardless of the amount of data you want to export.
      Refer to the resources below, you will find the method:

      Export Data from Power BI Desktop to CSV or TXT Using DAX Studio

      Export to csv from Power Query

      Best Regards,
      Community Support Team _ Joey
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.