Forum Discussion
Data refresh is giving unpredictable and incorrect results
I think I've found the solution for the above issue!
As I'm deriving the dimensions from the master table, I was expecting the items, I use to join between the fact table and the dimension, to be the same.
I suspect one of the elements to contain special characters and/or leading/trailing spaces, so I inserted in the power query 2 steps to trim and clean the text strings and it looks like this solved the issue!
Hi Anonymous ,
I found a similar post that might help you:
Solved: power bi desktop shows different data than in powe... - Microsoft Fabric Community
Are you saying that your data model relationships on Power BI Service are different from yours? Did the relationship change after uploading?
If you can, please provide some screenshots for demonstration, remember to protect your privacy.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen,
The data model relationship stays in place, but the data within the relationship columns is changed, e.g. in the original data the reference is to customer A, but after refresh on the Power BI service it is to customer B and this looks randomly, because next time I refresh on the server it can also be Customer C or D....
I have a very simple model, see below, based on one date table and data table, used as base for the other tables. The tables on the left and right lower corner are all derived from the data table using a table.distinct and a surrogate key using the index function of power query.
The fact table in the middle is using the surrogate keys to link to the dimension, so in fact I'm more or less creating a star scheme from a single table.
When looking at the data that is refreshed on the Power BI service, it looks like the relationship from the fact table is created to the dimensions before the dimensions are refreshed.