Optimize datasets

[wolfgangkb-work]

I have 3 reports (built in Desktop) that - of course - all have their own datasets, but actually containing the same data! Do I have any chance to change this to ONE dataset source (except "create reports from dataset" and rebuilding all visuals and filters and stuff

[BA_Pete]

Hi @wolfgangkb-work ,

Assuming that your three report datasets all contain identical tables with identical field names, I would probably build the tables from your data model(s) as dataflows (if you're not using Direct Query or Live connection). You can then change the query source code in each report to point to the single dataflow version and retain all your visuals and measures etc. You may need to re-do your relationships in each report as you will effectively be changing the source but, on balance, this is probably the way to go so you only have to maintain a single set of source tables rather than three full sets.

Pete

[parry2k]

@wolfgangkb-work there is a way to connect reports to the Power BI  datasets, read this post.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡