Forum Discussion

BradElmore's avatar
BradElmore
Qrew Assistant Captain
7 years ago

Embed Power BI report within a Qbase record form

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 qba...
Formulas and functions
Tips and tricks
BradElmore's avatar
BradElmore
Qrew Assistant Captain
7 years ago
I got this working
  • WladimirLlanos's avatar
    WladimirLlanos
    Qrew Member
    7 years ago
    How did you do it?
  • BradElmore's avatar
    BradElmore
    Qrew Assistant Captain
    7 years ago
    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>';
    })();

    '>"