PBI BUG ? Data are not propagated via relationship

[Anonymous]

Hello,

I have following schema

with following tables and values

DATE

date	dateId
1.1.2024	1
2.1.2024	2
3.1.2024	3
4.1.2024	4
5.1.2024	5

QUEUE

queueId	AppId
1	1
2	1
3	2
4	2
5	3
6	3
7	4
8	4
9	5
10	5

App

AppID	AppName
1	App1
2	App2
3	App3
4	App4
5	App5

RESULTS

result	dateId	queueId
1	1	1
3	2	2
2	3	3
6	4	4
10	5	5
20	1	6
6	2	7
4	3	8
5	4	9
9	5	10

And data from DATE table are not propagated to my custom table even if foreign key is matched

as you can see in LEFT table is dateId taken from table Results and field date (taken from Date table) is blank, but Table Date has values as you see in right side

Based on relationship and their direction, everything is flowing to Results table where it should be connected but Date table is empty, is it bug ? or issue is in settings that I must allow something somewhere ?

thanks 

[Anonymous · Accepted solution]

Hi guys,

thanks for tips, but after reset PBI it works, 😄 maybe kept session somewhere ?

[Anonymous]

Glad to know it works! Next time if you experience the same issue, you can try clearing the Cache from File>Options>Data load>Clear cache, then perform a new refresh. 

How to clear cache in Power BI Desktop - Microsoft Fabric Community

Best Regards,
Jing

[Anonymous]

Hi @Anonymous 

I replicated the same model as yours using the sample data you provided, but I didn't have this issue. You can see that in the table visual below, the date column returns the corresponding date values. I have attached my test pbix, you can check if there is any difference between mine and yours. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[lbendlin]

Combine the queue and results tables into a single table.