Forum Discussion

Pavan_123456789's avatar
Pavan_123456789
Icon for Helper III rankHelper III
1 year ago

Unable to Remove Residual Data Source Credentials for Deleted Tables in Dataflow

I’m experiencing an issue in Power BI Service related to residual data source credentials for deleted tables in a dataflow. Here's the situation: I created a dataflow using a OneDrive link and incl...
dataflow
Need Help
rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi hope these 3 steps help. This issue occurs because the deleted table references persist in the metadata of the dataflow. To resolve this problem, follow these steps:


1. Clear and Rebuild the Dataflow Metadata: Open the affected dataflow in Power BI Service. Select Edit Dataflow and check the Query Editor to ensure no residual queries or references for the deleted tables exist. Save and close the dataflow.


2. Force Refresh the Dataflow: Perform a full refresh of the dataflow to clear any outdated metadata related to the deleted tables.


3. Rebuild Dataflow (if needed): If residual credentials persist: Export the dataflow JSON file by navigating to Settings → Export JSON. Remove references to the deleted tables in the JSON file. Delete the existing dataflow. Reimport the modified JSON file as a new dataflow.


4. Clear and Reapply Credentials: Navigate to Manage Gateway in Power BI Service. Revalidate or clear the credentials for the dataflow. Reapply credentials only for the active data sources in the dataflow.