undefined

[nagarjunakan]

PowerBI server is located on on-premise server and Axapta (main DB for business critical apps) that’s running on Azure and they are utilizing same to create reports. Their PBI is storing the data in it’s DB by fetching it from Axapta. Their ask is , if it’s possible to have cache storage gateway on their on-premise? What they want is actual storage data to be on cloud and only the cache data to be available on PBI server to order to create the reports mentioned.

[v-robertq-msft · Accepted solution]

Hi, 

As far as I’m concerned, it seems not available in the Power BI gateway now, because the gateway is only acting as a bridge to provide quick and secure data transfer between on-premises data. When your data is on the cloud, you don’t need the gateway and the cache data can not be the data source mapped to the Power BI service

You can refer to these links:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.