Bring your Power Bi to Power Apps Portal – Part II

In the previous blog we covered how to embed Power BI Report in Power Apps Portal using “Publish to Web” and “Embed for organization” mode, In this post we will cover “Embed for your customers” mode and then applying Row level security(RLS) on the report.

Method 2: Embed for your Customers- Power Bi Report for private customer reports.

Enable Power Apps Portals for Power Bi integration and create your Power Bi report you want to publish under the Power Bi workspace you have defined during Power Bi Setup earlier. Refer the part I blog for steps.

Enable RLS on Power Bi Report:

Enable Report for Row level security by adding role, its required for embedded customers mode to function. On Power Bi Report under Modeling Click on Mange roles

navigate to manage role under Power Bi
Continue reading “Bring your Power Bi to Power Apps Portal – Part II”

Bring your Power Bi to Power Apps Portal – Part I

Power BI has become the choice of tool when we talk about Reports, Power Apps portal has built in reporting and charts but if are looking for modern dashboard and reports embedding Power Bi in Power apps portal is the way to go, In this blog we will look into the different ways that could be done,

Before any of this could be done we need to Setup and enable Portal for Power Bi Visualization, here is the detailed steps from Microsoft Documentation for enabling Power Apps portal for Power Bi Visualization and embedded service which allows powerbi liquid tag to work in Portal

Here is the list of Key steps involved, but refer to Microsoft doc for detailed steps

Continue reading “Bring your Power Bi to Power Apps Portal – Part I”

Power Platform & Azure – Better Together: Build Power Apps from Azure SQL

Power Platform and Azure connected together is such a powerful story of “Powerful alone, but better together”. When connected to Azure, Microsoft Power Platform enables you to quickly deliver value and build Enterprise solutions.

We always had the capability in App maker experience to connect to Azure SQL and build applications that interact or use data from Azure SQL using SQL connectors.

With the new Feature announced now, You can initiate/Build a Power Platform application using Azure SQL from within Azure Portal.

In this blog, we will look into how Azure SQL and PowerPlatform can be connected together.

What you need:

  • Azure SQL Database
  • Server firewall on database to enable Azure server and Power Platform services  to access the database

How to set it up:

    • Navigate to Azure SQL instance in Azure Portal
    • Select the database you want to build on using Power Platform
    • Click on the Power Platform application you want to build from the left sidebar

Power Apps:

  • Upon clicking on Power Apps, you would be presented with page to get Started, it will also provide learn resources.
  • Upon click of get started you will be presented with page to provide details for App you want to create and table you wish to use.

 

Upon Click of create you would be redirected to Power Apps studio with continue building Power Apps.

Power Automate:

Upon clicking on Power Automate, you would be presented with page with some of most popular SQL server templates

Clicking on them will present you with details on scenario and option to try it. If you choose to try, it will redirect to Power Automate studio to continue building.

Power BI:

Upon clicking on Power BI, you are presented with page to get started.

Clicking on get started will download the pbids file, which you can open in Power BI desktop and continue building on the sql database.

There are a lot of new features which enables Power Platform and Azure to work together, to find more check the blogs by following the tag #PowerfulAloneBetterTogether

Power Platform & Azure – Better Together: Azure APIM Connector

Power Platform and Azure connected together is such a powerful story of “Powerful alone, but better together”. In this blog, we will look into how Azure APIM and PowerPlatform can be connected together.

Power Platform and Azure connected together is such a powerful story of “Powerful alone, but better together”. When connected to Azure, Microsoft Power Platform enables you to quickly deliver value and build Enterprise solutions.

In this blog, we will look into how Azure APIM and PowerPlatform can be connected together.

Azure APIM:  Digital transformation runs of APIs ( application programming interface).  Api’s are abstractions, they allow you to decouple consumption and implementation based on standards which allow them to be available to work with any platform and any applications.`

Anyone can build api and publish them, but building api and running it as a strategic business is another thing. This is where APIM provides value, Azure API management provides a gateway for api using which organizations publish APIs to external, partner, and internal developers to leverage them and access different data and services. 

Continue reading “Power Platform & Azure – Better Together: Azure APIM Connector”