Embed Power BI report within a Qbase record form

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Power BI has just released a new feature that provides the ability to securely embed a Power BI report from the Power BI Service via iframe or URL (very easy to embed using the url method within a qbase dashboard widget). It is also possible to filter PBI reports within the embedded URL.

My goal is to embed a PBI report within a qbase record -- and filter the embedded report by passing a qbase field into the embedded URL.

Power BI Secure Embed

Any suggestions on how best to accomplish this goal? 
Photo of rocketc

rocketc

  • 774 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of rocketc

rocketc

  • 774 Points 500 badge 2x thumb
I got this working
Photo of wwdmr

wwdmr

  • 246 Points 100 badge 2x thumb
How did you do it?
Photo of rocketc

rocketc

  • 774 Points 500 badge 2x thumb
Very Simple

I created a URL formula field --- and inserted the embedded URL from PowerBI---

and

Then created a formula Rich text field with the following formula: (see Dan's Pastie)

"<img data-url='" & [URLformulafield] & "'" &
" src onerror='

(async () => {
  var url = this.dataset.url;
  this.outerHTML = `<iframe src=${url} width=700px height=600px></iframe>`;
})();

'>"
(Edited)