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,287 reads
Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this...
2016-10-06
3,287 reads
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product...
2016-07-24
794 reads
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
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
640 reads
Over the past couple of weeks I have been asked several times about the KPI Visual that is native to...
2016-07-06
1,987 reads
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,324 reads
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
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,118 reads
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,793 reads
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...
2016-02-19
1,215 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers