Forum Discussion

Zhinee's avatar
Zhinee
Helper III
1 year ago
Solved

Question about DirectQuery behavior when publishing a report

If I download a report and rename my report, and connect to DirectQuery dataset that already exists in Workspace A, and then I publish that report back to the same workspace, I notice that a new data...
Need Help
  • sergej_og's avatar
    sergej_og
    1 year ago

    Just tried to create a new report an publish it with existing DQ model as a source.
    -> Only a new report appears in the WS.


    Thx AmiraBedh for the hint.

    So you're doing something else with your approach Zhinee .

AmiraBedh's avatar
AmiraBedh
Super User
1 year ago

When you download a PBIX that is connected via DirectQuery to an existing dataset in a workspace, rename the report file and then Publish it back to the same workspace where the original dataset

Power BI assumes you're uploading a new report

You don't need to re-publish the PBIX file that contains a live DirectQuery connection unless it was originally created with "Connect to Power BI semantic model" from that workspace.

Zhinee's avatar
Zhinee
Helper III
1 year ago

so when I first downloaded the a PBIX, it did not use a Direct Query ( It was using a live connection)
Then, I change the data source to a Direct Query that exists in the workspace. 
Then, when I publish, I am seeing the new DirectQuery dataset.