Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Kraken

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

Submitted by Advocate I on ‎03-01-2023 12:45 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎03-03-2023 12:03 AM

Hi @Kraken 

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

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Kraken
Advocate I
Advocate I
‎03-03-2023 12:37 AM

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

Idea Statuses