Sage200 Integration

[Chris2B]

Hi there,

I need some help please. I amtrying to integrate a Sage 200 .pbit into Power BI. I have previously uploaded this to the desktopbut it means I have to manually refresh the file. I want i to be a bit more smoother and was wondering if I should upload this straight onto the service and do a scheduled refresh from the server to bypass refreshing it daily in the desktop in case I amnot around and my users have accurate data.

KR,

Chris 

[Chris2B]

Thank you

[aj1973 · Accepted solution]

Hi @Chris2B 

You can't upload and use a .pbit file directly in the service. To automate the refresh of your report in the service you need to install Power BI Gateway On-Prem, configure the gateway in the service and then add your report to it. Finally schedule the refresh.

On-premises data gateway - Power BI | Microsoft Learn