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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
MWojcicki
New Member

Power BI Composite model on AAS (in DirectQuery) and other source - An unexpected exception occurred

Hi,

Simple case o using Power BI with composite model. Model is based another AAS model (Azure Analisys Services, Tabular Model - DirectQuery Mode) and something else like table in Power BI or imported csv file which enrich dimension structure.

Semantic Model (in Power BI) is prepared in Mixed Mode:

* model A from AAS is in DirectQuery

* additional source is imported

Between table [Date] from model A na other imported table [_Year dict] there is relation :

MWojcicki_0-1732280281097.png

... and it doesn't work. When I use on the same visualisation attributes from [Date] and [_Year dict] tables I get error:

OLE DB or ODBC error: An unexpected exception occurred.
from Power BI error tracking there is something more:
ProviderGenericMessage=[OLE DB error: OLE DB or ODBC error.], ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Failure encountered while getting the next row in the result-set]
 
Model in AAS work fine it if is alone. I tested with 1500 and 1600 compatibility mode.
Power BI is in newest november 2024 version.
 
I'm 100% sure that it was OK few weeks ago (til end of october 2024).
 
Something what I noticed extra:
If AAS model is in InMemory model - it works fine
When it is in DirectQuery (Tabular) model - there is problem as You read.
3 REPLIES 3
MWojcicki
New Member

Hello,

 

Someone cen confirm if it is possible to build composite model on AAS with model in DirectQuery (no Inmemory) ?

rohit1991
Super User
Super User

The issue arises because Power BI struggles to handle relationships between DirectQuery (AAS) and Imported tables in composite models, especially in DirectQuery mode for Tabular models. This was likely caused by a recent update (November 2024) since it worked previously.

Possible Solutions:

  1. Switch to Import Mode: Use Import mode for the AAS model if possible.
  2. Optimize Relationships: Ensure relationships between [Date] and [_Year dict] are properly configured with correct cardinality and filtering directions.
  3. Check Compatibility Mode: While 1500 and 1600 are supported, ensure your AAS model aligns with the expected compatibility level.
  4. Test in Prior Version: If it worked before, try rolling back to the October 2024 Power BI version.

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

  1. Switch to Import Mode - It is only workaround. I don't want to use full import mode because of: access to fresh data in AAS model, RLS on AAS level, 
  2. Optimize Relationships: I'm sure that it is OK 
    MWojcicki_0-1732283063543.png
    MWojcicki_1-1732283120850.png
  3. Check Compatibility Mode: While 1500 and 1600 are supported, ensure your AAS model aligns with the expected compatibility level - Checked - -it's OK
  4. Test in Prior Version: If it worked before, try rolling back to the October 2024 Power BI version - checked on  2.131.1203 (July 2024) version - the same effect - it doeasn't work

So there is strong suspicion that the issue exists on the AAS side.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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