Microsoft Power BI
Power BI is a set of business intelligence tools which allow you to analyse your data and share your insights. Modern business intelligence software seeks to ease the decision-making process for organisations, and with the help of a Microsoft Power BI consultant, this is where you can see the true value of your business’ data.
Not many people are aware of how to use Power BI, but XL Intelligence, being Power BI consultants and also Power BI training course providers, are always happy to lend a helping hand to your business intelligence needs. We are always fully clued into the monthly Power BI updates that are rolled across all components of the program. This month’s update is focuses on Power BI Report Server.
We understand how even getting to grips with continually-rolling Power BI updates can prove challenging, but from where we stand, we are proficient in all aspects of Power BI. We have developed numerous business intelligence solutions for clients using this software, many of which wouldn’t have been possible without such extensive, up-to-date knowledge and experience of the product. To share our knowledge, we’ve included a summary of the Power BI Report Server January update below.
Please familiarise yourself with the previous Power BI monthly updates below:
The January Power BI update includes enhancements in the following areas:
- Data preparation
Export data from a visual
Just like in Power BI Service, you can now export data from a visual in the January 2020 update. Both summarised or underlying data can be exported into various file formats, and this can be done simply by selecting “More options (…)” from the top right hand corner of the visual.
Custom URL additions
There is a new formatting option available; you can now set either a table column or a matrix value as a custom URL. This new conditional formatting option comes as an addition to the formatting pane in Power BI Report Server.
KPI visual formatting settings
There are new formatting options for the Power BI KPI visual. While the KPI visual itself is not a new feature itself, the formatting options are now not so limited.
The new KPI formatting options are as follows:
- Indicator text
- Distance text
- Goal and distance text formatting
- Adding date labels with formatting
- Trend axis transparency
Many of these options can be conditionally formatted.
Conditional formatting for buttons
You now have the option to set formatting options for button properties, including text, text font colour, icon line colour, outline and fill colours as well as button tooltip.
Load more for Analyze insights
The Analyze feature is used to find insights in your data, but Microsoft only run this feature for a limited period of time. Now, in the January 2020 Power BI update, you can continue to run the analysis in Report Server, even after the timeout has passed.
New Data Analysis Expression function
There is a new DAX function in Power BI which is called “Quarter”. This is quite simply explained; the function returns the quarter corresponding to a particular date.
Data profiling enhancements
There are some improvements to data profiling capabilities in the Power Query Editor, including:
- Multiple grouping options for the Column Profile pane
- Additional filter options
Other Power BI Updates
PBIDS file format
There is a new file format which is designed to help streamline the “Get Data” process for the people responsible for creating reports in Power BI, within a business. When opening a .PBIDS file, Power BI Desktop will open, as will an authentication prompt to connect the data source specified in the file. The user will subsequently need to select the tables to load into the model, as well as the databases, and then the user can begin building visualisations in Power BI, or view one from “Recent sources”.
Modelling operation improvements
The performance of the Analysis Services engine has now been significantly enhanced, particularly pertaining to modelling operations such as adding measures or calculated columns or creating relationships in Power BI.
Power BI Consulting Services
As experienced Microsoft Power BI consultants, we are multi-skilled experts in every aspect of the program. We work with Power BI daily for numerous clients that we provide Power BI consultancy services to, where we have successfully created solutions that have paid dividends in how they understand and derive insights from their data. We can do the same for you.
We believe in committing to regular, ongoing support if you require it. While some of our clients prefer to learn Power BI courtesy of our wide range of Microsoft training courses, we are happy to have a conversation with you about your business intelligence requirements and recommend the best course of action.