Forum Discussion
Power BI semantic model vs composite model
I've created a connection to the semantic model of my company's tenant from the customer's tenant, a shared semantic model, and that works fine so far. But when I build the same report on both tenants this is what happens:
My company's tenant:
The customer's tenant:
Something strange is happening with the field format and don't have a clue how to fix this.
2 Replies
Hi Anonymous ,
Regarding your question, are both tenants in the same area? Different zones affect the display format of dates, times, numbers and currencies.You can try using the FORMAT function to display the format of the defined data.The data will be displayed in a consistent format regardless of the user's locale settings.
FORMAT function (DAX) - DAX | Microsoft Learn
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Sorry, I wasn't very clear in my question. In fact it's about a direct query to the source semantic model on another tenant. Both tenants are in the same area!
In the source model we use this string to format "€" #,0.00;"€" -#,0.00;"€ -" the amounts , but (as it seems) the direct query connection can not deal with it.