On February 15^th, 2020 the global community of Power Platform enthusiasts will be getting together across more than 40 cities to learn about the latest in Power Platform technologies. This FREE event includes content related to Power Apps, Power BI, Power Virtual Agents and Power Automate! Click in to learn more!

This article will show how to create a Calendar table with T-SQL, Power Query and DAX languages that are necessary to do correct data modeling.

The time Intelligence in Power BI makes it easy to calculate Year till date (YTD), Quarter till date (QTD) and Month till date (MTD) and to compare them to the same period last year and last period. How will this work in a Direct query environment?

Let us try to see the same in a Direct Query SQL Server Environment.

January 2020 Content Released by PowerBI.tips

This post is about a tool which converts a Power BI dataset to a Power BI Dataflow. I have analyzed the internals of PBIT files and Power BI Dataflow JSON files in depth and created a PowerShell script which converts any PBIT into Power BI Dataflow JSON.