URL not applied for all rows in a table

[jalaomar]

Hi,

I have 2 tables were I have a One -to Many relationship and I combine data from both sources in a table visual.

and then apply the URL for each uniqe Request ID but noticed that it only works for Request ID existing in both tables only.

when I remove the highligthed columns from the visual table (see screenshot), the URL works for all request ID's.

Is there a way to ensure that the URL works for all rows even when cobining the data from both tables.

[Anonymous · Accepted solution]

Hi @jalaomar ,

Ensure that the relationship between the two tables is correctly set up to reflect the One-to-Many relationship you mentioned. Incorrect relationships can lead to unexpected behavior in how data is combined and displayed. More details Model relationships in Power BI Desktop - Power BI | Microsoft Learn

When you remove certain columns and the URL starts working for all Request IDs, it might indicate that those columns are somehow filtering or affecting the visibility of your data. Ensure that there are no filters applied to these columns that might restrict the data being displayed in your visual.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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