Explore >> Select a destination


You are here

azurecloudai.blog
| | blog.gbrueckl.at
0.8 parsecs away

Travel
| | [AI summary] The article explains how to calculate ISO 8601 week numbers and years in DAX and Power Query for data modeling.
| | martinschoombee.com
0.7 parsecs away

Travel
| | Unless your source data contains no dates at all, every Power BI model should have a Date entity. Chances are good that you've ignored a built-in option in Power BI Desktop that's enabled by default (image below). While the "Auto Date/Time" option isn't the worst thing you could do in Power BI Desktop (i.e. the...
| | blog.crossjoin.co.uk
3.7 parsecs away

Travel
| | In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I'll show you a different trick that - when you can use it - can give you an equally significant performance boost. When you merge...
| | sqlstudies.com
15.0 parsecs away

Travel
| Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a user (database level principal) on each database and granting it the correct permission. And making sure to grant those permissions to the model database so that future databases have the correct permission as they are...