Connect NetSuite to Power BI/Excel via WebQuery with refresh capability

Want to do further analysis of your NetSuite data in Power BI or Excel with refresh capabilities and not having to manually export? This video explains this step by step and if you need the detailed guide, please click the link below:

Follow us for more NetSuite and data related tips and tricks#netsuite
#netsuiteerp #powerbi #excel

[Stevenaramburo]

Dude, youre the best!! you helped me fix something that has been giving me trobules for months :) Thanks!

[sharonshen]

It's brilliant! Exactly what I am looking for. Thanks!

[kavalikishore-xgwt]

its good video thank you .. and can you please make a video how do we pull saved search report into Google sheet by using restlet api..?

[meg-e]

Your video is so helpful, thanks for posting! It worked perfectly for one report I created. For some reason when I try this with a trial balance with two columns (one for debit, one for credit) - it only exports the debit column. Any tips? I'm using Excel. Thanks!!

[MegaOrtsac]

Dude, i just try the exacly samething, but im my case i can't load the data in pbi cuz the pbi don't found any table, but i paste my url on browser and appers the table. I'm watching the video and i see diference beteween the url u copy and the url u paste. Do u have any tips?

[ericksegura]

The video i was looking for... quick question if my report has filter range dates how i can get delete those filter so BI upates with the latest info?

[ERICALEXANDERSEGURACAMPOS]

Hey excellent about the connection. I have a question i have a report from NS that has date range if i download let's say from Jan 2023 to Feb 2023 once March 23 numbers are available wont update. Do we need to run a new query including the new month every time?

[AndrewChen-lf]

Can you create a video to show how to convert the text columns to numbers. It is giving me an error

[karimderouich]

what to do when we have more than 10k rows I have active scripting error ?

[funtime]

Hi, I dont see webquery in my netsuite even I have admin. rights

[RoamingWithAbhijeet]

Hii i am not getting the data . It's showing unauthorized access in browser and it's also not fetching data in power bi

[symboliceon]

"Access Denied" - of course it is. 😮‍💨