Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ms Access Refresh - Error 2147467259

Hi, I have an issue refreshing a Query from an Ms Access Database, returning the above error code. Error below.     I have read that this can be caused by changing the name of a table,tabs ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

FYI The refresh works fine in Desktop with no errors appearing in Power Direct.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-cherch-msft Unfortunately, this didn't fix the error.  I removed steps used in Power Direct changing any datatypes and republished the workspace. No Luck :smileysad:

       

      ALSO If I try to connect to the database from the Dataflow service, I cannot even see the queries.  My suspicion is that this error lies with trying to connect to a view instead of a table ?? I am the owner of the database so permissions shouldn't be an issue.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Solved the issue, I had fields that were null in the database which were causing this as I had a default value rule set for the Fact Table, Zero in this case because it was numberic field.  Power BI was taking this rule into account when trying to ready the query from the database, identifying the null's as incorrect key values.