Forum Discussion
Does Power BI gateway for enterprise deployments support MultiDimesnion SQL Server 2012 sp3
- 10 years ago
If anyone else has this issue, it was that my SSAS didn't have SP1 CU-4 or above.
I am really embarrassed about this. I checked the SQL Server Version to make sure that SP3 was there already which it was, but because we installed SSAS afterwards it didn’t install with SP3, and I didn’t think to check.
Hey tank104.
The enterprise gateway does support on-premise live MD connection and works surprisingly well. The authetication also works like a dream.
Br. Olli
Great thanks Anonymous - that makes me really excited, now I just need to figure out the issue.
Any ideas? i have the latest plugin installed (yesterdays) but get the following error:
Unable to connect: We encountered an error while trying to connect to XXXXX\SQL. Details: "The gateway does not support the specified data source. Please make sure you have installed the latest version of the gateway."Hide details
Activity ID: | 8bacedce-f109-4cc8-c4f9-34e0c84090a6 |
Request ID: | 76526f37-4319-e033-fddf-d7fc60c5e736 |
Cluster URI: | |
Status code: | 400 |
Error Code: | DM_GWPipeline_Gateway_UnsupportedServerVersion |
Time: | Mon Mar 21 2016 18:24:41 GMT+0000 (GMT Standard Time) |
Version: | 13.0.1100.182 |
- tank10410 years agoRegular Visitor
If anyone else has this issue, it was that my SSAS didn't have SP1 CU-4 or above.
I am really embarrassed about this. I checked the SQL Server Version to make sure that SP3 was there already which it was, but because we installed SSAS afterwards it didn’t install with SP3, and I didn’t think to check.
- Anonymous10 years agoNot applicable
Hey tank104.
Sorry for the late reply.
The MD connection requires Enterprise or Business Intelligence edition of SQL Server Analysis Services. Is that it?
Br. Olli
- skiwi10 years agoNew Member
hey
can someone please post a list or link of supported SQL server versions and service packs for connecting to MD models.
thanks