Forum Discussion
Rows multiply when I add dates from SAAS
Hi I'm retrieving a couple of columns from a SSAS (SQL Server 2012) : Work Order Id and Execution Date. When I try it in excel, the result looks ok but when I try it in PBI Desktop I obtai...
Anonymous,
Do you use import mode in Power BI Desktop to connect to SSAS? If so, please use "Connect Live" mode instead to connect to SSAS, this way, you will get same result as that in Excel.
Regards,
Lydia
Ouch!, the SQL Server version that the company uses, doesn't allow live connections but thanks for your comments
Anonymous,
You can upgrade SSAS and then use live connection.
Regards,
LydiaThanks, I will ask to IT support for this solution.
I'm sorry but the solution wasn't tested yet so I can't accept it as ok.
Still waiting for the IT department.