How to get Power BI RLS to work with external users
Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this...
2016-10-06
3,288 reads
SQLDownSouth
Happy Birthday Power BI
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product...
2016-07-24
795 reads
Join me at SQL Saturday 531, Louisville, KY
So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday...
2016-07-21
619 reads
Using Power BI to list Enterprise Only SQL Features
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
641 reads
What’s wrong with the Power BI KPI Visual?
Over the past couple of weeks I have been asked several times about the KPI Visual that is native to...
2016-07-06
1,988 reads
Higher Education Retention Analytics using Power BI
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This...
2016-06-06 (first published: 2016-06-01)
2,325 reads
SQL Saturday 486: Richmond, VA Precon
Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend...
2016-03-14
1,050 reads
Refreshing KPI Data in SSRS 2016
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to...
2016-03-01 (first published: 2016-02-23)
4,121 reads
More SQL Saturday Precon News(Real-time Dashboards)!!!!
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...
2016-02-19
1,216 reads
Creating KPIs in SQL Reporting Services
In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016. Let’s...
2016-02-22 (first published: 2016-02-17)
6,796 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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