Forum Discussion

dguevara's avatar
dguevara
Advocate IV
10 years ago

Best way to develop and implement a solution

Hi Everybody... what is the best way to implement an enterprise solution working with large databases, because I can develop my model in Power BI Desktop and ok no problem, the problem is that there...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

dguevara For enterprise level solutions nothing beats going the Tabular model route. Rather than use the Power BI Desktop, if you develop your tabular model and deploy to an SSAS instance there are no limitations on size, and Power BI can direct query your SSAS instance using the Analysis Services Connector or Enterprise Gateway (which will replace the AS Connector eventually).

  • AliSharifi's avatar
    AliSharifi
    Helper I
    10 years ago

    Anonymous, How about SSAS multi dimensional model, I guess it has been supported in the new Desktop realeae.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      AliSharifi Absolutely a viable option. I assumed based on the question that SSAS in general wasn't considered initially. Given that assumption, I recommended Tabular over Multi-dimensional as the learning curve is much lower initially, while the gains are immense. There are scenerio's for each solution in which one may be better than the other.