Efficient way to import tables in power bi from sql server

[Anonymous]

hello great people. What is the most efficient way to bring four tables from a database into Power BI? Should I first import the tables into Power BI and then perform joins? Or should I directly run an SQL script in Power BI to import data from a SQL server?

Appreciate your advice. Thanks

[lucadelicio · Accepted solution]

Hi @Anonymous ,
i think there is no a perfect answer it depends.

You can use Direct Query or Import Mode to use the data in Pbi from sql.

Briefly with Direct Query you have the data connected in real time. But with big data is not good the performance.

Otherwise you can import the data (most use solution) into the model and connect the relationships between the tables.

I suggest to create a view on sql for every table that you need but only with the columns that you need and then import those in pbi model.

Better if you can to built a specific database as datawarehouse, create the specific view and connect it.

I hope i help you.

[Anonymous]

Appreciate it. Thanks