Dataflow: linked table doesn't update values - even with refreshing

[oBi1]

Hi group

So I had another interesting issue pop up when updating a dimension table.

Let's say the table has 3 columns:
1) key

2) description

3) value

Originally one line shows:

1 - blank cell - blank cell (this is intended for n/a records in the fact)

I set up the FACT dataflow using the DIM as a linked table and a data file as a linked table as a basis for the final FACT.

Now I noticed the merge operation on 'description' field gave me only a small amoutn of matches. I checked and found that in the data file the description field is not blank but has "n/a" in it.

So I went back to my Dimension data flow and replaced the line with the blank description with:

1 - "n/a" - blank

I was expecting a lot more matches, but got no extra. Going back to the FACT dataflow, I found that the linked table still shows 

1 - blank cell - blank cell.

I tried multiple times refreshing both dataflows, restarting my computer even, but the linked table continues to show the original line. I even tried removing and adding back in the linked dataflow. 

What is going on? Hopefully someone has a clue!

Thanks

[v-xianjtan-msft]

Hi @oBi1 

Please check the following:

1. Check the data source access permission and reconfigure the data source credentials.

2. Make sure that the data source you are updating in the dimension dataflow is correct and that the row containing “n/a” have indeed been updated in the data source.

3. Delete and re-establish the link between DIM and FACT, ensuring that the linked table points to the most recent data.

4. Place DIM and FACT dataflow in the same workspace and try again.

Refer to links:

Link tables between dataflows - Power Query | Microsoft Learn

Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Lea...

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