Forum Discussion

WESTi's avatar
WESTi
Helper I
10 years ago

SQL: Better to connect to raw table and apply steps or filter/join with query?

We have an on-premise data source (SQL Server 2008 - I know its old...) housing our ERP data (Microsoft Dynamics AX 2009). We are currently using PowerBi to connect to this data using an import conne...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

WESTi Just to add a few comments. SSAS for MD is support much earlier than 2016. The current support is SQL Server 2012 SP1 CU4 or later versions of Analysis Services.

I am in agreement with what has been said already, there are a variety of factors. Another thing to keep in mind. If you are using Direct Query, you won't have some of the modeling capabilities in Power BI to transform the data, so that's where Views become very useful because they add that layer of abstraction that you can manipulate to support your visuals. I can't say I've tested all these scenerio's (I think I will shortly).

 

  • sdjensen's avatar
    sdjensen
    Solution Sage
    10 years ago

    @Eno1978 - just a small comment regarding the support for SSAS MD. If you don't have SQL Server 2016 you will need an enterprise or BI edition of the SQL Server since DAX to MDX is not supported in the standard editions of SQL Server 2012 or 2014.