Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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¶meter_0=["Pay Date on"]&encoding=ANSI
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |