Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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. Possible Solutions:
So there is strong suspicion that the issue exists on the AAS side.