So, I am pretty new at using Power BI, so I'm having some issues when building reports that use on-premises Data Gateway. My goal is to build different reports in Power BI (let´s say 4 reports, as an example), all of them getting information from the same web data base. The problem is that everytime someone access this online data base, my company has to pay a small amount of money.
The reports refresh once per day, exactly at 2AM, using the on-premises Data Gateway. My point is: will the on-premises Data Gateway access this data base once per day, at 2 AM, and refresh all the reports or will it access it once for exery report (meaning 4 access at 2AM)?
If something is unclear, just warn me and I try to provide more information. Thanks!
It will follow the "4 access at 2AM" scenario.
I would design one master/dataset report that extracts all the required data from the source database. Once published (to your workspace or a group workspace), I would use that dataset as the source for the other 3 reports. From Power BI Desktop, go to Get Data / Power BI service.
Then you only have 1 dataset to refresh via the gateway. Another benefit is that you only have one set of queries & modelling to maintain.