top of page

Power BI Update: June 2023

Writer: Lachlan McLeodLachlan McLeod

The latest Power BI update introduces game-changing features that enhance data visualization, data discovery, and development capabilities. With the new card visual, users can create stunning, customizable cards with advanced formatting options and interactivity features. The OneLake data hub serves as a centralized hub for data reuse and empowers users to explore various data sources effortlessly. Power BI Desktop Developer Mode revolutionizes collaboration and automation, allowing developers to seamlessly integrate with Git repositories and streamline their BI solutions. Don't miss out on these exciting updates, and dive into the full June 2023 Power BI update for a transformative data experience.

 

New card visual (Preview)

In the latest update, a new card visual has been introduced. Users can find it in the core visual gallery or access it as a preview feature under Options > Preview features > New card visual. By dragging and dropping fields or measures into the 'Data' field well, multiple cards can be displayed.

Used with permission from Microsoft.

The new card visual brings exciting surprises. Users can customize the shape of corners to achieve their desired style and enjoy refined formatting settings for values and labels. There is expanded support for conditional formatting and the introduction of font transparency. Users can also customize display units with precision control through the new custom option. Even when there is no data available, the 'Show blank as' feature ensures that cards display the proper content.


There are three layout options to choose from (Horizontal, vertical, and grid), allowing users to fine-tune their cards by adjusting padding, spacing, and text alignment. Additionally, users can enhance their designs with images and an accent bar. The card visual also offers interactivity features such as tooltips and drill-through, making data more engaging. With the 'Themes' feature, users can personalize their default styles by controlling all formatting settings.


It's important to note that this is just the beginning of the new card visual. In the upcoming months, more capabilities and features will be added to further improve the experience. Users are encouraged to stay tuned for exciting updates and can learn more about the new card visual by reading the dedicated blog post from Microsoft.

 

OneLake data hub in Power BI Desktop

The data hub in Power BI Desktop has been rebranded as the "OneLake data hub." It serves as a central location where users can discover and reuse data. With the recent Fabric release, users can now access the OneLake data hub.


The OneLake data hub allows users to reuse existing Fabric items and create their own datasets and reports. It supports various items such as data warehouses, lakehouses, their related SQL endpoints, datamarts, and datasets (with KQL databases coming later this year).


When working with lakehouses, SQL endpoints, datamarts, and warehouses, users have two options to retrieve data. They can either connect to the auto-generated dataset or connect directly to the SQL endpoint to create their own dataset. The OneLake data hub in Power BI Desktop acts as a gateway to the Fabric data ecosystem.

Used with permission from Microsoft.

Overall, the OneLake data hub in Power BI Desktop simplifies data discovery and reuse, empowering users to create insightful reports based on the available data sources.

 

Power BI Desktop Developer mode (Preview)

Power BI Desktop Developer Mode is now available in public preview, bringing advanced developer features to Power BI Desktop. This mode enables enterprise-scale collaboration and automation of deployments, making it easier to create and manage BI solutions for large organizations.


In Power BI Desktop, you can now save your work as a Power BI Project (PBIP). This saves report and dataset definitions as individual plain text files in a user-friendly folder structure, making it easier to organize and collaborate on projects.

Used with permission with Microsoft.

As a developer, you can take advantage of this integration in several ways. You can use Power BI Desktop to author report and dataset metadata files in source-control-friendly formats, enabling collaboration and version control. This allows for continuous integration and delivery workflows, ensuring quality control before deploying to production environments. With the combination of Power BI Desktop Developer Mode, Fabric Git Integration, and Azure DevOps, developers can seamlessly sync their Power BI workspaces with Git repositories, ensuring consistency and facilitating CI/CD workflows.

Used with permission from Microsoft.

By utilizing Git as the centralized repository, developers establish it as the "source of truth" for their developments. This integration allows for smooth transitions between Power BI Desktop and the Power BI Service, with every modification securely backed up and versioned by Git.


To access Power BI Desktop Developer Mode, go to File > Options and settings > Options > Preview features and enable the "Power BI Project (.pbip) save option." For more information and a demonstration, see Microsoft's documentation.

Used with permission from Microsoft.
 

For the rest of the Power BI June 2023 update, click here, or if you would like to discuss Power BI for your business, email info@pt20.com.au or give us a call on +61 746 596 700.


Comments


bottom of page