Forum Discussion

rschoenlein's avatar
rschoenlein
New Member
1 year ago
Solved

Semantic Models

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 connect...
Dataflow
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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

     

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

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.