Explore >> Select a destination
|
You are here 
|
eriksvensen.wordpress.com | ||
| | | | |
datasavvy.me
|
|
| | | | | I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks Unity Catalog. I didn't have access to add more fields to the view, so I was adding the fields in Power Query first, with plans to... | |
| | | | |
querypower.com
|
|
| | | | | Regardless of your requirements, providing someuser contextduring slicing of data ora filtering mechanismfor data querying, having a function like USERNAME() in Power Query toolbox can greatly simplify your data mashup scripts. While trying to build a more robust approach forself referencingqueries in M, I've managed to collect four methods for getting the current username in... | |
| | | | |
blog.crossjoin.co.uk
|
|
| | | | | In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn't give you any examples of why this might be useful. In this post I'll show you how you can use a Profiler trace to visualise all the queries run by a Power BI... | |
| | | | |
blobeater.blog
|
|
| | | Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory for your SQL Server. You can clearly see that if you enter a silly figure such as 50 MB, the minimum memory amount allowable for max server memory is 128 MB. You will see SSMS... | ||
