Microsoft

Firstly, starting with, what is Rank function in Power BI? So, Power BI’s Rank function returns the ranking order based on the order specified. The Rank column command adds a new column to a table, with the ranking determined by one or more other table columns. To specify how ties should be handled, use the […]

Dynamic Data Source in Power BI Power BI is a very powerful tool, and we can do wonders with it, but when it comes to changing the source, most of us are afraid of it. This is because by doing so, we may need to make many changes related to a data model, DAX, visualizations, […]

Meet Toni Milushev, Director of Product Engineering Perficient is committed to Growth for Everyone, and colleague Toni Milushev is a great example of how we’re helping our people grow professionally. He takes the initiative to go above and beyond his role and is quick to lend a helping hand to assist those around him in […]

Microsoft has released the feature Export to PDF option from Power BI Desktop. This feature has been available in every update of the Power BI desktop since August 2018. Read to explore this option and how to use it. Now, let’s get started. The following screenshot refers to the sample of my report. How To […]

Live Connection Mode: Power BI Live Connection is one of the connection modes to connect the data source into Power BI, just like Import and Direct Query. As of now, some of the cloud data sources we can connect through Power BI Live Connection are: Azure Analysis Services SQL Server Analysis Services Tabular  SQL Server […]

This article is dedicated to retrieving different data values available on Dataverse tables using client-side scripts such as JavaScript. This technic would be very helpful to extend model-driven form out-of-box functionality to meet the real-time business requirement, such as implementing complex business rules validations, making form fields hide/show, manipulating datatypes values, and many more. Now […]

Technology is changing quickly, and it seems like there is something new every day. It can be intimidating to try and keep up with all the latest tech news, let alone implement it for your business. Brands often struggle with where to put their resources, what to invest in, and how to implement new technologies […]

Microsoft Graph API in SharePoint SPFX  enables us to fetch the data from O365. To connect with the data of millions of people in the Microsoft cloud, use the Microsoft Graph API. Build apps for businesses and people that connect to a plethora of data, relationships, and knowledge via a single endpoint using Microsoft Graph. […]

The following are the steps that play a significant role while developing a Power BI report: Step 1: Get Data (Identifying the Data Sources) Power BI provides a direct way, i.e., the “Get Data” feature, through which you can connect to various sources that range from flat-file, server-based, and cloud-based data sources. The data can […]

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 […]

POWER BI – DRILLTHROUGH FROM ONE REPORT TO ANOTHER REPORT FOR INCREASED SECURITY (CROSS-REPORT DRILL THROUGH) APPLIES TO: ✓ Power BI Desktop ✓ Power BI service The traditional drill-through does not allow to drill through from one report to another report. It only works in a single report. It is a page-to-page drill-through. Cross-report drill through allows […]

Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right building blocks is a crucial part of running a good business. This is where the dynamic duo of ETL and SQL comes into play. While you may […]