They both use tabular model running on the vertipaq engine.

lastnn30 

You can use Power Query.

Check thiese links:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#:~:text=To%20get%20to%20Power%20Query,blank%20pane%2C%20ready%20for%20data.

https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query

Create and manage relationships in Power BI Desktop

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/