Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
I noticed that the following is still a limitation
- Format strings on columns and measures from a remote source are not imported to the composite model. We are looking for your feedback to prioritize this.
When is it expected that this will be fixed? It's quite a dealbreaker for us, since the reports show up with wrong formatting!
I am facing the following scenario:
I am connected to 2 datasets in a composite model. These 2 datasets use direct query both of them. In the composite model I create relationships between tables in the 2 models. One thing I notice is that formatting on measures is gone. F.eks, in dataset a measure is formatted as percentage 3%, whereas in composite model same measure shows 0,03 when used in reports. Or in dataset a measure is formatted as currency with no decimals, and in composite model same measure shows without currency and with decimals. Date columns modify their formatting. Columns that should not summarize, all of a sudden sum. Also, descriptions of measures and columns are not there in the composite model either.
We are holding off using them for exactly this issue
- jeroenterheerdt5 years ago
Microsoft Employee
stay tuned, good news should come soon!