The data profile allows a intuitive ways to clean, transform, and understand data which helps you identifying the nuances of the data such as determining anomalies, examining and developing the underlying data structures, and querying…
Row-Level security (RLS) is a feature of Power BI that can be used to restrict data access for given users, so the appropriate person can see the appropriate records. Row-Level security uses a DAX filters…
This is a performance and usage metrics features that you can use in a workspace. Using these metrics, you can view who is using your reports, how they are using the report, what actions are…
Performance Analyzer is a tool within Power BI desktop, that allows you assess your report’s performance and identify area of improvement. Using this you can identify the time taken by each visual to query for…
Microsoft Power BI allows us to connect with multiple data sources such as SQL Server, Excel, Text/Csv, XML, Pdf, and JSON and many more, here we will focus on how to import JSON data file…
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data basically a data that is not in the cloud and several Microsoft cloud services. There are two…
Microsoft Power BI allows you to create a calculated columns means you can add a new column to an existing table in your data model, and instead of querying and loading values for new column…
When you perform sorting on months name, you will see that months name are sorted alphabetically as text, strings are sorted alphabetically by default. While you expect to see months name to be sorted chronologically….
In Power BI service a workspaces are places to collaborate with colleagues to create collections of dashboards, reports, datasets, and paginated reports. You can add users who can access, edit, and read the content in…
Power BI allows you to rename a datasets in Power BI service. You can rename the dataset in workspace, if you are either a report author or creator of workspace. First login to Power BI…
Recently Power BI has released November 2020 update, in this update one of the coolest feature is that now you can add a zoom sliders to cartesian charts (chart which includes horizontal and vertical axes)…
Sometime you are required to create a relationship between tables when both tables are having a duplicate values. In this case, If you try to create a relationship, Power BI suggest a many to many…
In Power BI there are two DAX functions that you can use to generate a date series that is CALENDAR and CALENDARAUTO. The CALENDAR function requires two input parameters that is start date, and end…
What if Parameter gives you the ability to transform data dynamically. Using this you can easily evaluate you data behaviour under different conditions dynamically. Lets say for below given Sales data table, you want to…
Changing the Data Source dynamically in Power Bi using Parameters Parameters in Power BI , basically is used for changing the argument values for particular transforms and data source functions and inputs in custom functions….
Introduction to Parameters in Power BI Desktop Parameters in Power BI provides the flexibility to change the output of queries depending on their value dynamically. Parameters basically is used for changing the argument values for…
Show and Hide Measures in Line chart visuals based using slicer If you are working on Line and clustered column chart, or line and stacked column chart and using measure to display values in chart…