Connecting a Power Portal Data source to Power BI (Business Intelligence) Desktop for Business Analytics

| Muhammad Yaseen

So first what is power Bi, Power BI is an interactive  data visualization  software product developed by Microsoft  with primary focus on business intelligence. It is part of the  Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a  database, webpage, or structured files such as spreadsheets,  CSVXML, and  JSON.(Source Wikipedia).

In this blog I am using power Bi desktop, process of connection will be the same with 1 to 2 differences.

Environment-Variables-in-Canvas-Apps

To connect a Power Portal Data source to power BI

Environment-Variables-in-Canvas-Apps

Environment-Variables-in-Canvas-Apps

Environment-Variables-in-Canvas-Apps

Sign in with credentials in to your portal environment in which your Table data resides.

Now you can select the check box of your desired table and click on load.

You can also transform data to-do data cleansing so your analytics will be more reliable and accurate.

Environment-Variables-in-Canvas-Apps

On the left side menu you can see 3 icons.

Environment-Variables-in-Canvas-Apps

  • First is for the report view; here you can do the main Visualizations of your report using the below build visuals

Environment-Variables-in-Canvas-Apps

  1. Cards (to show the measure like total no of employees in a table)
  2. Filters (to use filtering in the records like you want to show the data in between dates)
  3. Graphs (multiple type of graphs available like (pi-chart, bar chart, line chart) to show the data)
  4. Table to show the data columns specifically.

Here you can also add the designing to your report

Sample Power Bi Report

Environment-Variables-in-Canvas-Apps

  • Second one is to view the data of your loaded tables
  • Third one is to show the relationship between your tables and here you can also make or edit the relationship between your tables.

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting