Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Export underlying data

HI

I am exporting underlying data from my report(Matrix), and i am getting the correct count of rows, but all columns are not included in the excel data, i wants to export the data with all columns which are there in source table, is there any way to do this. Can anyone help me on this. Thanks in advance

 

Rajmohan 

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    I got information that when using the “export underlying data” option in Power BI Service, the export file will contain columns which are used to create the visual together with all “Text” type columns. If you want to export all columns, you would need to set the rest columns to be “Text” type  or include the rest columns in your Matrix visual.

    Thanks,
    Lydia Zhang

  • arielfilipa's avatar
    arielfilipa
    9 years ago

    Hi,

     

    I'm also having the same problem and from my side the issue is that I'm using a calculated measure and I'm trying to find some option to solve this but still no luck :-(

22 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Try to change the datatype of the measures and lets try it, you'll get all the data

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous Which columns are missing? Are they measures or calculated columns? Is there a threshold, such as, you have 20 columns and only the first 18 are showing -> or something to that effect?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi

      Those columns are not calcualted columns, like we have a employee table, we applied filters like location,billing status etc.,while we are exporting data, some columns like DOJ,Ageing(these are not calculated columns) missing,and there is no threshold out of 47 columns i am getting 33 columns, that to those are not in order

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        Do you take the operation that export data in Power BI Service or in Power BI Desktop? If you export data in Power BI Service, please help to post screenshots about your scenario. Also try to create Matrix visual in Power BI Desktop and check the export result.

        If you are using Power BI Desktop, would you mind sharing me the PBIX file with which I can  test?

         

        Thanks,
        Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI All,

     

    After I publish the dataset to Premimum workspace. When I create a report with Table visual on Top of dataset withrequired fields.

    When i try to export the visual I see the in the excel output saying it has exceeded the limit count of 150000 rows but where it actually doesnt  have that many rows.

     

    Any tips why Excel is showing wrong count of data. when exported to excel. Any chnages need to do in Options.

     

    Thanks in advance. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    First we have to enable the option in PowerBI desktop to download the underlying data and it can do only 150,000 rows.

     

    https://www.youtube.com/watch?v=p2NN0Mxputc

     

    Just create a summarized table and from there you can easily download the data with or without filters.

     

    Thanks,

    Karthik

     

  • vinitshah's avatar
    vinitshah
    Regular Visitor
    4 years ago

    Hello, 

     

    I have a power bi dahsboard with multiple visuals. 

    Issue: When I try to export the data for a specific visual in summarzed or underlying data it does allows me to do both but where in some visuals gives me the option to export only in summarized format and the underlying data is greyd out. I also checked the options and settings where the it is enabled fo users to export data in both format.

    Please let me know if you need more light on the issue.

    Thanks in advance.