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!!
Try adding the 'Amount' field along with Amount(Credit), Amount (debit) fields in the Custom Trial Balance report and see if you're able to see the fields in the export in Excel. Amount should have both debit and credit amounts combined, hope this helps!
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?
When there’s a lot of data in your NetSuite report, the table preview sometimes doesn’t show up/load in Power BI. I would recommend reducing the data in the NetSuite report (ex: Quarter instead of a year) and try loading it into Power BI through the web query - see if that helps to get the data into Power BI.
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?
You can just change the date range in your NetSuite report to include to date to be March 23 or just put Dec 23 if you want data up till then - you can also put a custom date range in your NetSuite report and then refresh the data in Power BI
Try to break it into two reports using date filters to see if the error goes away when importing the web queries. You can always merge the datasets in Power BI/Excel for your analysis.
@@karimderouich Other alternatives would be: Via saved search - ruclips.net/video/pUK6npJQIds/видео.html Paid - ODBC connector (SuiteAnalytics connect) - write SuiteQL to retrieve the data you want into Power BI/Excel
![Connect Power BI with NetSuite via SuiteAnalytics Connect [ODBC drivers]](http://i.ytimg.com/vi/MVpW_Zr-UUc/mqdefault.jpg)
Dude, youre the best!! you helped me fix something that has been giving me trobules for months :) Thanks!
You're welcome :). I'll try and share more content that will help export data from NetSuite - SuiteQL next
It's brilliant! Exactly what I am looking for. Thanks!
You're welcome!
Thanks mate
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?
Use the relative date filter on the NetSuite report (ex: this year) so you can get the latest data upon refresh in Power BI
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..?
resetlet + colab + google drive
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!!
Try adding the 'Amount' field along with Amount(Credit), Amount (debit) fields in the Custom Trial Balance report and see if you're able to see the fields in the export in Excel. Amount should have both debit and credit amounts combined, hope this helps!
Hola, me aparece error 500 al tratar de conectame al URL de netsuite,
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?
When there’s a lot of data in your NetSuite report, the table preview sometimes doesn’t show up/load in Power BI. I would recommend reducing the data in the NetSuite report (ex: Quarter instead of a year) and try loading it into Power BI through the web query - see if that helps to get the data into Power BI.
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?
You can just change the date range in your NetSuite report to include to date to be March 23 or just put Dec 23 if you want data up till then - you can also put a custom date range in your NetSuite report and then refresh the data in Power BI
what to do when we have more than 10k rows I have active scripting error ?
Try to break it into two reports using date filters to see if the error goes away when importing the web queries. You can always merge the datasets in Power BI/Excel for your analysis.
@@dataants Yes, this is what I do, actually but do you have any idea of the limitations ? or any other solution ?
@@karimderouich Other alternatives would be:
Via saved search -
ruclips.net/video/pUK6npJQIds/видео.html
Paid - ODBC connector (SuiteAnalytics connect) - write SuiteQL to retrieve the data you want into Power BI/Excel
Can you create a video to show how to convert the text columns to numbers. It is giving me an error
Hi, I dont see webquery in my netsuite even I have admin. rights
It's not available for all reports, try looking for a custom non financial report to see the web query option
Hii i am not getting the data . It's showing unauthorized access in browser and it's also not fetching data in power bi
It has been reprecated. No longer working
@@shinanigans1992 Now I am able to get the data. It's working now.
@@shinanigans1992 still working for me
@@shinanigans1992 what would be the new alternative if this approach no longer works?
"Access Denied" - of course it is. 😮💨