cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Debbie Regular Visitor
Regular Visitor

code behind query

I'm new to Power BI and I'm trying to test a new simple tabular model.

 

I'm joining a dimension table to a fact table and another dimension table. There relationships are all 1:1. If I write the SQL directly in SQL Server Management Studio, I get the correct result (as expected from the source system client).

 

If I create a simple table visualisation in PBI - couple of data items from first dimension, a measure from the fact table and a couple of data items from the second dimension table, I get the wrong result - my fact table is picking up a different foreign key for the second dimension table. I have no idea why this is happening or how to troubleshoot. I've rebuilt & redeployed my model and refreshed my data source.

 

How do I see/check what Power BI is doing in the background so I can see where I am going wrong?

 

Debbie

1 ACCEPTED SOLUTION

Accepted Solutions
Debbie Regular Visitor
Regular Visitor

Re: code behind query

So... I won't say I figured it out because it still doesn't make any sense, but I made the problem go away by setting properties on the primary key in the offending table - set summarize to DO NOT SUMMARIZE and row identifier to TRUE. This fixed the issue.

 

No idea why. None of my other dimension tables were giving this error, but I set the properties on all the primary keys for consistency.

 

Debbie

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: code behind query

Hi @Debbie,

 

You can refer to below blog to find out the SSAS instance which power bi used to store data model:

Connect to Power BI Desktop Model from Excel and SSMS

 

After above steps, you can connect this instance and test/debug like a normal SSAS instance.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Debbie Regular Visitor
Regular Visitor

Re: code behind query

This looks really useful - many thanks! I will pick my way through the steps.

Debbie Regular Visitor
Regular Visitor

Re: code behind query

So... I won't say I figured it out because it still doesn't make any sense, but I made the problem go away by setting properties on the primary key in the offending table - set summarize to DO NOT SUMMARIZE and row identifier to TRUE. This fixed the issue.

 

No idea why. None of my other dimension tables were giving this error, but I set the properties on all the primary keys for consistency.

 

Debbie

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 56 members 1,086 guests
Please welcome our newest community members: