November 21, 2018 at 1:32 pm
Hi all,
Sorry, it is power BI related question.
I am new to Power BI. I am from Sql Server BI backgraound.
I work with large data warehouses and cubes.
Keeping this in mind, I have a question.
My database is Sql server.
Which mode is best fit in power bi? Import or DirectQuery?
I have googled on this and found confusing answers. I am asking this question based on real time project.
Please reply
November 22, 2018 at 2:48 am
a2zwd - Wednesday, November 21, 2018 1:32 PMHi all,
Sorry, it is power BI related question.
I am new to Power BI. I am from Sql Server BI backgraound.I work with large data warehouses and cubes.
Keeping this in mind, I have a question.
My database is Sql server.
Which mode is best fit in power bi? Import or DirectQuery?
I have googled on this and found confusing answers. I am asking this question based on real time project.
Please reply
It is like so many things, it "depends".
😎
How often does the data change? Do the reports have to reflect those changes in real time? What is the complexity of the queries? Are there enough resources on the SQL back end to handle the additional load? Are there any risks of the queries blocking the source system? etc. etc.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply