I have an issue that'd like to expose here since I am still a novice with power bi pro.
I have a .pbix with 30 pages related to many functions (sales, logistics, customer service, procurement). I developed all these pages under one .pbix since they all share common data and won't be feasible to edit each data source on its own.
Now I finished developing the complete file and want to share it online on Power BI Pro, so what I did so far is as follow:
- Upload my power bi file
- Set up my on premise gateway on a local pc to connect to my SQL Server database remotely (connexion worked am able to refresh data)
- Tested my file
Now the issue is that I want each department to have its own report, so I have to split up my pbix file into 4 pbix files, which mean 4 data sources. However, on PBI Pro, I want to connect those 4 report files to a single dataset and not each one has it own dataset. The issue is about data refresh since it takes about 20 minutes for one dataset, so you can imagine how much time it'll take to refresh 4 datasets that are similar
Hence, how to connect 4 reports to the similar dataset in power bi pro?