Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Lorili

Unable to refresh/load composite models in DirectQuery Mode

Submitted by on ‎02-20-2023 04:52 AM

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:

 

Lorili_0-1676897211289.png

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

Lorili_1-1676897264260.png

 

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

 

Status: Accepted

Hi @Lorili ,

 

Please wait patiently for updates from the product team.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
10 Comments (10 New)
Comments
PBIHelpMe
New Member
‎02-20-2023 07:03 AM

Hello,

 

We have the exact same issue here :

 

PBIHelpMe_0-1676905290683.png

 

And the exact same error about FormatString.

 

v-dmsyrk-msft
Employee
Employee
‎02-20-2023 12:41 PM

Hello,

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

 

Thanks,

Dmytro

v-xiaoyan-msft
Community Support
Community Support
‎02-20-2023 09:46 PM
Status changed to: Accepted

Hi @Lorili ,

 

Please wait patiently for updates from the product team.

 

Best regards.
Community Support Team_ Caitlyn

kavimk
Frequent Visitor
‎02-21-2023 08:27 PM

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
Employee
Employee
‎02-22-2023 09:42 PM

Published the version 2.114.803.0 that should address the issue.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Olha_Protsak
Frequent Visitor
‎02-23-2023 04:55 AM

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

 

v-dmsyrk-msft
Employee
Employee
‎02-24-2023 06:03 PM

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
Frequent Visitor
‎02-27-2023 03:26 AM

Hi @v-dmsyrk-msft ,

Here is my version. 

Olha_Protsak_0-1677497074277.png

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
New Member
‎02-27-2023 03:59 AM

Still getting the same issue with the new version.

v-dmsyrk-msft
Employee
Employee
‎02-27-2023 09:37 PM

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

Idea Statuses