Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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 :
... 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 fineWhen it is in DirectQuery (Tabular) model - there is problem as You read.
Hello,
Someone cen confirm if it is possible to build composite model on AAS with model in DirectQuery (no Inmemory) ?
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.
So there is strong suspicion that the issue exists on the AAS side.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
32 | |
19 | |
17 | |
16 | |
16 |