Power BI desktop is so very very useful, but is undermined a little by the fact that if you use Power BI desktop want to publish multiple reports, you end up with redundant datasets. In an ideal wor...
I would suggest doing like Access. Have a Split button that enables splitting the pbix file in to front end and back end.
