Forum Discussion

viera00's avatar
viera00
Helper II
10 years ago

Size Of Publishing Compromise Implementation Scenario

Hi Everyone,   I'm having a serious problem with a real implementation scenario.     I've a PowerBI Pro licence.   The architecture is the following:   1- SQL server on premise. 2- Windows ...
Need Help
viera00's avatar
viera00
Helper II
10 years ago

Hi mike_honey,

 

I've installed Enterprise Gateway and I'm in the process of testing it. I'm a little bit concerned about performance and the limitiations of Direct Query (non calculated columns, not full DAX, only one direction for navigation). I'll make the test and write about it.

 

Any idea if Microsoft plans to sell SSAS Enterprie standalone (without the need of sull SQL Server Enterprise)? This really is making real wolrd solutions very costly. I mean, PowerBI is competing with big players in this field (Tableau, Qlikview,etc) If I need to purchase a licence of SQL Server Enterprise to reach similar functionality, it places the tool under an unfair position.

 

Thanks for the information.

 

Regards,

 

 

greggyb's avatar
greggyb
Resident Rockstar
10 years ago

SSAS Tabular is available in SQL Server BI Edition. SSAS Multidimensional is available in SQL Server Standard edition. Both can be queried directly from Power BI.

  • viera00's avatar
    viera00
    Helper II
    10 years ago

    Hi greggyb,

     

    This is the scenario I'm moving to now. Creating a BI database from the original SQL database.

     

    I'll keep you posted on the progress.

     

    Regards,