SQLBI Newsletter #190

NEW ARTICLE

Show previous 6 months of data from single slicer selection

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months.
Read more

NEW ARTICLE

Development tools for Tabular models in 2021

The development of enterprise-level models for Power BI Premium and Analysis Services requires both the Microsoft tools and a set of third-party tools – most of them open-source – to get the job done.

This article is the state-of-the-art guide to the development tools for Power BI and Analysis Services models. It provides guidance to improve your productivity and access to new features.
Read more

#190 · May 2021

LEARNING

Course calendar

video courses

SQLBI YOUTUBE CHANNEL

Latest news

	• Microsoft Business Application Summit recap Microsoft made a large number of Power BI announcements at the Business Application Summit. While automatic aggregations and hybrid tables (mixing DirectQuery and Import mode partitions) are the most interesting upcoming features for us, you have to read the complete list and watch the related videos to get the full picture of what is going to happen in the next few months. May 5, 2021 · Microsoft
	• Introducing Goals in Power BI One of the features immediately available in preview is the Goals. This feature is for Premium only, but it is an interesting approach to creating scorecards and KPIs that can be updated manually or automatically by getting data from existing Power BI reports. The automatic snapshot to create a history of the data available in a regular dataset is an intriguing feature we will farther look into. May 4, 2021 · Microsoft
	• Announcing support for backup and restore of Power BI datasets You can now back up and restore databases in Power BI Premium using the XMLA endpoint. It is thus easier to migrate models and data from Azure Analysis Services to Power BI. May 6, 2021 · Microsoft
	• Power BI connected PivotTables in Excel for the web You can publish your Excel file with a PivotTable connected to a Power BI dataset and the online version can be navigated as if you were using the local version of Excel. In other words, you can "publish" your Excel report including live PivotTables connected to Power BI. We had been waiting for this feature for too many years! May 4, 2021 · Microsoft
	• On-premises data gateway April 2021 update This is not only your regular reminder to update your data gateway. This version introduces a feature to test the single sign-on (SSO) configuration, saving you time trying troubleshooting permission issues before going in production. Apr 27, 2021 · Microsoft
	• DAX Studio crowdfunding Almost 9 years ago, the first beta release of DAX Studio was made available for free. It is time to give back and support Darren Gosbell in continuing the development of new features! If you find DAX Studio useful you can make a one-time donation, or a monthly donation. SQLBI is proud to be the first Gold Sponsor. Your company could be a sponsor too! We look forward to an exciting 3.0 release later this year. May 1, 2021 · GitHub

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.