Forum Discussion

nagaraj's avatar
nagaraj
Icon for Post Patron rankPost Patron
6 years ago
Solved

Single datamodel for all reports

Hi,    We have a report with import model and have a size 400 MB. For testing purpose we have created 3 copies of the same report to show showcase differnt visuals. Hence the total sixe is 1200 MB ...
  • parry2k's avatar
    parry2k
    6 years ago

    nagaraj well if you have a lot of bookmarks then you can try this hack, but not guarantee it will work, make a copy of your report on which you will work.

     

    - open file in pbix

    - delete all the tables from the report, and of course, everything will break

    - now get data, choose power bi dataset

    - connect to your power bi dataset and if the model is identical everything will lit up and will work 

     

    Let me know how it goes?

     

    PS - Delete all table steps is really important.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.