Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've noticed a very odd thing whilst refreshing my data in Power BI Desktop. Some background info:
- We have a connection to our data platform, a Databricks SQL data warehouse and are using import mode for our semantic model.
- The tables in Databricks consists of fact and dimensions, all tables have business keys (text values) and ids (integers)
- The ids might change in the facts and dimensions, this is because of how we process the data. The business keys will stay the same. But of course, if the ids change, they are changed both in the fact and dim so the corresponding records can still be linked to each other.
- We use the ids to create relationships as these ids take up less space than the bks.
We noticed the following:
- We refresh the data in the data platform (and therefore the ids change and the bks stay the same)
- We hit the refresh button in Power BI Desktop
- All data gets refreshed succesfully (it says..)
- We notice that the ids in the fact table do NOT correspond with the ids in the dimension table, whilst the data in the platform shows the correct matching ids for both dims and facts.
- We refresh the specific fact table with the wrong id again in Power BI Desktop, and now it shows the correct id.... so it seems like the full refresh isn't doing what it should be doing?
What's going on here? 😅
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Paulien_
Your data source is Databricks SQL data warehouse, then you imported the data into Desktop and did a refresh and found that some of the data was not refreshed correctly, right? Can you provide the corresponding screenshot, based on your current description, it's hard to determine the exact cause of the problem.
Best Regards,
Community Support Team _ Ailsa Tao