Forum Discussion

PYarwood98's avatar
PYarwood98
Icon for Helper I rankHelper I
3 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...
Need Help
PYarwood98's avatar
PYarwood98
Icon for Helper I rankHelper I
3 months ago

Using Microsoft Access databases and excel in some cases. I have done the checks on gateway status and credentials are all working.

anilelmastasi's avatar
anilelmastasi
Icon for Super User rankSuper User
3 months ago

PYarwood98 ,

 

Can you do this too please? 

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

  • PYarwood98's avatar
    PYarwood98
    Icon for Helper I rankHelper I
    3 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's avatar
      anilelmastasi
      Icon for Super User rankSuper User
      3 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's avatar
        PYarwood98
        Icon for Helper I rankHelper I
        3 months ago

        No changes made to table headers used.