Improvements to In-Memory technologies continue to increase performance gains, while the introduction of new historical tables that automatically capture changes and security features to protect data in motion. Management of non-SQL Server data sources. New data engine technology addresses the…
Export Power BI report to PowerPoint
The new Export Power BI report to PowerPoint now allows you to export the entire Power BI report to a PowerPoint file. No more cropping Power BI screenshots to include in a PowerPoint presentation! With export, you’ll get the following,…
Best practices for Power BI performance
Here is some basic guidance for getting the best performance possible out of Power BI reports and dashboards. Understand your architecture Your first step is to understand the architecture of the reports and dashboards you create. What you need to do…
Axes
If we have only one axis it must be the columns axis and we must define a set.The WHERE clause is optional and is used to complete the tuple. If we have two axes, we separate them with a comma.…
What is MDX?
MDX stands for Multi-Dimensional eXpression language. There are two ways that we work with this language. First, we can use it to create expressions. These expressions allow us to store business logic in a cube and thereby ensure that everyone…