Forum Discussion

hromero's avatar
hromero
New Member
3 years ago
Solved

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...
Need Help
  • hromero's avatar
    hromero
    3 years ago

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

     

    Thanks anyway for your answer. Regards

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.