Forum Discussion

mp9531943781's avatar
mp9531943781
Frequent Visitor
1 year ago
Solved

Report not overwriting in workspace, creates a duplicate instead

I'm running into a frustrating issue with a report that was originally published in our production workspace. I'm trying to update it by publishing the latest PBIX file, which I downloaded directly f...
  • lbendlin's avatar
    1 year ago

    Check for trailing spaces or other invisible characters in the pbix name.

  • rohit1991's avatar
    1 year ago

    Hi mp9531943781 ,

    *Why It’s Creating a Duplicate*

    • Power BI identifies reports by internal IDs, not just by name. If that internal ID doesn’t match, even if the PBIX was downloaded from the same workspace, it will treat the upload as a new report.

    • Publishing from Desktop does not support dataset binding, so it can't detect or overwrite existing reports unless the internal metadata matches exactly.

    • In personal workspaces, Power BI is more lenient and prompts to overwrite—but in shared or production workspaces, especially with downstream dependencies, it's more cautious.

    * What You Can Try*

    1. Use Power BI Service to Overwrite: Instead of publishing from Desktop, go to the Power BI Service:

      • Open the existing report in the workspace.

      • Click the “Upload a file” > “Replace report” option.

      • This keeps the same dataset and connections intact and avoids creating a duplicate.

    2. Check Report Binding with Power BI REST API (Advanced):

      • If you're familiar with scripting, use the Power BI REST API to rebind the new report to the existing dataset after upload.

    3. Avoid Deleting the Original:

      • Since it's used as a source in other workspaces, do not delete the report/dataset. Instead, try the overwrite or rebind approach.

    4. Naming Convention as a Last Resort: If overwrite isn't possible, you could:

      • Publish with a different name,

      • Rebind the downstream reports to the new dataset (if possible), and

      • Then retire the old report—but this can be risky and time-consuming.

    * Additional Tips*

    • Ensure you have sufficient permissions (typically Member or Contributor) to overwrite reports in the workspace.