/explore
|
You are here 
|
www.thebiccountant.com | ||
| | | | |
querypower.com
Yet another method of retrieving Power Queries from Power BI workbooks |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
devinknightsql.com
A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here's some of the quick benefits and reasons why you need a date table: Helpful when filtering data Filter by year, quarter, month, etc... Helpful for drilling into a hierarchy of... |
|
| | | | | ||
| | | | |
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... |
|
| | | |||
