Forum Discussion
Ms Access Refresh - Error 2147467259
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.
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.