Posts Tagged ‘Power BI’

Background Excel is the most used spreadsheet software in today’s era, used by every level of organization. Quite a huge amount of unorganized data is maintained in Excel workbooks, owing to ease of quick creation, storage & sharing of Excel files over database. Resultant many of the Power BI reports / dashboards are based on […]

AI Insights and Visuals AI has been evolving in many sectors of technology, and the same is being implemented in Power BI to a very good extent. In 2019, there were enhancements in Power BI where more powerful AI features were included, like AI visuals, Text analytics, the inclusion of Azure machine learning models, Image […]

Power BI filters are useful tools for organizing data, visualizing and comparing your data visualizations, and creating reports. They are utilized to sort data according to a chosen condition. Filter Types : Visual Level Filter Page Level Filter Report Level Filter Drill Through Filter On the right side of the dashboard, locate the Filter Pane. […]

What is RLS with Power BI Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn’t […]

Reports In Power BI A Power BI report is nothing but a multi-perspective view of a data set with visualizations that represent different findings and insights from that data set. A report may be a single visualization or pages full of visualizations. Visualizations can be pinned to dashboards and if you select the pinned visualization, it will […]

Introduction Without the right visuals, your Power BI report is redundant. To showcase powerful insights you need to understand when and how to use different visuals so that you can avoid wasting valuable time on building reports that don’t make an impact. We’ll walk through the process we use to decide which visuals to use […]

Usage metrics help you understand the impact of your dashboards and reports. When you run either dashboard usage metrics or report usage metrics, you discover how those dashboards and reports are being used throughout your organization, who’s using them, and for what purpose. Usage metrics reports are read-only. However, you can copy a usage metrics […]

As in the previous two parts, we will see how to integrate and use Power Apps as a writeback option in the Power BI dashboard in this part. We will see how to change the fields passed from Power BI to Power Apps as a data source, as well as how to change Power Apps […]

Power BI Performance Tuning Whenever we start developing reports in Power BI three important things always come to mind these are data accuracy, data security, and report performance. If the report performance is not up to the mark, then there is no meaning of how much effort we have put into it, we have to […]

Background Microsoft Excel is a popular and preferred spreadsheet solution for quick daily use reporting by the majority corporations and businesses in the world. Many times, corporate users need access to organization’s data in Excel for further development of MIS Reports. Power Query is a powerful tool embedded in Excel which can connect to internal […]

Writeback in Power BI Using Power Apps! Since we are aware that Power BI does not directly allow us for editing or writeback, we may use Power Apps to provide this feature. We learned how to integrate Power Apps on Power BI dashboard in the first part. In this section, we’ll create the same canvas […]

Microsoft Power Apps is an excellent example of a Platform as a Service (PaaS). It allows you to create mobile or tablet apps for internal business users that can run on Android, IOS, and Windows. We can now integrate Power Apps into our Power BI reports using the Power Apps visualization in the Power BI […]