A Fine Slice Of SQL Server
Zhenguo Zhang moves the legend somewhere else:
By default,
ggplot2places the legend outside the plot area (usually on the right). However, sometimes you may want to move the legend inside the plot to save space or improve the layout. This post explores how to achieve this usingtheme()parameters.
Click through to see what options are available.
Leave a CommentRuben Van de Voorde makes an announcement:
We are happy to launch the Limited Public Preview of the Tabular Editor CLI, a cross-platform command-line interface that gives humans, AI agents, and CI/CD pipelines headless access to Tabular Editor features. In practice, that means driving Tabular Editor by typing commands instead of clicking through the app. That may sound like extra work for a one-off edit, and it is. The payoff comes when the task repeats: a command is text, so you can save it, version it, and run it again later or unattended, while a click in a dialog does the job once and is gone. Whether you want to script bulk edits across dozens of models, let a coding agent work on your semantic model directly, or automate deployments in your build pipeline: the TE CLI is built for it, on Windows, macOS, and Linux.
This will be free until the end of September, after which point you’d need a Tabular Editor 3 license to continue using it.
Leave a CommentReitse Eskens hits the recycle bin:
Let’s be honest: how many times have you accidentally deleted something? Either on your laptop, in a database or in a SaaS product.
It happens. We’re all humans (unless you allow agents to do all your work for you), and mistakes happen.Until recently, when you deleted an item in Fabric, it was gone. Poof. Done. No grace period.
And that was a bit scary, to be honest, but now we have a new option to help us recover from oopsies!
The answer to Reitse’s question is “far too often for me to want to admit out loud.”
Leave a CommentMarc Lelijveld digs into Microsoft Fabric Data Agents:
What makes Fabric Data Agents particularly interesting is the wide range of supported data sources. Today, Data Agents can connect to nearly everything that lives inside Microsoft Fabric, or data that is linked into Fabric through shortcuts. Whether your data sits in a Lakehouse, Warehouse, KQL Database, Power BI semantic model, or even external storage connected through OneLake shortcuts.
However, the way Data Agents handle sources can differ significantly from one source type to another. Semantic Models in particular behave quite differently compared to other Fabric data sources. In this blog, I’ll dive deeper into how prompt handling works for Semantic Models, what happens behind the scenes, and the common gotchas you’re likely to encounter along the way.
Read on to see how semantic model behavior differs in particular from SQL or DAX queries.
Leave a CommentChris Webb continues to test out Fabric Dataflow Gen2 performance:
In the first part of this series I showed how the Concurrency setting in a Fabric Dataflows Gen2 can affect refresh performance when there are multiple queries inside the dataflow. In this post I will show how, with Partitioned Compute, this setting can also affect the performance of a single query within a dataflow.
To test this I created a dataflow with one query, a modified version of the query that I used in this post from earlier this year which returns a table with ten rows and calls a function with a built-in delay of 60 seconds on each row.
This is a preview feature but Chris shows a simple but effective test to demonstrate how this capability works.
Leave a CommentJustin Bird ran into some trouble:
Whilst I predominantly use MacOS, I do have to run a Windows VM for certain apps (cough Power BI cough). I ran into an issue recently when trying to installing apps on a vanilla Windows 10 build using Winget via the terminal in VS Code.
After installing the app, I found that the PATH environment variable was not updated, which meant I couldn’t run the app from the command line without specifying the full path.
Read on to learn what the issue was and how Justin was able to fix it.
Leave a Comment