Power BI Embeded Solution

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Acknowledged
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? 
Photo of rocketc

rocketc

  • 844 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Feel free to contact me off-world to discuss this project using the information in my profile:

https://getsatisfaction.com/people/dandiebolt
(Edited)
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
I feel like this is kind of big news that I totally missed...
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. 
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..
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.
Photo of rocketc

rocketc

  • 844 Points 500 badge 2x thumb
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
Photo of Joey Zint

Joey Zint

  • 1,870 Points 1k badge 2x thumb
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


Photo of Joey Zint

Joey Zint

  • 1,870 Points 1k badge 2x thumb
Disregard my request, I did not have the latest version of Power BI downloaded