Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I'm importing a dataverse table and I'm selecting only its GUID column and creating an index column as a surrogated key.
Then, I'm trying to import the same dimension table and a fact table to my model (both using the same GUID number). When I merge one of these tables against the first one to bring the index using the GUID column, it works perfect in Power Query, but when I apply the changes to Power BI it cannot be completed saying that ir references to another step...
The main idea with this is to replace the GUID number with a surrogated key to downsize the model.
Is there something to configure to get this work?
Solved! Go to Solution.
Finally I had to bypass the privacy level setting and it worked.
Thanks anyway for your answer. Regards
Finally I had to bypass the privacy level setting and it worked.
Thanks anyway for your answer. Regards
Hi @hromero ,
Here's 2 possible reasons.
One possible reason for this error could be that the merge step is referencing another step that has been removed or modified. To fix this, you can try to recreate the merge step and make sure that all the previous steps are still intact.
Another possible reason is that one column has a relationship join to another table, but the column changes due to some operation. It is recommended to delete the relationships in the table and reapply them.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
10 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |