topic Re: The last refresh attempt failed because of an internal service error. in Service

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

Anonymous — Fri, 12 Mar 2021 21:46:19 GMT

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

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

lbendlin — Mon, 15 Mar 2021 02:45:46 GMT

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

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

v-xulin-mstf — Mon, 15 Mar 2021 03:08:43 GMT

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.

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

Anonymous — Mon, 15 Mar 2021 20:58:31 GMT

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

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

Anonymous — Mon, 15 Mar 2021 20:59:32 GMT

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

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

Anonymous — Mon, 15 Mar 2021 21:01:21 GMT

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

v-xulin-mstf — Wed, 17 Mar 2021 02:11:22 GMT

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.

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

Anonymous — Wed, 17 Mar 2021 17:36:00 GMT

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

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

v-xulin-mstf — Thu, 18 Mar 2021 02:00:58 GMT

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.

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

Anonymous — Thu, 18 Mar 2021 18:47:19 GMT

It did not solve the problem.

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

lbendlin — Fri, 19 Mar 2021 11:12:20 GMT

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.

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

v-xulin-mstf — Wed, 24 Mar 2021 02:05:45 GMT

Hi Anonymous,lbendlin,

I am sorry for the issue you are experiencing.

Please create a support ticket for assistance.

Best Regards,

Link

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

lbendlin — Wed, 24 Mar 2021 11:39:35 GMT

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