Gateway error - Refresh failed due to gateway configuration issues - same source new report

I was able to solve this issue and would like to share my solution in case there is anyone else out there using NetSuite in the Cloud with Power BI. 

1. You first need to install the correct ODBC driver for NetSuite (32 or 64 bit) both on your development machine and the server where your gateway is installed. Configure and test both to ensure they connect.

2. Build and test your report in Power BI desktop using the ODBC connection and make sure your report refreshes correctly and then publish to the Power BI Service.

3. Make sure your Data Source Name matches the name of the ODBC connection your created on the gateway server.

4. This is the important bit - add the connection to the gateway. When configuring the connection on the gateway, you must enter the following in the Connection String "Driver=NetSuite Drivers 64bit;Dsn=NetSuite;sdsn=NetSuite.com;hst=yourcloudodbcserver.netsuite.com;prt=1708". NB: this was posted on a NestSuite forum and without these setting I was unable to get the connection to work and the report data to refresh.

5. I used basic authentication and my netsuite username & password. This allowed me to make the connection and also reuse this connection for other reports.

Hope this helps anyone else having issues reporting from NetSuite in the Cloud and Power BI.

Cheers

John