How to pull data from NetSuite into Power BI & Excel

This article describes how to pull data from NetSuite into Power BI.

1. Create a NetSuite Report with the data you want to use in Power BI
2. Export an Excel Web Query from the Report page.

3. You’ll get an IQY file. Open it with a text editor and get the URL from it. It should be similar to this:

https://999999.app.netsuite.com/app/reporting/webquery.nl?compid=99999&entity=99999&email=["emailaddress","Please enter your email address:”]&role=9&cr=999&hash=*******************

4. Replace the part between brackets with the account that have access to that report. You’ll end up with something similar to this:

https://999999.app.netsuite.com/app/reporting/webquery.nl?compid=99999&entity=99999&email=hello@gmail.com&role=9&cr=999&hash=*******************

5. In Power BI or Excel create a blank query, select advance editor, and enter the following using the URL you obtained from NetSuite.

let
Source = Web.Page(Web.Contents("https://999999.app.netsuite.com/app/reporting/webquery.nl?compid=99999&entity=99999&email=hello@gmail.com&role=9&cr=999&hash=*******************")),
Data0 = Source{0}[Data]
in
Data0

6. This will give you all the data from the report. You may just need to clean it up a little, as the numbers may have some strange characters.