Semantic Models

[rschoenlein]

When I edit a remote semantic model, it removes direct query connections when it is published. Is there a way to connect a desktop report to a remote semantic model with existing direct query connections, edit its transforms/imports etc... and publish the new version while keeping its existing direct query connections?

[v-karpurapud]

Hi @rschoenlein 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @rschoenlein 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hello @rschoenlein 

Could you please confirm if your query have been resolved the solution provided by @nilendraFabric ?  If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you

[nilendraFabric · Accepted solution]

Hi @rschoenlein 

Begin by connecting your report to the remote semantic model using a live connection.
• To make changes, convert the live connection to DirectQuery mode. This creates a local model in Power BI Desktop, enabling you to make transformations, add calculated columns, or modify imports

When publishing, ensure that tenant settings allow DirectQuery connections to Power BI semantic models. If this setting is disabled, contact your Power BI administrator to enable it

See this blog :

https://pragmaticworks.com/blog/how-to-edit-power-bi-live-connection-without-destroying-everything