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 Steve Jones
I used Claude to build an application that loaded data for me. However, there...
By Bert Wagner
I almost ordered parts for a circuit that would have destroyed itself the instant...
By Brian Kelley
Following the advice in Smart Brevity improves communication.
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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...
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