I have been able to connect to a cube in Excel using MSOLAP.5 provider and it works perfectly. I have been trying to connect to the same cube using the datasource SQL Server Analylsis Services but I am getting the error:
unable to connect
we encountered an error while trying to connect
details: "AnalysisServices: object reference not set to an instance of an object
Can anyone suggest a solution ?
I am looking to do the same thing. I think this is the only way I can connect to NICE InContact data, but it does not currently work. Would love to know if anyone was able to find a workaround.
Well i heard from the support team, apparently this feature was never supposed to work hence now that its broken, they are not going to fix it !!
Was this feature removed in the latest versions of BI? it works in the June version.
And do you know when it will be added back in?
Click here to read more about the June 2022 updates!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.