Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hromero
New Member

Cannot merge a Dataverse Table itself after creating an index column and apply to Power BI

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?

1 ACCEPTED SOLUTION
hromero
New Member

Finally I had to bypass the privacy level setting and it worked.

 

Thanks anyway for your answer. Regards

 

hromero_0-1683198912189.png

 

View solution in original post

2 REPLIES 2
hromero
New Member

Finally I had to bypass the privacy level setting and it worked.

 

Thanks anyway for your answer. Regards

 

hromero_0-1683198912189.png

 

v-stephen-msft
Community Support
Community Support

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.           

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors