topic Re: ExportTo API: Locale setting not used in Developer

ExportTo API: Locale setting not used

emourits — Tue, 18 Jan 2022 12:32:27 GMT

I'm using this API to export an embedded report to pdf and powerpoint: https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to

My users are based in the netherlands so I choose to hardcode 'nl-NL' as the locale for now. Unfortunately this setting does not result in a pdf with values in dutch culture settings (date and number formatting).

The (embedded) report is rendered correctly and switching my browsers culture also changes the formatting.

I've tried different locale strings: "nl", "nl-NL" and "nl-nl"

My code looks like this:

var effectiveIdentities = GetEffectiveIdentities(groupId, report.DatasetId);
            var powerBiReportExportConfiguration = new PowerBIReportExportConfiguration
            {
                Settings = new ExportReportSettings
                {
                    Locale = "nl-nl",
                    IncludeHiddenPages = false
                },
                Identities = effectiveIdentities,
                Pages = pages.OrderBy(x => x.Order).Select(pn => new ExportReportPage(pn.Name)
                {
                    Bookmark = new PageBookmark(state: filters)
                }).ToList()
            };

            var paginatedReportExportConfiguration = new PaginatedReportExportConfiguration(effectiveIdentities);
            return pbiClient.Reports.ExportToFileInGroup(groupId,
                reportId,
                new ExportReportRequest(fileFormat, powerBiReportExportConfiguration, paginatedReportExportConfiguration));

What am I doing wrong? Or is this a bug in the API?

Re: ExportTo API: Locale setting not used

AmosHersch — Tue, 18 Jan 2022 17:33:12 GMT

Hi,

Please don't create an export request with both powerbiReportExportConfiguration and paginatedReportExportConfiguration. you should specify only one of them based on the type of your report.

I verified Locale is working as expected.

Thanks,

Amos

Re: ExportTo API: Locale setting not used

emourits — Wed, 19 Jan 2022 09:06:38 GMT

It's still not working. I've removed everything non essential to simplify things:

var effectiveIdentities = GetEffectiveIdentities(groupId, report.DatasetId); var powerBiReportExportConfiguration = new PowerBIReportExportConfiguration { Settings = new ExportReportSettings { Locale = "nl-nl", IncludeHiddenPages = false }, Identities = effectiveIdentities, }; return pbiClient.Reports.ExportToFileInGroup(groupId, reportId, new ExportReportRequest(fileFormat, powerBiReportExportConfiguration));

Re: ExportTo API: Locale setting not used

AmosHersch — Wed, 19 Jan 2022 09:39:59 GMT

I don't see a reason it won't work for you, but it might help to see the request body as it was sent in the network (for example using fiddler traces).

Also if you can please share the request ID as returned from Power BI it might help us find the reason.

Re: ExportTo API: Locale setting not used

emourits — Wed, 19 Jan 2022 10:05:47 GMT

The ID of the Export is: MS9CbG9iSWRWMi1lODA3ZjEzZC1lZmEwLTQ3MzktYmJhYS05Mjg3MzE4MTFkOWNPU28zVEx4THB1RGF5eVd6NWFkM1JqSzJMWUtNVTVZY21WY3M0MFZUaWFjPS4=

I'll try and get the Fiddler trace working and respond with that later.

Re: ExportTo API: Locale setting not used

emourits — Wed, 19 Jan 2022 10:19:16 GMT

The fiddler trace:

POST https://api.powerbi.com/v1.0/myorg/groups/9652bddc-b890-4256-a219-900fec61378c/reports/116623fd-2e69-4af1-9f9a-30b17b36feec/ExportTo HTTP/1.1 Host: api.powerbi.com Authorization: Bearer xxxxxx User-Agent: FxVersion/6.0.121.56705 OSName/Windows OSVersion/Microsoft.Windows.10.0.19044 Microsoft.PowerBI.Api.PowerBIClient/4.1.01803.0001 Request-Context: appId=cid-v1:aa7a3e4e-095d-4072-8760-2b750dbd937a Request-Id: |d6785cbd6c5d4a4e026eb4d584d56e8c.1772c6e038dc6cee. traceparent: 00-d6785cbd6c5d4a4e026eb4d584d56e8c-1772c6e038dc6cee-00 Content-Type: application/json; charset=utf-8 Content-Length: 382 { "format": "PDF", "powerBIReportConfiguration": { "settings": { "locale": "nl-nl", "includeHiddenPages": false }, "identities": [ { "username": "xxxx", "datasets": [ "6b6c16c4-cef3-410c-b4e4-1d2c655e5466" ], "roles": [ "Reader" ] } ] } }

Re: ExportTo API: Locale setting not used

AmosHersch — Wed, 19 Jan 2022 12:26:06 GMT

We suspect that there's an issue with locale in "Export to File" REST API when your report resides on a Gen1 capacity.

We recommend upgrading the capacity to Gen2 where this feature works as expected.

Re: ExportTo API: Locale setting not used

erikmourits — Thu, 20 Jan 2022 09:28:41 GMT

Yes, upgrading to Gen2 fixed our locale problem. Thank you for your help.