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 Excel as data-source. Excel design enables it to act as a quasi-DBMS, with individual worksheet acting as a table and workbook as a database. But Excel, being a spreadsheet genre software, lacks enforceability making it vulnerable to breaking-down entire Power BI rep ..read more

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 recognition, which plays an important role in advanced analytics, quicker insights from data models, an automatic Q&A system, and more. In Power BI, there are various sections with AI features and capabilities. As we know that Power BI work role is divided into 3 parts, which involve Data Prep ..read more

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. From there, we may apply all of these filters. (refer to the image below) Now we will see each filter type in detail, like how to apply them and also the type of filtering that can be applied: 1. Visual Level Filter: This Filter is used in sorting s ..read more

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 restrict this data access. You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server. For Analysis Services or Azure Analysis Services lives connections, you configure Row-level s ..read more

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 open the report from where it was pinned. One important point to remember is that reports are based on a single data set. The visualizations in a report represent a nugget of information. These visualizations aren’t static, you have the option ..read more

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 to showcase different insights, allowing you to correctly apply and design visuals in your reports so that you are implementing best practices and driving clear insights. What are Power BI Visuals Visuals are simply a visual (picture) representation of your data and are th ..read more

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 report. Copying creates a standard Power BI report that you can edit. You can also build your own reports in Power BI Desktop based on the underlying dataset, which contains usage metrics for all dashboards or all reports in a workspace. To begin ..read more

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 Database Server, Online CRM/ERP Services, Excel files etc. hosted within an organization’s network or over the cloud. Apart from that, users also heavily use hyperlink to another Excel files reusing existing source data already prepared by other ..read more

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 visuals with any other Power App visual. Why need to change power apps visual?  As we go from Dev to Prod after development is complete that time, we need to change the Power App visual to point to Production environment.  How to change existing power apps visual to another app?  There are two ways to do this.  ..read more

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 think of redevelopment or redesigning of the report for better performance. There are some best practices that when implemented can lead us to better performance, let’s see them one by one- 1. Reducing the model size– Model size is correlated in the negative direction to model performance ..read more