Forum Discussion

Helper III

8 years ago

Solved

Direct Query with SQL Server 2017 Standard Edition

The company I am currently working for purchased a new server that has SQL Server Standard Edition 14.0.1000.169 installed. My goal is to create some tabular models and connect to them in Direct Quer...

Need Help

GilbertQ
8 years ago
Hi there,

You are indeed correct that using DirectQuery from SSAS tabular is an Enterprise only feature.

And as you rightly suggested the best would be to create the SSAS Tabular as an imported dataset, and then have it refreshing every few minutes. And have the Power BI reports using a Live Connection to the SSAS Tabular cube. And all this would go via the On-Premise Data Gateway.

The only other option is to connect your Power BI report directly to your SQL Server source. But then that would require that not only can your SQL Server handle the load, but that the dataset is optimized for Power BI queries.

GilbertQ

Super User

8 years ago

Hi there,

You are indeed correct that using DirectQuery from SSAS tabular is an Enterprise only feature.

And as you rightly suggested the best would be to create the SSAS Tabular as an imported dataset, and then have it refreshing every few minutes. And have the Power BI reports using a Live Connection to the SSAS Tabular cube. And all this would go via the On-Premise Data Gateway.

The only other option is to connect your Power BI report directly to your SQL Server source. But then that would require that not only can your SQL Server handle the load, but that the dataset is optimized for Power BI queries.

IoanCosmin

Helper III

8 years ago

Hello Guavaq,

Thank you so much for your insight! I appreciate your input, it's clear to me what needs to be done. Both solutions sound good to me, I'll test them out.

Have a great one,

P.S: If anyone else has other ideas, please chime in.