Import in power query a semantic model in a premium workspace on power bi service

[JM_CORP]

Hi, 

I have a power bi desktop where I published the cube on power bi service in a premium workspace. Now I would like to import my semantic model in power bi desktop and add extra sources that I want to transform combined to my tables of my first semantic model.

Direct query only allow to import extra sources.

Any thoughts?

Thanks in advance for your help 

[JM_CORP]

When I try to use Analysis services (SQL database, there is no other choices). it asks me for a servor. I put my semantic model api link in imported mode. It ask for authentification after it and it doesn't support microsoft account authentification. 

Have I missed something ? 

Thanks in advance for your help

[lbendlin]

that's the wrong link.  Use the link  from the "server settings" in the settings page of the semantic model.

[lbendlin · Accepted solution]

Obligatory disclaimer:  Exporting data from a cube or semantic model is ... not nice ... 

Connect to your semantic model via the "Analysis Services"  connector.  You can get the details from the "server settings" in the settings page of the semantic model.  The connector unfortunately allows you to choose import rather than live connection.

[JM_CORP]

It works, thanks for your help