Power BI - Schedule Refresh Issue (Sharepoint folder)

[swathireddy124]

Hi Team,

I have a Power BI Report for my client where Sharepoint is my Data source.

It is getting refreshed in desktop perfectly, but in server it is throwing me below error:

Note: System is configured with 64 bit version of the Access Database engine.

Can you please suggest?

[GilbertQ]

Hi there

You need to install the 64bit of Office or the 64bit Access Database Engine components where you have installed the On-Premise Data Gateway.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Then select the version: AccessDatabaseEngine_X64.exe

[swathireddy124]

Thanks for the suggestion.

As suggested, I have installed 64bit of Office or the 64bit Access Database Engine components but still facing the same error.

What do you suggest?

[GilbertQ]

Hi there

Just to confirm you did install from the link suggested?

[swathireddy124 · Accepted solution]

The issue was with the data in the .xslx sheets, some data was not supporting. This error initally didnt show up in desktop. I fixed the data and published. 

Now I am able to schedule refresh and it is succesful.