Forum Discussion
Dataflow: linked table doesn't update values - even with refreshing
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...
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
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.