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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

"Show data point as table" not showing columns from other tables using a mixed model.

Hello,

 

We are using a PowerBI mixed model (The report is using the data sources "Azure Analysis Services" mixed with SharePoint lists).
It appears an issue has been introduced over the past few weeks where a user can’t use the Show data point as table and return columns which are from different tables which have one to many relationships. 

 

Last week the issue differed from this week. When a user tried to use the Show data point as table, they would be presented with the following screen.

Kraken_0-1677660011312.png

 

This week however it appears to be a different issues.
It now will return only columns from one table and ignore the other. It appears to be the table which the axis is using.

 

Is this a known issue as around a month ago, this issue was not present?

This issue is also present within Desktop & Service.


Any advice would be appreciated.

 

Thank you

 

Status: Needs Info

Hi @Kraken 

Which data source is the one not displayed in the visual ?

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @Kraken 

Which data source is the one not displayed in the visual ?

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Kraken
Advocate I

Hi @ Ailsa-msft.

In my testing on this, this issue occured on a Vertical bar chart in this example. 

Kraken_0-1677832854758.png

 

[Table 1] is on the [X-Axis] and [Table 2] is on the [Y-Axis].

 

It would only return the results from table 2. It appears that its only returning the results from the arrgragation column. 

 

Thank you