Medium severityfabric
Power BI Refresh Error:
Data Source Connectivity Mode Mismatch
What does this error mean?
A Fabric deployment pipeline detected that the data source connectivity mode (e.g., DirectQuery vs. Import) differs between the source and target stages and cannot complete the conversion automatically. This occurs most often with live-connected semantic models where mode conversion is not supported.
Common causes
- 1The source stage model uses DirectQuery and the target stage's model uses Import (or vice versa)
- 2A live connection semantic model was deployed to a target where the connection type differs
- 3Deployment rules that attempt to change the connectivity mode of a data source to one that is incompatible with the model type
How to fix it
- 1Align the data source connectivity mode between source and target stages before deploying — both should use the same mode (DirectQuery or Import)
- 2If using a live connection, check the target-stage deployment rules and remove any rule that changes the data source connection to an incompatible type
- 3Review the deployment pipeline documentation on supported data source rule changes — some live-connection mode changes are not supported and will always fail
Beyond the docs
Common practitioner solutions not covered in the official documentation.
- 1If mode conversion is required, recreate the semantic model in the target stage with the correct connectivity mode rather than trying to convert it via deployment rules
Official documentation: https://learn.microsoft.com/en-us/fabric/cicd/troubleshoot-cicd