Cleaning Your #PowerBI Power Query Code
Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve...
2015-08-10
597 reads
SQL with Dustin Ryan
Twitter Analysis with #PowerBI & Plus One
Earlier this week Christopher Finlan put together this awesome Datazen dashboard using Plus One. Christopher has been doing a lot...
2015-08-07
696 reads
#PowerBI and #SSAS Tabular: A Natural Fit with the Power BI SSAS Connector
In late June last month, the Microsoft Power BI team released the Microsoft Power BI Analysis Services Connector. The Power...
2015-08-07
1,085 reads
Importing Excel Power View Dashboards into Power BI
If your organization is now a Power BI customer, congratulations. You’re now ready to create some very cool dashboards, integrate...
2015-08-04
1,092 reads
#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer
Power BI Desktop has been out for GA for over a week now and some of the pro’s out there...
2015-08-03
1,585 reads
#PowerBI Fantasy Football Player Stats Dashboards for Download
Every year at Pragmatic Works some coworkers, including consultants, marketing staff, support team members, software development staff and project management,...
2015-08-01
1,547 reads
Three Best Practices for #PowerBI
Since the release of Power BI Desktop this past week, I’ve been really spending my extra time digging into the...
2015-07-31
1,230 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
combining a param value with widcards in a foreach loop files property
Hi, it isnt clear from the web if something like this should work as...
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers