Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Query mode using Power BI. I never had any problems in the past using SSAS in Azure but am I a bit confused now.
Here's what I had in mind:
Issues:
Goal:
After doing some reading it seems like only the Enterprise edition supports direct query. Unfortunately, upgrading to Enterprise is not an option for now.
I see that the On-Premised Gateway supports the Standard edition. https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem and it just confuses me.
Given the current setup, what are my best options? What thing that comes to mind is to create a tabular model in Import mode, create a SQL job in SSIS to refresh the cube every few minutes and setup a direct query connection in Power BI. Can someone please clarify my confusion and offer some advice on the best approach here? Is there a workaround? I am sorry if I sound like a disoriented begginer.
Thank you,
C
Solved! Go to Solution.
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,
C
P.S: If anyone else has other ideas, please chime in.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.