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.
Hello,
Currently I have SQL Server 2014, and SSIS and SSAS Tabular, and about to upgrade to SQL Sever 2016.
Can I also have a SSAS Multidimensional instance in addition to my SSAS Tabular Mode instance? Can I have both, or what would the setup need to be?
I'd like to have a Multidimensional mode to run traditional SQL reports to bring into a cube to publish in the PBI Gateway, so users can end up doing all their reporting with PowerBI, and the cube model, whether Tabular or Multidimensional would be transparent.
Thanks,
JPQ
Solved! Go to Solution.
@jpquinn You can't set up the Instance to be both Tabular and MD. You have to choose one or the other. But you could set up multiple instances on the same machine, one for Tabular, one for MD.
@jpquinn You can't set up the Instance to be both Tabular and MD. You have to choose one or the other. But you could set up multiple instances on the same machine, one for Tabular, one for MD.
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.