Discussions

Expand all | Collapse all

Power BI Embeded Solution

  • 1.  Power BI Embeded Solution

    Posted 04-04-2017 15:37
    I use Microsoft's Power BI as my primary analysis tool and I would like to embed Power BI reports that I have created into my Quickbase application.  I believe this can be achieved and I wanted to ask if anyone would be interested in working together to solve? 


  • 2.  RE: Power BI Embeded Solution

    Posted 04-04-2017 15:39
    Feel free to contact me off-world to discuss this project using the information in my profile:

    https://getsatisfaction.com/people/dandiebolt">https://getsatisfaction.com/people/dandiebolt">https://getsatisfaction.com/people/dandiebolt


  • 3.  RE: Power BI Embeded Solution

    Posted 02-19-2019 17:41
    Microsoft just released the Quick Base Connector to Microsoft Power BI.

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2019-feature-summary/

    Power BI Desktop Update - February 2018
    https://www.youtube.com/watch?v=KeVB5RwMzJo


    quick basePNG


  • 4.  RE: Power BI Embeded Solution

    Posted 03-26-2019 20:08
    I feel like this is kind of big news that I totally missed...


  • 5.  RE: Power BI Embeded Solution

    Posted 03-26-2019 21:18
    It was kind of snuck into the QB release for February I think. Its a pretty powerful out of the box solution, especially for a lot of companies that already have a Office 365 account since I think it comes out of the box. If you want to get creative with it, we've tried a few examples of embedding a Power BI dash as an iFrame in a QB dash. Its a little quirky with the auth, but nonetheless a really nice feature from Power BI. 


  • 6.  RE: Power BI Embeded Solution

    Posted 03-26-2019 23:16
    It's a cool bit of validation for QB, as well. Or maybe I'm behind the times in thinking of QB as the plucky upstart..


  • 7.  RE: Power BI Embeded Solution

    Posted 03-26-2019 23:34
    Personally I think it adds a little bit more enterprise appeal. If you look at it from an exec standpoint - they may never log into Quick Base but if you feed Quick Base data into Power BI, that becomes the point of reference while day to day Quick Base users have the ease and flexibility of interacting with QB as the system of record.


  • 8.  RE: Power BI Embeded Solution

    Posted 03-26-2019 23:38
    SSOT, baby.


  • 9.  RE: Power BI Embeded Solution

    Posted 03-27-2019 14:34
    Embedding TIP:

    I used the steps below to embed a Power BI report within a Quickbase form/record and passed a Quickbase field into the power bi embedding URL for the purpose of filtering the Power BI report.

    1st) I created a URL formula field --- inserted the embedded URL (Secure Embed method) from PowerBI below --- and inserted my qbase "filter field" - [state] -- I may have broken many coding rules -- but it works...

    [URLFormulafield]
    "http..app.powerbi.com/reportEmbed?reportId=802c359548-aaa8-b910f9725ea0&groupId=178e0-41741f6a5853&autoAuth=true&pageName=ReportSection&$filter=Accounts%2FCategory%20eq%20%27"&URLEncode([State])&"%27"    


    2nd) 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>';
    })();

    '>"
    No need for a code page


  • 10.  RE: Power BI Embeded Solution

    Posted 05-22-2019 21:04
    I am currently using Power BI in QB with qunect. My question is I am not seeing the new QuickBase connector in my list of other options, is there something that needs to be downloaded




  • 11.  RE: Power BI Embeded Solution

    Posted 05-22-2019 21:17
    Disregard my request, I did not have the latest version of Power BI downloaded