Failed to Import Data

I have been following these posts on Power BI as I have had the same issue myself. First I could not get past the authentication stage with https and my self-signed certificate so I disabled SSL.

Next I get to the Data Upload stage but the process crashes after 10 seconds. After lots of troubleshooting I found that the powerbifinance web service used by the content pack errors for some localised versions. GB (it errors) because there are no Accounting Period as the UK uses a localisation. I try again, it crashes after 30 seconds. I try all of the Microsoft published web services and find that page 1304 fails, it is failing as an ODATA service because there is a dialog onQueryClose().

I commented out that code. I run my Content Pack test again. After maybe 1 minute - Success. So all webservices must provide an ODATA result.

Matt Vardy