Forum Discussion

AndyDD_UK's avatar
AndyDD_UK
Icon for Helper III rankHelper III
3 years ago
Solved

Switch report to alternative dataset

We've a cube we manage in visual studio   This is deployed with a database name of "reports_data".   We've two PBI reports "Report 1" and "Report 2" created in desktop that use the same dataset, ...
Need Help
  • Keegan_Patton's avatar
    Keegan_Patton
    3 years ago

    If I am following you should be able to connect to the dataset if it has been published via 'Power BI Datasets', and yes you would need to recreate anything you wanted to move to a new report sourced from that dataset.

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

AndyDD_UK Are you using Live, DirectQuery or Import mode?

  • AndyDD_UK's avatar
    AndyDD_UK
    Icon for Helper III rankHelper III
    3 years ago

    Thanks Greg, direct query

    • Keegan_Patton's avatar
      Keegan_Patton
      Icon for Advocate II rankAdvocate II
      3 years ago

      I believe you would need to publish the dataset by itself to the service then connect to that dataset as a live connection for each report, it sounds like you are building each report on top of the dataset rather than connecting to it. When you publish the dataset by itself it will generate a front end report view, delete that and just have the model reside in the datasets tab.

      Hope this helps!

      • AndyDD_UK's avatar
        AndyDD_UK
        Icon for Helper III rankHelper III
        3 years ago

        Thanks, how do I connect to that dataset though ?

         

        I can see that I can create a report from the dataset, should I create a new report from the one dataset and copy-paste my pages into that (calculations are in the cube but I am using filters and drill throughs) ?