|
You are here |
azurecloudai.blog | ||
| | | | |
blog.gbrueckl.at
|
|
| | | | | [AI summary] The article explains how to calculate ISO 8601 week numbers and years in DAX and Power Query for data modeling. | |
| | | | |
martinschoombee.com
|
|
| | | | | 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
|
|
| | | | | 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
|
|
| | | 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... | ||