1
Within our domain we have an analysis service server running with cubes. When trying to retrieve this data using Excel (Get data from Analysis Service), Visual Studio (using source control explorer) and PowerBI (Get data from Analysis Service), we get an error:
Unable to connect. An error has occurred while trying to connect. Details: Cannot access the dataset. Please contact the owner of the dataset.
This is translated, so I hope the error description is clear. We will get a similar error in Visual Studio. We can access the cubes directly from SQL Server Management Studios, but they are not accessible by end users using their applications.
Does anyone have an idea where the problem lies here (is it on application level, SQL SMS or network)?
Hoxus
Posted 2019-11-12T13:01:18.720
Reputation: 11
Tricky Issues, @Hoxus, and quite vaguely described by these generic descriptions. Can you please try to apply some of the troubleshooting tips that appear here?
– None – 2019-11-12T13:25:08.387@DOBRESCU_Mihai, I am not sure what information I can provide besides this. End users are able to connect to the SSAS data source using their local desktop. However when trying to access the SSAS server while on their VDI virtual environment, they are unable to. – Hoxus – 2019-11-12T13:38:25.403
Probably some Log Files would help, @Hoxus. But these Issues appear to be Intensively Tricky. This is why we have pointed you to that experience where you may find some clues. – None – 2019-11-12T13:40:48.673
Thank you, I am checking the thread out now. Would I need to check log files of SQL Server Management Studios or of the applications we use to try to connect to the data source? – Hoxus – 2019-11-12T13:41:59.847
The most comprehensive answer would obviously be: both. We would take them one by one and see what is happening in each instance. For instance, check PowerBI's interaction with the SSMS and see what is going on. Difficult Task. – None – 2019-11-12T13:45:46.130