Different Date Formats Using Live Connection to the Same Data Model

[v-saelzler]

Goals:

• Create two PBI reports. (done)
• Connect both reports to the same SSAS database. (done)
• Format the date fields in UK format for one report, and US format for the other report. (issue)

Architecture:

On-Prem SSAS Database (Tabular Data Model)

-> Live Connection / Direct Query -> PBI Report for New York (US) Users

-> Live Connection / Direct Query -> PBI Report for London (UK) Users

The model currently displays US format dates. I tried changing the UK report, but was blocked by an error message.

File > Options and Settings > Options > Current File > Regional Settings

"Regional settings aren't available, because this file uses a live connection to another model"

Are there any workarounds?

[rsbin · Accepted solution]

@v-saelzler ,

This is how I would handle it:

This is within my Dim_Date table in my tabular model.  If you are not using a Date Table, then just create another column in your Fact Table.  Modify the UK Report to use this additional Date field.

I hope this helps to resolve this issue.

Regards,

Regards,