Hi,
I successfully created a SSAS Cube using MySQL as a datasource. The problem I am facing is, when I tried to deploy it into the server I got the following error.
Errors in the back-end database access module. The managed provider 'MySql.Data.MySqlClient' could not be instantiated.
After some research I thought I am missing MySQL proxy in the MySQL Server. So I have installed MySQL proxy in the server and tried deploying the SSAS solution but got the same error.
Can anyone suggest me what may be the issue because I spend so many days on this.
Please help me.