Ms Access Refresh - Error 2147467259

[Anonymous]

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 in the source etc, but that is not causing this. 

This is the query I am connected to(Named exactly as above)

I am using an personal-mode gateway, doubt that causes this error.  Is there anything within the Advanced Editor script that could cause this?

Any help to get my first scheduled dataset to run would be greatly appreciated 

Thanks,

Barry.

[Anonymous]

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

[v-cherch-msft]

Hi @Anonymous

I cannot reproduce the same issue. Please check if the below post could help you.

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/td-p/186522

Regards,

Cherie

[Anonymous]

@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

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]

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.