Model Data Source being another Model

[rhains]

I am trying to create a Legacy New Provider Data source that connects to a Analysis Service Model in Premium services.

My connection string is
provider=MSOLAP.8;persist security info=False; user id=app:appid@tenantid;initial catalog=TabularProject15;data source=powerbi://api.powerbi.com/v1.0/myorg/Premium%20Test;update isolation level=2;Password=

My data link properties provider is:

When I click test connection I got this

When I continue with the Test Connection I get this

What I am doing wrong that I get that Multiple-step OLE DB operation generated errors message?

Thanks

Richard

[otykier]

Hi Richard.
I'm not sure why the multiple-step error is showing - I get the same thing on my end. We're just using the standard API for the Data Links dialog, so anything that goes on inside that dialog is unfortunately out of our hands. However, the good news is that you can still import tables and use TE3's update table schema feature after setting up the legacy data source this way. Refresh operations also seem to work fine. So I think it's safe to ignore that error message.

[rhains]

Hi Daniel, Would you be able to tell me, once you setup the Data source being a Tabular Model, and after you deployed into a Power BI Premium Workspace, how do you make Power Bi to recognize the data source? Or, may be if you can send me an example of the Connection String you use so I can compare with the one I am using. I will really appreciate. Thanks Richard Hains