topic Re: On premises data in Report Server

On premises data

mysar — Wed, 23 Mar 2022 09:51:39 GMT

Hello,

My client doesn't want share the data outside the UAE. and on premise report server is very costly. Is there any other way for on premise data or for UAE location.

Re: On premises data

Anonymous — Wed, 23 Mar 2022 21:19:13 GMT

If your client has SQL Server Core Ent and on a MS EA agreement, then that is all you need other than a pro licence for the publishing of the reports to the report server.

Re: On premises data

d_gosbell — Wed, 23 Mar 2022 21:58:20 GMT

The Power BI service has the UAE region as an option (see https://docs.microsoft.com/en-us/business-applications-release-notes/april19/business-intelligence/power-bi-service/additional-geos )

So you can set up your Power BI tenant in that region and there are settings to prevent data being moved outside the nominated region. Note this may restrict your access to some features, in particular Microsoft often releases new preview features using other cloud services (like various AI models) in the US first and then rolls them out to other regions once they are officially released.

Then you could have your reports on the cloud service and use a data gateway to load your on-prem data and everything would stay in the UAE.