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: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

GM_AZ

Feb Release Bug - No error message on failed relationship link

Submitted by on ‎03-03-2025 03:26 PM

Hi all

 

I have just come across what I think is a bug in the relationships view of PBI Desktop. 

 

When I drag the primary key from one table to the key field of another table to establish a relationship (which has always worked) I get the standard popup for 'New Relationship'. However on both tables it says 'A preview of this table isn't available' which is strange as the tables are pretty simple. there is no message as to why

 

When i set the settings for the relationship, i tick the 'Make this relationship active' button and it doesn't provide any feedback as to it being unsuccessful, then I press 'Save'. I get the 'Working on it' and spinning wheel, but nothing happens, the relationship does not establish.

 

What i realised is there is in fact ambiguous relationships as a result, so that relationship I was trying to make can't work, once I removed those other relationships, I was able to successfully establish the intended new relationship. However, troubleshooting this took me an extra bit of time to work out, where as previously PBI told me that immediately.

 

In short - it seems there is no live relationship checking prior to saving the relationship.

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎03-03-2025 10:29 PM

Hi @GM_AZ ,

 

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

FAY2020
Resolver I
Resolver I
‎03-13-2025 01:12 AM
This is also happening to me. I will raise a support ticket. Here is a preview of the issue on my end: https://imgur.com/a/TF9XUrF
staicy17
Regular Visitor
‎03-18-2025 08:37 AM
Creating relationship- Feb 2025 version of PBI I have a more basic issue, but found your post and thinking somehow its connected. I am facing issues creating relationships between table columns and displaying the result. Need to add that I am using a filter in the transform window to filter out a subset of data from Table 1 say on Col A of Table 1 the filter is applied on and only want the relevant information from Table 2 for the filtered values of Table 1 to be displayed. Table 1 and Table 2 are related on the filtered Col A of Table 1 to the corresponding column of table 2. The result is displaying blanks, and a workaround would be to filter out the blanks, but the relationship functionality is broken in my opinion. I did not have to do this filtering out in the past if the filter(transform window) and the relationship was defined properly.
Idea Statuses