Forum Discussion
Integrate PowerBI with Netsuite
Hi, devs I'm currently integrating PowerBI with Netsuite. I'm facing an issue. I want to know the way to get access token with Javascript API. Looking forward to hearing from you asap. ...
If you enable webquery on a saved report, you can then download a .igy file,
open this in a text editor strip out everything before htts:\\
and strip out the following from the end
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
replace
["emailaddress","Please enter your email address:"]
with
then copy the string and go into PBI and got o data sources and use a web data source, paste this in and use an anonmous authentication, and away you go
i've also created a powershell scrip with a smilar function to sync to local MSSQL DB and then you can point PBI to a SQL DB, personal prefernce which way round you want to access your data
