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

Logically it won't create a new semantic model if the one you are connecting you is already existing even in a different workspace.

sergej_og's avatar
sergej_og
Super User
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 .

  • Zhinee's avatar
    Zhinee
    Helper III
    1 year ago

    I think I figured out why I am seeing this issue.

    When I download the report, it was using a live connection. 
    Then I change it to Direct Query connection( When I click on transform data, It asks me to add a local model and I choose the Direct Query)
    Don't do this ^
    just go to Option and Change Data Source
    This will avoid creating a duplicate data model.

    • AmiraBedh's avatar
      AmiraBedh
      Super User
      1 year ago

      Glad to help ! 😄