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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Composit model can't load data

Hey,

 

I have a composit model consisting of a SSAS tabular and an imported account schedule table (connected to the tabular model through a M2M account schedule bridge).

On my matrix visual i have 2 attributes(category and sub category) in rows and 1 in columns(department).  When uploaded to services this works great, but when uploaded with a filter (visual filter) on department  an error appears(the attribute in the column): An error occurred while retrieving data for this visualization.

 

In desktop all works great - its only a problem after upload. If i remove one of the row attributes or remove the filter then it works just fine.

 

 

 

https://community.fabric.microsoft.com/t5/Service/Composit-model-doens-nt-work-when-uploaded-to-serv...

Status: Investigating

Hi  @kelbi ,

 

Based on the above information, this issue is complex which may need to collect log files for further troubleshooting. Since community support engineers don't have that access, I would suggest opening a Support Ticket. If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @kelbi ,

 

I did a simple test but it didn't seem to successfully reproduce your problem, it worked fine for me.

Please verify that the relationships between your tables are correctly defined and that there are no circular dependencies or ambiguous relationships that might cause issues when filtering.
Or you may try applying different filters to see if the issue is specific to the department attribute or if it occurs with other attributes as well.

 

 

Best regards.
Community Support Team_Caitlyn

kelbi
Frequent Visitor

Hey,

I checked multiple times for ambiguous relationships and circular dependencies. This has worked for a long period - it started like to month ago and i thought i got it working again. The funny thing is that today it seems like its working on services but stopped in the pbix. In the pbix i get this error: "An unexpedted error accured (file "xldqas_filterctx.cpp!. line 459 funktion "FilterCtxFixer::WrapCalculate").

 

 

kelbi
Frequent Visitor

I was even succesfull getting it working for a short period of time by changing the attribute in the appartment deminsion - from the department name to department number.

v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @kelbi ,

 

Based on the above information, this issue is complex which may need to collect log files for further troubleshooting. Since community support engineers don't have that access, I would suggest opening a Support Ticket. If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

kelbi
Frequent Visitor

Hey,

 

I created a support ticked for this issue.