Hi all,
We are migrating from on-prem tabular models to PowerBI Premium models. Most datasources work flawlessly (including the CDATA Snowflake connector). However, we have been unable to use another tabular model as a data source when using PowerBI Premium models…
We have the same problem when trying to connect to our Power BI Premium models from our data catalog (Ataccama).
OLD On-prem Visual Studio source:
Friendly connection name: emodel name]
Server or File Name: eserver] \ Folder]
Database name: eDatabase name]
OLD Ataccama /CDATA JDBC connector:
jdbc:cdata:ssas:User=euser];catalog="gcatalog]";URL=http://:server]/OLAP/msmdpump.dll
New Connections that work:
Excel Connection (Power BI Premium Data Source):
Provider=MSOLAP.8;
Integrated Security=t];
Persist Security Info=f];
Initial Catalog=sobe_wowvirtualserver-eGUID];
Data Source=pbiazure://api.powerbi.com;
MDX Compatibility=1;Safety Options=2;
MDX Missing Member Mode=Error;
Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, iGUID];
Update Isolation Level=2
SSMS Analysis Services
Server type: Analysis Services
Server name: powerbi://api.powerbi.com/v1.0/myorg/rWorkspace Name]
Auth: Azure AD - Universal with MFA
User name: euser name]
If anyone has any ideas, I’d be most grateful!
Thanks,
Malcolm
Ps. Apologies, if I have the category wrong here, (might be cloud connect?)