I believe this issue coincides with the June update. 2 days ago PBI Desktop stopped allowing me to refresh data and produced the following error: JSON integer 4294967295 is too large or small for an ...
Dave-ExpSC
Helper II
4 years agoake I finally got it to work with the Detect Data fix. My problem was that I was highlighting all columns in the table and then using Detect. The structure of the MySql data that I pull down also has many columns of tables that reference other elements of the databases. When I did NOT slect those columns and use Detect Data - it finally worked properly.
Interesting that I did not have these issues before the June update. Now I can not even pull down a table and Apply it without going through this Detect step. Kind of annoying that I now have to treat data from MySql source differently than other sources. Thanks all for helping me get to a solution.