Issue Importing Two Tables from Power BI Datasets

Hi technolo_bi ,

Thank you for the further details, it's clear for me now. With that, my thoughts are:

1. Do you need to transform the data somehow, or just use it in the report?
   • If it's the latter, then you can use the data normaly using measures, relationships, etc. You just CAN'T do any kind of transformation, add/remove columns, etc., because it's a live connection.
   • If you need changes in the data model, then my suggestion is to make any needed transformation in the original dataset and then just use the data in the second dataset, creating measures and other allowed components, but not changing the data model.

Unfortunately there is no workaround for this situation, because when you connect to another Power BI dataset the data model is locked for editing.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

Thanks!

Best regards,
Joao Ribeiro