Forum Discussion
Error while connecting to NetSuite WebQuery using Power BI
Hi All,
We are trying to connect Power BI to NetSuite report using WebQuery. We enabled WebQuery for one of the NetSuite report and Created URL for that particular report.
When I put that URL in Browser, I can see report output perfectly fine. The moment I put that URL in PowerBI using Web Adapter it gives error mesage (Screen Attached) and pulls nothing. Please let us know If we are missing something
Our Sample URL look like as below. (Replace Bold text with original values)
https://<ServerName>/app/reporting/reportrunner.nl?compid=XXXXXXXXXXXXXX&entity=XXXXXX&email=<EmailId>&role=X&cr=<ReportID>&hash=XXX-XXX-ETC= Selection=EntirePage
2 Replies
Hi saket_mca1 ,
Hope this case can help you 🙂
https://community.powerbi.com/t5/Desktop/Netsuite-connectivity-with-Power-BI/td-p/172781
You can also try Acterys: Planning, Consolidation For Power BI & Excel Acterys automatically creates editable, Azure/MS SQL tables, optimized for analysis with the required Netsuite tables. It also adds comprehensive planning and write-back optios with 8 Power BI custom visuals: Acterys Planning & Analytics For Power BI & Excel (microsoft.com)
