knowledgecenter-breadcrum

Knowledge Center

17 Jun, 2020

How to Integrate PowerApps with Power BI

Posted on 17 Jun, 2020 by Admin, Posted in Power BI Power Apps

How to Integrate PowerApps with Power BI Blogs

How to Integrate PowerApps with Power BI

  1. Log in to your Power BI account, if you do not already have one you can go and create a Power BI account from your existing Office account.
    Go to this Link for Power BI account creation:
    https://signup.microsoft.com/signup?sku=a403ebcc-fae0-4ca2-8c8c-7a907fd6c235&ru=https://app.powerbi.com?pbi_source=desktop&redirectedFromSignup=1&noSignUpCheck=1
  1. After Logging in, you will have to add a data source to your Power BI for it to draw the data from.
  2. There are tons of options you can choose from when adding datasets to your Power BI, for this example we will choose an Excel sheet.
  3. You can do that by Selecting:
    Get Data > Excel.
  1. Select the Excel file in which you have the data. After selecting the Excel, a Pop up will appear select the Table and click Load.
  1. Once you have Loaded the data you will be able to see all the columns in the field’s pane on the right.
  2. Select the PowerApps Visual from the Visualization Pane.

    Note: Previously we had to go to Marketplace if we wanted to add the PowerApps Visual, but now this visual comes pinned in the visualization pane.
  1. Select the fields for which you want to have PowerApps Visual and you can do one of two things for PowerApps:
    Choose an app which you have already made or create a new one.
  1. You can see that this app is now integrated with Power BI and will be available on Power BI.
    Note: Since you are creating this app from Power BI, you cannot find this app when you search it through PowerApps.
  1. You can change the Screen Orientation, Page Layout, etc and basically customize it however you want to for your own needs.
    You can change the Screen Orientation by going to File > Settings > Screen Size & Orientation > Landscape > Apply.
  1. You can change the Layout by going to Properties Tab from the right and Selecting the Layout which you prefer. 
  1. Once you have completed your customization for the App.
    Go to File > Save As > Enter the Name for your App > Click Save.
  1. Once the save is complete, you can see your app in your Power BI.

Comment

This is a Required Field

Loading

Recent Updates

Blogs
15 May, 2024

Associated Grid Control Component in Dataverse

The Associated Grid Control enables us to improve the simplicity and readability of forms by displaying related record details across…

READ MORE
Blogs
08 May, 2024

How to Create Product Catalog in Dynamics 365 for Sales - Part 2

This is the second part of the blog. In this blog, we will cover the 3 components of the Product…

READ MORE
Blog Title
Blogs
07 May, 2024

Unleashing Business Potential: How CRM Software Drives ROI and Fuels Growth

Unleashing Business Potential: How CRM Software Drives ROI and Fuels Growth In today's competitive business landscape, maximizing return on investment…

READ MORE