Error while connecting to NetSuite WebQuery using Power BI

[saket_mca1]

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

[karaoan]

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)

[v-frfei-msft]

Hi @saket_mca1 ,

Hope this case can help you 🙂

https://community.powerbi.com/t5/Desktop/Netsuite-connectivity-with-Power-BI/td-p/172781