-
Power BI Desktop July 2020 enables creating calculation groups using Tabular Editor. Discover what you can do with calculation groups and how Tabular Editor is integrated as an external tool in Power BI Desktop. You can see a step-by-step guide… Watch now
-
video
SQRT, POWER - DAX Guide
SQRT: Returns the square root of a number. https://dax.guide/sqrt/ POWER: Returns the result of a number raised to a power. https://dax.guide/power/ Watch now
-
Analyze in Excel for Power BI Desktop is an external tool for Power BI that opens a PivotTable in Excel connected to the database of a local Power BI Desktop instance. This is very useful during model development. Watch now
-
Explore how you can hide columns and tables to Power BI users by using the Object Level Security (OLS) feature released in February 2021. By hiding objects, you also hide derived calculations like measures, calculated columns, and calculated tables. The… Watch now
-
You created a wonderful Power BI report, but you wait too much time when you open it. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance? This session… Watch now
-
video
Budgeting with Power BI
Budgeting is one of the most challenging scenarios in the Power BI arena. For example, you might need to summarize sales in previous years and to allocate the budget forecasts. You must work with data at different granularities and find… Watch now
-
You can connect Excel to Power BI Desktop copying the connection string from Power BI Desktop. Useful to test your model for Excel consumption before publishing to Power BI service. Watch now
-
Overview of the techniques and the tools (free and commercial) available to optimize the performance of DAX expressions in Power BI models. You learn what you can do with Performance Analyzer included in Power BI, how to extract query plans… Watch now
-
How does Power BI consume memory? How do you read the right memory numbers? Learn how to use Task Manager and how to correctly interpret the numbers provided by the several processes used by Power BI when you open a… Watch now
-
Discover the features in the new composite models introduced in the December 2020 version of Power BI Desktop. You can connect to a Dataset published on powerbi.com (or to Azure Analysis Services) and add tables, columns, and relationships to an… Watch now
