The last refresh attempt failed because of an internal service error.

[Anonymous]

The last refresh attempt failed because of an internal service error. It is only happening for where I am connecting to Python 39-32 (32 bit) which is helping me connect to the 32bit access database i have

[lbendlin]

Yes, we already have a Pro ticket open. Hopefully we'll get to the root cause somehow.

[v-xulin-mstf]

Hi @Anonymous,@lbendlin,

I am sorry for the issue you are experiencing.

Please create a support ticket for assistance.

Best Regards,

Link

[v-xulin-mstf]

Hi @Anonymous,

You can do troubleshooting as:

1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)

2 - Refresh the data in the desktop and save.

3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online

5 - Hop back to PBI Online and set the refresh schedule back up

6 - Add the reports back into any apps or content packs.

Best Regards,

Link

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

[Anonymous]

I tried your instructions but I am getting the same error. Please note all other refreshes are working fine and only problem i am getting for Power BI where I am connecting to 32 bit Python. All others I am using 64 bit Python

[v-xulin-mstf]

Hi @Anonymous,

You can try to refresh in power bi desktop.

If it fails, please check if the data source has been moved or damaged.

And try to re-edit the credentials.

Maybe your power bi version cause the issue, please check.

Best Regards,

Link

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

[Anonymous]

Refresh in Power BI desktop works fine (selecting Python 39-32). It just does not refresh in Power BI service. 

[v-xulin-mstf]

Hi @Anonymous,

What is your power bi version?

Maybe you can update power bi desktop and check.

You can refer this related post.

Best Regards,

Link

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

[lbendlin]

@v-xulin-mstf it will always work in the desktop. The error only appears in the service and is random enough that it is impossible to reliably reproduce. Rather frustrating.

[Anonymous]

It did not solve the problem. 

[Anonymous]

[lbendlin]

Can you confirm that your personal gateway is correctly configured and running?

[Anonymous]

my personal gateway works perfectly for all other datasets. which connects to 64 Bit Python in Power BI desktop