Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
belmore
Helper II
Helper II

How to embed a PowerBI.com report into cloud app (quickbase)?

I use Quickbase as a cloud platform to build Cloud Apps and Power BI as my BI platform.  I would like to integrate/embed my Power BI reports into my Quickbase applications. My goal would be to embed using the PowerBI.com API vs. Power BI embedding services. Is this possible to do? I appreciate any help/advice. 

5 REPLIES 5
Eric_Zhang
Employee
Employee


@belmore wrote:

I use Quickbase as a cloud platform to build Cloud Apps and Power BI as my BI platform.  I would like to integrate/embed my Power BI reports into my Quickbase applications. My goal would be to embed using the PowerBI.com API vs. Power BI embedding services. Is this possible to do? I appreciate any help/advice. 


PowerBI.com API and Power BI embedding are both compatible to almost any web application(.NET is typically recommended). Whether it is possible to embed Power BI report in your case is all depending on quickbase side. I don't know about your quickbase, so I'd suggest you post an question on the quickbase community.


By the way, check github libraries for  embeding reports via PowerBI.com API and Power BI embedded.

Power BI Emebedded

Power BI REST API

 

 

 

v-lvzhan, thank you for your reply. I'm confident that it is possible to embed within quickbase....I had no issues with embedding Tableau dashboards and reports....the only requirement was that a quickbase user must also have a Tableau online license....so in order to view the tableau report within quickbase the user a) must already had been signed into tableau online or b) login to tableau through the embedded tableau report.

 

I get lost when it comes to registering a web-app? I'm not sure how best to complete the form....since Quickbase is not My app.....any advice would be greatly appreciated here....App Type:, Redirect URI:, Home Page:

App Name: 
App Type: 
Redirect URI:
Home Page:
 
I believe if I can set this up correctly...then I have a chance at getting this to work. Thank you

The simplist way to embed power bi can be using a static HTML. "Registering a web-app" is to get the the accessToken that is used to embed. Here's the embeded sample .

 

As to the web-app, I started from this page Step 1: Register an app with Azure AD.

 

<html lang="en">
<head> 
    <script type="text/javascript">

        window.onload = function () {
		
		updateEmbedTile(); 
        };

        var width = 500;
        var height = 500; 

        // update embed tile
        function updateEmbedTile() {
            // check if the embed url was selected
            var embedTileUrl = "https://msit.powerbi.com/embed?dashboardId=f1f5155b-c6e2-4147-991b-28d914927d05&tileId=50de3c3a-2e8c-49bd-ada4-18d0b1e19415";
            if ("" === embedTileUrl)
                return;

            // to load a tile do the following:
            // 1: set the url, include size.
            // 2: add a onload handler to submit the auth token
            iframe = document.getElementById('iFrameEmbedTile');
            iframe.src=embedTileUrl + "&width=" + width + "&height=" + height;
            iframe.onload = postActionLoadTile;
        }

        
        // post the auth token to the iFrame. 
        function postActionLoadTile() {
            // get the access token.
            accessToken = "YOURTOKENHERE";

            // return if no a
            if ("" === accessToken)
                return;

            var h = height;
            var w = width; 

            // construct the push message structure
            var m = { action: "loadTile", accessToken: accessToken, height: h, width: w};
            message = JSON.stringify(m);

            // push the message.
            iframe = document.getElementById('iFrameEmbedTile');
            iframe.contentWindow.postMessage(message, "*");;
        }

    </script>
</head>
<body>

<iframe ID="iFrameEmbedTile" src="" height="500px" width="500px" frameborder="0" seamless></iframe>

<!-- Visual Studio Browser Link -->
<script type="application/json" id="__browserLink_initializationData">
    {"appName":"Chrome","requestId":"ab3c9a4238164ad2bb8954672a5a9399"}
</script>
<script type="text/javascript" src="http://localhost:37067/ed3b2d1937bc4b06bd06d5ce0d652d66/browserLink" async="async"></script>
<!-- End Browser Link -->

</body>
</html>

Thank you for your help. This is all a little above my head. It would be GREAT.....if I could leverage ( http://docs.powerbi.apiary.io/# ) to generate the embedding code. I can use the Apiary app the see a list of reports within my PowerBI.com account.....It would be super to select a report and have the Apiary app generate the embedding code.

 

Thanks again

@belmore

I'd suggest you use this MSDN documentation, it would be more up to date.

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.