Forum Discussion
Excel Export with live connection doesn´t support multi language reports?!
Hi BI2theRescue ,
The behaviour you are experiencing stems from the way Excel and Power BI handle language settings and functions. When you use Analyse in Excel, it preserves the language context because it interacts directly with the Power BI semantic model. When exporting data through an Excel export with a live connection, the process generates an Excel table that is not dynamically linked to the USERCULTURE function in the same way. This causes the data to be displayed in the base language of the report, rather than adapting to the user's current language settings.
To resolve this issue, consider the following workaround:
- After exporting, manually adjust the language settings in Excel. While not ideal, this may be a temporary solution.
- Since this is a limitation in the current function, providing feedback to Microsoft via the Power BI Ideas forum may lead to future enhancements in this area:Home (microsoft.com)
For more insight on how the USERCULTURE function works and its limitations, you can refer to the official documentation here:Use locale values in multiple-language Power BI reports - Power BI | Microsoft Learn
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply Anonymous .
Your first idea, to change the language settings in Excel, was the first thing that came to my mind but even when I change the Office Language to Polish the Excel File shows the data in German. I even went so far that I changed the Windows language to Polish to force the Excel output in Polish but this didn´t work out as well.