Using a .iqy file for live import

[ReubenJ17]

Hi All,

I am trying to use a .iqy file that I have downloaded from a NetSuite report to import a live data feed to PowerBi.

This can be done quite easily with Excel simply by opening the file, however getting it into PowerBi has proven much more difficult.

If anyone can point me in the right direction I'd be very grateful!

[dquirimet]

Hi Lydia, Our .iqy has shorter data and it gives token session. we use different tool for our company (not net suite). how should I handle it with my case? note - i need to omit the link

WEB
1
https:[.... link of tool query...]
token=e45bdcf1-27b9-4233-ad49-c3ee4572db74&id=244154369&locale=en_US&parameter_0=["Pay Date on"]&encoding=ANSI

[v-yuezhe-msft · Accepted solution]

@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]

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