Forum Discussion
Best / Fastest Data Storage with powerBI
smintos Many people just intermix the two and call them both Direct Query... I don't because there is a difference in how they work. The live connection doesn't have to transform your DAX queries into SQL and pass those back and forth to the database of origin. It connects directly to the Tabular model and works directly off of the "In Memory" model.
Direct Query - Will transform what you are doing in the model to the language of the database. SQL in this instance. Then hits the DB, and returns the information. This relys on the underlying structure of the DB to return the information quickly, there is more than likely some more complexity to this connection, but you get the idea.
Yes, 2016 SQL Server Standard has the option to use SSAS Tabular with limitations..
The setup of SQL SSAS would be a standard implementation, there is no need to adjust anything specifically for Power BI. You would just connect to the instance. Tabular models would require a Visual Studio license in order to build them though...
You create the model in VS and deploy it to the SQL SSAS Tabular instance.
smintos Many people just intermix the two and call them both Direct Query... I don't because there is a difference in how they work. The live connection doesn't have to transform your DAX queries into SQL and pass those back and forth to the database of origin. It connects directly to the Tabular model and works directly off of the "In Memory" model.
Direct Query - Will transform what you are doing in the model to the language of the database. SQL in this instance. Then hits the DB, and returns the information. This relys on the underlying structure of the DB to return the information quickly, there is more than likely some more complexity to this connection, but you get the idea.
Yes, 2016 SQL Server Standard has the option to use SSAS Tabular with limitations..
The setup of SQL SSAS would be a standard implementation, there is no need to adjust anything specifically for Power BI. You would just connect to the instance. Tabular models would require a Visual Studio license in order to build them though...
You create the model in VS and deploy it to the SQL SSAS Tabular instance.
Thanks Eno for the feedback.
By reading the last news about PowerBI Premium we will stay with Import Mode,
as we can expand the 1GB dataset limit in the near future.
As we need Premium for using PowerBI in Embedded Mode, decissions were quite easy now.