Forum Discussion

ReubenJ17's avatar
ReubenJ17
Regular Visitor
7 years ago
Solved

Using a .iqy file for live import

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!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      ReubenJ17
      Regular Visitor
      7 years ago

      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

  • dquirimet's avatar
    dquirimet
    New Member
    4 years ago

    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