Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Export Data Error

Hi,

 

While exporting data from a "matrix" visual, Power BI Service throws an error. The matrix uses a calculated measure, which is based on a parameter.  I have attached the error.

Error

 

When I try to export data for same visual but without the measure, which uses parameter, there is no error.

 

Please provide your expert opinion.

 

Regards,

Vinay Singh

Need Help

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    In your scenario, I think you have permission to export data because you can export without measure, so I list some reason may be cause by the limitation of export data blow:

     

    1. Export using Underlying datawon't work if you enable the Show items with no data option for the visualization Power BI is exporting.

    2. The maximum number of rows that the applications can export from an import mode reportto an .xlsx file is 150,000.

    3. When using DirectQuery, the maximum amount of data that Power BI can export is 16 MB uncompressed data. An unintended result may be that you export less than the maximum number of rows.

    4. In Power BI, you can rename a field (column) by double-clicking the field and typing a new name. Power BI refers to the new name as an alias. It's possible that a Power BI report can end up with duplicate field names, but Excel doesn't allow duplicates. So when Power BI exports the data to Excel, the field aliases revert to their original field (column) names.

     

    You can find the full limitation of export data here: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

    And look into the similar scenario here: https://community.powerbi.com/t5/Issues/Not-able-to-Export-underlying-data/idc-p/621772#M38734

     

    I run a simple test as your describe, I can export data in both matrix

    BTW, pbix as attached, you can try to use this to test if problem is in your data.

     

     

    Community Support Team _ DongLi
    If this post helps, then please consider Accept it as the solution to help the other members find it more

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,


    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

     

    Best regards,

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