Forum Discussion
Sage200 Integration
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
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.
2 Replies
Thank you
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.
