Forum Discussion

Helper I

2 months ago

Refresh errors from yesterday

I have been receiving error messages when trying to run automatic refreshes on Power BI Services with the error stating "We're sorry, an error occurred during evaluation" and the error code -2147467...

Super User

2 months ago

Can you do this too please?

File-->Options and Settings --> Data Source Settings --> clear each data source permission

Helper I

2 months ago

I have tried this and changed all global permissions for my datasets, set to None and uploaded back into Power BI without success. Also changed back to Organisational, still not working.

Currently running through an on premises data gateway using Windows authentication and set to Organisational privacy level.

anilelmastasi
Super User
2 months ago
Okay, Also can you please check if the Access and Excel table headers are matching with Power BI imported data? Maybe a header has been changed in the source.
- PYarwood98
  Helper I
  2 months ago
  No changes made to table headers used.
  - v-achippa
    Community Support
    2 months ago
    Hi PYarwood98,
    
    Thank you for reaching out to Microsoft Fabric Community.
    
    Thank you anilelmastasi for the prompt response.
    
    Since everything is working fine in the desktop and one report even refreshes after a few manual retries, this looks like a gateway side issue. Please follow below steps:
    
    Update your on-premises data gateway to the latest version.
    
    Check that the 64-bit access database engine is installed on your gateway machine
    
    Check if any windows or office update rolled out on the gateway machine around june 4^th
    
    If the issue still persists, I recommend opening a support ticket so the team can look at the service side logs for your workspace.
    
    Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
    
    Thanks and regards,
    
    Anjan Kumar Chippa