Reconnect semantic model to dataflow

[Sebfrank]

I downloaded a version of the published BI-report and made some changes. I published does changes and now the semantic model has disconnected from the dataflow. How do i add it back in? 

[v-saisrao-msft · Accepted solution]

Hi @Sebfrank,
Thank you for reaching out to the Microsoft Fabric Forum Community.

Thank you @ibarrau, for your insights.

It looks like after downloading the published PBIX file, making updates, and re-publishing it, the connection between your semantic model (dataset) and the Power BI dataflow was broken. 

• To restore the dataflow connection, follow these steps in Power BI Desktop: 
• Open your PBIX file in Power BI Desktop. 
• Go to Transform Data to open the Power Query Editor. 
• For each query that originally pulled from a dataflow: 
  Select the query. 
  Check the Source step. 
  If it’s pointing to a static table or Analysis Services, it needs to be replaced. 

• Reconnect the dataflow: 
  Click Home > Get Data > Power Platform > Power BI Dataflows. 
  Select the appropriate workspace and the correct dataflow entities. 
  Load the data. 

• If applicable, copy over transformation steps from the old query to the new one. 
• Delete the old queries that are no longer connected to the dataflow. 
• Click Close & Apply and then re-publish your report to the same workspace. 
• In the Power BI Service: 
  Go to Dataset Settings > Data Source Credentials. 
  Update credentials for the dataflow if needed (especially if a warning icon appears). 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[Poojara_D12 · Accepted solution]

Hi @Sebfrank 

When you download a Power BI report from the Power BI Service and make changes in Power BI Desktop, publishing it back can sometimes break existing data source connections—especially with dataflows—if the changes alter or remove the original connection settings. To reconnect the semantic model to the dataflow, open the report in Power BI Desktop, go to Transform Data to access Power Query Editor, and verify if the dataflow source still exists under the Data sources pane. If it’s missing or broken, you need to re-add the dataflow: click on New Source > Power Platform > Dataflows, sign in with the correct credentials, and select the appropriate workspace and dataflow. Choose the table(s) you were using earlier and load them. Once added, ensure the names of the dataflow tables match the original ones used in your model to avoid breaking measures, visuals, or relationships. You might need to adjust column names or step names in Power Query to match the old schema. After restoring the connection and ensuring all steps and relationships are intact, publish the updated report to Power BI Service. This will re-establish the semantic model’s link to the dataflow and allow for scheduled refreshes as before.

[ibarrau]

Hi. What do you mean with "model disconnected from dataflow"? is the refreshing throwing an error about connection or credentials?

You can't go back. You should configure it. Open the Semantic Model settings of the published report. Go to Data Source Credentials section. Expand it and edit the credentials showing a warning sign.

I hope that helps,

[Sebfrank]

It literally disconnected from the dataflow.. now i just get this when going to data source. 

[v-saisrao-msft]

Hi @Sebfrank,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Sebfrank,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Sebfrank,
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.

[v-saisrao-msft · Accepted solution]

Hi @Sebfrank,
Thank you for reaching out to the Microsoft Fabric Forum Community.

Thank you @ibarrau, for your insights.

It looks like after downloading the published PBIX file, making updates, and re-publishing it, the connection between your semantic model (dataset) and the Power BI dataflow was broken. 

• To restore the dataflow connection, follow these steps in Power BI Desktop: 
• Open your PBIX file in Power BI Desktop. 
• Go to Transform Data to open the Power Query Editor. 
• For each query that originally pulled from a dataflow: 
  Select the query. 
  Check the Source step. 
  If it’s pointing to a static table or Analysis Services, it needs to be replaced. 

• Reconnect the dataflow: 
  Click Home > Get Data > Power Platform > Power BI Dataflows. 
  Select the appropriate workspace and the correct dataflow entities. 
  Load the data. 

• If applicable, copy over transformation steps from the old query to the new one. 
• Delete the old queries that are no longer connected to the dataflow. 
• Click Close & Apply and then re-publish your report to the same workspace. 
• In the Power BI Service: 
  Go to Dataset Settings > Data Source Credentials. 
  Update credentials for the dataflow if needed (especially if a warning icon appears). 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.