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
Community Support
1 year ago

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.