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

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