Solved: Sage200 Integration

Chris2B · ‎03-02-2024

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

aj1973 · ‎03-03-2024

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Chris2B · ‎03-04-2024

Thank you

aj1973 · ‎03-03-2024

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook