I am trying to execute MDX query in Power Pivot.
While creating connection I have selected Model.odc. The connection string gets validated successfully by Test Connection.
In further step when I execute the MDX query and click on Validate query. The "MDX query is valid" message is displayed. But when I click on Finish, Connection String is not valid pop-up is displayed.
I don't want to import the query data via Text. I want to apply measures on data.
I am using Excel 2016.
Any help highly appreciated.