Forum Discussion
Using a .iqy file for live import
ReubenJ17,
Right click the .iqy file to utilize the “Open With” command, and use a qualified text editor . Delete the italic text and replace it with bold . Then you can use web connector in Power BI Desktop to connect to the web URL.
WEB1 https://system.na1.netsuite.com/app/reporting/webquery.nl?compid=XXXXXXXXXXXXXX&entity=XXXXXX&email= [“emailaddress”,”Please enter your email address:”] &role=X&cr=XXX&hash=XXX-XXX-ETC= Selection=EntirePage Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False
For more details, please review this blog: https://datachant.com/2017/02/03/connect-netsuite-to-power-bi/.
Regards,
Lydia
ReubenJ17,
Right click the .iqy file to utilize the “Open With” command, and use a qualified text editor . Delete the italic text and replace it with bold . Then you can use web connector in Power BI Desktop to connect to the web URL.
WEB1 https://system.na1.netsuite.com/app/reporting/webquery.nl?compid=XXXXXXXXXXXXXX&entity=XXXXXX&email= [“emailaddress”,”Please enter your email address:”] &role=X&cr=XXX&hash=XXX-XXX-ETC= Selection=EntirePage Formatting=All PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False
For more details, please review this blog: https://datachant.com/2017/02/03/connect-netsuite-to-power-bi/.
Regards,
Lydia
Thanks Lydia! Exactly what I was looking for!
Can anything be done around 'auto-refreshing' using this method? I'd like the dashboard to be able to update as soon as data changes in NS.
Thanks again,
Reuben