Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
v-saelzler
New Member

Different Date Formats Using Live Connection to the Same Data Model

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?

1 ACCEPTED SOLUTION
rsbin
Super User
Super User

@v-saelzler ,

This is how I would handle it:

rsbin_0-1666117702141.png

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,

 

View solution in original post

1 REPLY 1
rsbin
Super User
Super User

@v-saelzler ,

This is how I would handle it:

rsbin_0-1666117702141.png

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,

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.