Forum Discussion
cmcubism
8 years agoHelper I
Unexpected error: Attempted to read or write protected memory.
Hi there, I have updated to the actual November release. After that I have experienced the following error in all of my workbooks using my ODBC Connection: Unexpected error: Attempted to read o...
- 8 years ago
Dear All,
I have posted this problem also in the issues section of the power BI Forum and it was accepted:
Fortunately this will be fixed in the upcoming December edition!
So hold tight, it won't be long.
Kind regards
Christian
philmaynard
8 years agoRegular Visitor
I had exactly the same issue attempting a connection with and ODBC driver to a Sage 50 database - this after any Power BI update in December 2017. I resolved it by changing the default SQL select query to only the columns I needed e.g.
SELECT CHART, CATEGORY, FLAG_ASSET_LIABILITY, NAME, LOW, HIGH, SORT_ORDER FROM CATEGORY
rather then the default
SELECT * FROM CATEGORY
This has worked for me. I hope it helps someone else
- Anonymous7 years agoNot applicable
I can't believe it, but your suggestion got it working for me. Unbelievable.
Thanks!