Forum Discussion

mestee's avatar
mestee
Frequent Visitor
5 months ago
Solved

Pipeline-switch DirectQuery model between different SQL endpoint servers

Due to Direct Lake models not currently supporting auto-binding to the lakehouse via deployment pipelines (we are not using Azure DevOps/Git), we switched to a Direct Query model. Now it seems I've r...
one lake
workspaces
  • V-yubandi-msft's avatar
    V-yubandi-msft
    4 months ago

    Hi mestee ,

    Thank you for contacting the Fabric Community. If the SQL server (endpoint) changes in a DirectQuery model, Power BI recognizes it as a new data source. Deployment pipelines do not support creating and validating new data sources during deployment, which causes this error.

     

    To resolve this, you can either use the same SQL endpoint across all environments or update and rebind the data source after deployment.

    Helpful Reference: Create deployment rules for Fabric's ALM - Microsoft Fabric | Microsoft Learn

     

    I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

     

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
4 months ago

Hi mestee ,

Thank you for contacting the Fabric Community. If the SQL server (endpoint) changes in a DirectQuery model, Power BI recognizes it as a new data source. Deployment pipelines do not support creating and validating new data sources during deployment, which causes this error.

 

To resolve this, you can either use the same SQL endpoint across all environments or update and rebind the data source after deployment.

Helpful Reference: Create deployment rules for Fabric's ALM - Microsoft Fabric | Microsoft Learn

 

I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.