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
589 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,075 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,090 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,584 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,511 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,226 reads
Blogs
SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!
They run, they return data. So what? Some SQL queries just waste your time...
Copilot Outside of SSMS Seems to Work
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
A New Word: Falesia
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
Forums
Problem with CASE statement
Hi Everyone I have used CASE many times but not sure what I am...
Question of the Day
Calculating Month End
I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?
See possible answers