Power BI Takeover–Webinar Recording and Q&A
Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm. Instead of our traditional 1...
2016-05-19 (first published: 2016-05-10)
2,348 reads
Devin Knight
Temporary Post Used For Theme Detection (dff6a50a-5239-4df1-af43-b1e60d02dde4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (621301ab-a053-48fc-a7ec-01dc1d5fe152 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2015-12-15
810 reads
DirectQuery in Power BI Desktop
In the latest Power BI Desktop a new Preview features was released that now allows you to connect using DirectQuery...
2015-11-06
1,956 reads
Power BI Desktop: A Guide for Excel Users
Today Microsoft officially released the new development tool for Power BI called Power BI Desktop. First of all let me...
2015-07-24
5,310 reads
Excel Services in Power BI
**Information current as of 7/22/2015**
There’s lots of exciting news this week with Power BI so expect several short blog posts...
2015-07-27 (first published: 2015-07-22)
3,748 reads
Creating a Date Dimension with Power Query
A date dimension or table can be extremely important when working on a Power BI project, or BI projects in...
2015-06-16
5,659 reads
Creating a SQL 2016 CTP2 Virtual Machine in Azure
With the CTP2 of SQL Server 2016 now released you may be eager to try it out. One of the...
2015-05-28
2,471 reads
Power BI with Azure SQL Database
**Information is current as of 5/21/2015**
Recently Azure SQL Database was added as a new connection to the Power BI Preview....
2015-06-01 (first published: 2015-05-21)
2,822 reads
Power Query – Controlling M Query Functions with User Driven Parameters
Have you ever had a user run a query against one of your largest tables only for them to immediately...
2015-04-03
16,274 reads
Preparing a Technical Session Part 3: Writing an Abstract
So you’ve come up with a great idea for a session and now you have to translate that idea into...
2015-03-05 (first published: 2015-02-24)
5,530 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers