Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Excel with RLS used as dataset in PBI is not working
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 88%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Carla Salles
1
Reputation point
Hi, I am facing a problem to connect an Excel file with RLS to Power BI.
I have restricted permission in the Excel file, so I can see only some data that is important for me and I would like to connect this file in a PBI app, but when use this file as a data source in PBI, the data appears as empty space.
Is it possible to have in PBI the same data that I open in the Excel file, using this Excel file as data source ?
My windows log in is the key to RLS in Excel file.
Thanks in advance
Microsoft 365 and Office | Excel | For business | Windows
Community Center | Not monitored
Community Center | Not monitored
Tag not monitored by Microsoft.
{count} votes
-
Ceasar Chen_MSFT 4,486 Reputation points2022-06-10T01:35:36.53+00:00 Hi,
Your question is related to Power BI, I am in charge of Office General, you can go and post hereWelcome to Microsoft Power BI Community .
Sign in to comment
Sign in to answer