This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Welcome to the February 2025 update!
Welcome to our latest blog post, where we are thrilled to introduce some game-changing features for Power BI that will significantly enhance your data analysis experience. First up is the improved modeling performance for live editing of semantic models in Direct Lake mode within Power BI Desktop. This results in at least a 50% improvement in each modeling change.Additionally, we are excited to unveil the fully interactive Explore feature for Copilot visual answers. Available for both read and edit modes of a report, Explore allows you to filter, sort, or swap field and change visual types easily for ad-hoc exploration. To top it all off, the OneLake catalog is now seamlessly integrated into the Power BI app experience within Microsoft Teams, facilitating effortless collaboration and data sharing among your team members. These enhancements are all about empowering you to work smarter and more collaboratively, transforming the way you handle data in your organization. Let’s dive deeper into each of these features and explore how they can elevate your Power BI experience!
LIVE NOW! The first-ever Power BI DataViz World Championships!
Data enthusiasts from around the world are battling it out and flexing their Power BI skills like true data wizards! The top four winners will earn their spot in the Grand Finale at the MGM in Las Vegas —LIVE at the Fabric Community Conference aka FabCon!Think you have what it takes? There are three more chances for you to show off your skills, connect with an amazing community, and win epic prizes! Don’t miss out on this legendary event!
Join us at FabCon for the ultimate Power BI learning event
Power BI takes center stage at FabCon from March 31 to April 2, 2025. With the inaugural Power BI DataViz World Championship, 24 Breakouts, 5 pre- and post-conference workshops, plus the famous Power Hour, we have an exciting schedule for every Power BI enthusiast!Announcing exclusive pricing for Power BI users! Use code FABINSIDER to save $400 and reserve your spot. Limited tickets available. Valid for new registrations only. Cannot be combined with other offers.
A_yellow_sign_with_black_text_Description_automatically_generated
Version number: v:2.140.1078.0
Date published: 2/20/25
Contents
Getting started with Copilot on your mobile app is easy, simply tap the Copilot button located in the report header (for reports that meet Copilot requirements in Power BI). From there, you can choose whether to receive a summary or uncover insights. Copilot will deliver a response based on your request, which you can then copy, share, or continue interacting with. Suggestions at the bottom of the screen help you refine your request or create new ones, making it simple to explore your data further.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
When receiving a visual answer from Copilot, expand this new section to dig into what data (fields/measures) and filters were used to generate the answer. You can also click on the field to see more information like the aggregation or home table.
This is especially helpful when there could be multiple fields with the same name, like having multiple Dates in your data, verifying Copilot picked the correct one.
A_screenshot_of_a_chat_AI-generated_content_may_be_incorrect
As a reminder, Copilot does not currently incorporate existing filters from the report when generating a visual answer. This list only contains filters that were used at the time of generating the answer.
This is a step towards increasing transparency in how Copilot understands and generates responses. If you have any additional suggestions, please share your thoughts in the comments.
https://youtu.be/2uQ2MTy9a1k
With Explore, quick actions are now possible from Copilot. Simply open the Explore experience to filter, sort, swap fields, or change visual types easily for ad-hoc exploration.
A_screenshot_of_a_chat_AI-generated_content_may_be_incorrect
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect You can choose to save the new explore visual to a report or an exploration to come back to.
Note: Saving the new visual to the original report is not yet available.
Explore does have certain limitations, some users may still see the ‘expand view’ button if requirements to use Explore are not met.
Once you open the conditional formatting dialog you will notice there is a new section that shows the data that’s on your visual. This section includes any column, measure and visual calculations on your visual and will include any hidden fields as well.
For example, here I have a simple visual that shows sales by quarter using a Total Sales measure and the Fiscal Quarter column. I have added a visual calculation that for each quarter calculates the difference with the first quarter:
VSFirst = [Total Sales] - FIRST( [Total Sales] )
Screenshot_of_Power_BI_Desktop_showing_the_Background_Color_conditional_formatti
All your model data is still accessible, it is in the 'All data' section.
Next, select VSFirst visual calculation and set up the rule as usual:
Screenshot_of_the_conditional_formatting_dialog_for_background_color_for_Fiscal
And the conditional formatting is applied:
Screenshot_of_a_Power_BI_table_with_the_gradient_conditional_formatting_rule_app
As mentioned, you can also format the visual calculations themselves, as done here with the same visual calculation that was made visible to show the result:
Screenshot_of_Power_BI_Desktop_showing_the_conditional_formatting_dialog_for_the
Learn more about visual calculations in our documentation and please let us know what you think!
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
From there, you can use the embedded report as you normally would, now with your maps showing.
A_screenshot_of_a_map_AI-generated_content_may_be_incorrect
This update is in the process of rolling out, so you should see the change within the next couple of weeks.
We have significantly enhanced the modeling performance for live editing of Direct Lake semantic models using Power BI Desktop. Upgrading to the latest version will result in at least a 50% improvement in each modeling change.
More details on the feature, including requirements, considerations, and limitations can be found in the documentation. We highly value your feedback on this feature and encourage you to share it through our feedback form or the Power BI Community.
Main features:
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Key features:
Sales Analysis, Performance Evaluation, Risk Assessment.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Key features:
Visit the accoTOOL website for more.
A_screenshot_of_a_computer_Description_automatically_generated
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
Previously, clicking on an activity name in the Monitoring Hub directed you to the semantic model detail page. This month, we’re introducing the Semantic model refresh detail page. This new page shows comprehensive details of a selected refresh activity, including capacity, gateway, start and end times, error details, and multiple refresh attempts.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect For each refresh attempt, you can view the execution metrics by clicking on the 'Show' link in the 'Execution details' column. This information can assist with troubleshooting or optimizing the semantic model refresh. Previously, this data was accessible through Log Analytics or Fabric Workspace Monitoring.
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
It's also possible to link refresh details from external applications. The semantic model refresh detail page can be accessed from other locations by constructing a URL with the workspace, semantic model, and refresh ID:
https://app.powerbi.com/groups/{workspaceId}/datasets/{semanticModelId}/refreshdetails/{refreshId}
For instance, this Fabric Notebook uses semantic link sempy and Power BI API Get Refresh History to create a refresh detail URL for each run of a semantic model:
import sempy
import sempy.fabric as fabric
import pandas as pd
workspaceId = "[Your Workspace Id]"
semanticModelId = "[Your semantic model Id]"
client = fabric.FabricRestClient()
response = client.get(f"/v1.0/myorg/groups/{workspaceId}/datasets/{semanticModelId}/refreshes")
refreshHistory = pd.json_normalize(response.json()['value'])
refreshHistory["refreshLink"] = refreshHistory.apply(lambda x:f"https://msit.powerbi.com/groups/{workspaceId}/datasets/{semanticModelId}/refreshdetails/{x['requestId']}", axis=1)
displayHTML(refreshHistory[["requestId", "refreshLink"]].to_html(render_links=True, escape=False))
A_screenshot_of_a_computer_AI-generated_content_may_be_incorrect
More details on the feature can be found in the data refresh data refresh documentation.
That’s all for this month!
We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store, please leave us a review.As always, keep voting on Ideas to help us determine what to build next. We are looking forward to hearing from you!
A_yellow_sign_with_black_text_Description_automatically_generated
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.