This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I don't have personal experience, but there are two solutions I've heard of
<https://powerbi.microsoft.com/en-us/partner-showcase/satori-technology-llc-netsuite-data-via-satori-reporting/>

<http://suiteapp.com/Tactical-Connect-For-Microsoft-PowerBI-and-Excel>

I've written other portlets but not PowerBI. If those products do it, you have validation that it's definitely possible :smiley:

Having a look at one of the portlets I have handy - what I did was put my content into an html file in the file cabinet - and in the portlet script I read that file and set the the value of an inline html field to the contents of that file

Using basic find and replace to set some dynamic values

```export function render(context: EntryPoints.Portlet.renderContext) {
  context.portlet.title = 'Sales KPI';

  let html = file
    .load({
      id: 'SuiteScripts/Dashboard KPI/assets/mos_dashboardkpi.html',
    })
    .getContents();

  const monthlySalesPercent = calculateMonthlySalesPercent();
  const yearlySalesPercent = calculateYearlySalesPercent();

  const { lowerTarget, upperTarget } = calculateDailyTarget();
  const dailyTarget = `${lowerTarget}-${upperTarget}`;
  const dailyTargetMet =
    parseFloat(monthlySalesPercent) &gt;= lowerTarget ? 'true' : 'false';

  html = html.replace('{{salesPercentMonth}}', monthlySalesPercent);
  html = html.replace('{{salesPercentYear}}', yearlySalesPercent);
  html = html.replace('{{dailyTarget}}', dailyTarget);
  html = html.replace('{{dailyTargetMet}}', dailyTargetMet);

  context.portlet.addField(
    { type: ui.FieldType.INLINEHTML, label: 'Inline HTML', id: 'inlinehtml' }
  ).defaultValue = html;
}```

Lol I just make a multi million dollar sale in sandbox to show off the graffiti when the target is met :rolling_on_the_floor_laughing:

Nice. I helped one of my BI guys add an HTML portlet. Was a lot more work than you did here. Granted, half the battle was getting his power BI hooked to NetSuite