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

     

nilendraFabric's avatar
nilendraFabric
Super User
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