Problem with Analysis Services, relationships and PowerBI Desktop

Hi Anonymous ,

I found the following description in the blog What Fields to Hide in Your Power BI Solution?.

If there is a field, that you need to bring into the model for any reason, but won’t use it in visualization, then this is a good candidate to be hidden. here are some of these types of fields:

• Fields used in a Relationship
• Fields used to Sort Other Fields
• Fields used in Hierarchy
• Fields used in DAX Calculations, but not in visuals directly

I think the field used in the relationship might be the situation you are facing. The following is a detailed explanation:

In the example below; DimProduct and FactInternetSales are related to each other using ProductKey:

We cannot remove the ProductKey from this model, because we need it to connect the two tables. However, for users, the ProductKey is unnecessary, because they will use other Product columns such as Product Number, Name, Size, Color, etc. So these fields are a good candidate to be hidden from the report view (from both tables).

Sorry, I don't know the language in your picture very well. But after my general research, I found these posts may be helpful to you, please refer to:

https://community.powerbi.com/t5/Service/Couldn-t-load-the-data-for-this-visual-Working-in-Desktop-but/td-p/400301

https://community.powerbi.com/t5/Service/Could-Not-Load-the-Data-from-this-Visual/td-p/431773

https://community.powerbi.com/t5/Service/could-not-load-data-for-the-visual/td-p/52903

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.