Excel export is not working while using Field Parameters

[alicialcaide]

Hi!

I've used the new functionality "Field Parameters" to dinamically select the dimensions to add as rows in a matrix. When I try to export the data in the matrix in Power BI Desktop, It seems it is not exporting it correctly. It exports only those columns that are not part of the Field Parameter table / selector. 

Is it happening to more users? Is there any solution to fix it? 

Thanks in advance.

Regards.

Alicia.

[GaryH · Accepted solution]

This is an issue for us when using through a premium workspace.  It seem the "Data with current layout" option is working as expected, however the "Summarized Data" and "Underlying Data", just seem to exclude any field parameters.

[Hariharan_R]

Hi

This is a bug which i already reported to Power BI team and it should be addressed in next release.

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[GaryH]

Hi Hari.  Do you have a link to the bug report.  Seems to still be occuring after last release.

[v-cgao-msft]

Hi @alicialcaide ,

What version of DESKTOP are you using?

The version I tested was Version: 2.106.582.0 64-bit (June 2022). The results of the test are normal.

Try installing and using the latest version of DESKTOP.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[alicialcaide]

Hi, I have the lastest version and it's not working for me. Only in Premium Workspace, using the option "Current layout" to export data.

[alicialcaide]

I have tried with a dashboard published in a Premium Workspace, and it seems it works. So, maybe it just a thing related to Power BI Desktop, I will keep testing the functionality in case there's any additional issue.

[CloudHerder]

Same here. It largely defeats the purpose.

[Hariharan_R]

Hi,

I am also facing same issue and looks like it is a bug. I hope this should be fixed soon. If we choose Table visual then we are getting all the columns.

Thanks

Hari