Discussions

Expand all | Collapse all

Embed Power BI report within a Qbase record form

  • 1.  Embed Power BI report within a Qbase record form

    Posted 01-24-2019 16:01
    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">https://docs.microsoft.com/en-us/power-bi/service-embed-secure">Power BI Secure Embed

    Any suggestions on how best to accomplish this goal? 


  • 2.  RE: Embed Power BI report within a Qbase record form

    Posted 01-24-2019 21:23
    I got this working


  • 3.  RE: Embed Power BI report within a Qbase record form

    Posted 02-15-2019 14:46
    How did you do it?


  • 4.  RE: Embed Power BI report within a Qbase record form

    Posted 02-15-2019 17:54
    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>';
    })();

    '>"