Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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

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

12 REPLIES 12
lbendlin
Super User
Super User

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

v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,@lbendlin,

 

I am sorry for the issue you are experiencing.

Please create a support ticket for assistance.

Support Ticket.gif

 

Best Regards,

Link

 

v-xulin-mstf
Community Support
Community Support

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
Not applicable

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

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
Not applicable

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

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.

@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
Not applicable

It did not solve the problem. 

Anonymous
Not applicable

anandsamant_0-1615842066267.png

 

lbendlin
Super User
Super User

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors