FAQ Database Discussion Community


How to transfer data from Tabular model (SSAS Tabular) to Relational Database?

ssas,ssis-2012,ssas-tabular
I am new to SSAS and Tabular model cubes. I have a data migration task that aims to import data from a Tabular model into a SQL Server database. I have tried SSIS with not success. Using OLEDB Data source connected SSAS instance with Tabular database, I configured the data...

Calculating PERCENTILE in DAX - SOLVED

olap,powerpivot,dax,powerbi,ssas-tabular
OK, so I have googled up a lot on this subject and keep ending up with formulas which are too damn slow. I am suspecting if I split the formula in steps(Creating calculated columns), I might see some performance gain. I have a table having some numeric columns along with...

Do I need to import the full data in SSAS tabular mode from my SQL database in DirectQuery mode?

sql-server-2012,ssas,ssas-tabular
I'm trying to build a Analysis service tabular project in tabular mode and want to use DirectQuery mode so that the queries are executed at the backend. When I click on the model, and select import data from source, I see option to retrieve the full data. Now I have...