Error while trying to load data via odbc/power query

[catabell2010]

While trying to retreive my data via ODBC connection, I am able to see the preview of my file  but when I try to load the file.
However when I try to load the file, I get following error message:
"Failed to save Modifications to the Server.Error returned"
P.S: This problem occurs only for Files having greater than 100,000 records

[Greg_Deckler]

I'm assuming this is in Desktop, you can try turning on tracing, File | Options and settings | Options | Diagnostics | Enable Tracing

You can then contact support by sending a frowny face or open a ticket using https://support.powerbi.com using the Contact Support link on that page.