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 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? 
Formulas and functions
Tips and tricks
    • 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>';
      })();

      '>"