Unable to refresh/load composite models in DirectQuery Mode

Lorili · ‎02-20-2023

We are working with several composite models based on a PowerBI dataset. When we go to PowerBI Desktop and refresh the data of a report using a composite model, then we get the following 2 error messages:

Depending on the PowerBI dataset another formatstring measure seems to be conflicting. Why PowerBI adds these Format String measures automatically is also puzzling me.

We noticed this problem for the first time on Friday (17/02/2023)

PBIHelpMe · ‎02-20-2023

Hello,

We have the exact same issue here :

And the exact same error about FormatString.

v-dmsyrk-msft · ‎02-20-2023

Hello,

Product Team is aware of the issue and will release a QFE this week.

Thanks,

Dmytro

v-xiaoyan-msft · ‎02-20-2023

Hi @Lorili ,

Please wait patiently for updates from the product team.

Best regards.
Community Support Team_ Caitlyn

kavimk · ‎02-21-2023

Unable to refresh/load composite models in DirectQuery Mode

For user:

The issue with feb release power bi desktop version, try to use old version of Power bi desktop

MS Team,

Pl look in to the feb release desktop version

v-dmsyrk-msft · ‎02-22-2023

Published the version 2.114.803.0 that should address the issue.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Olha_Protsak · ‎02-23-2023

We have the same issue here. Could you please update on when to expect the resolution?

v-dmsyrk-msft · ‎02-24-2023

Hi @Olha_Protsak ,

Wanted to ask you to share the version from Help -> About dialog and the error screenshot. Wondering if this is a different issue.

Thanks,

Dmytro

Olha_Protsak · ‎02-27-2023

Hi @v-dmsyrk-msft ,

Here is my version.

On Friday I get to resolve the permanent issue by upgrading my Tabular Editor to the newest version 2.17.2
@Lorili Could you try it on your side and tell us if this helps?

LudwigWoo · ‎02-27-2023

Still getting the same issue with the new version.

v-dmsyrk-msft · ‎02-27-2023

Hi, @LudwigWoo,

Wanted to ask you to send the error message. So we can check if this is the same issue. Product Team fixed the original 'FormatString' error in QFE1 build.

Thanks,

Dmytro