Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Brysonds
Helper III
Helper III

Desktop API / RLS Question

Hi Everyone,

 

I am compariing Power BI to Qlik Sense and wanted to get clarification on if a Power BI capability exists. 

 

Neither Power BI nor Qlik Sense support Row-Level Security within the Desktop Client.

 

However, sometimes there still exists a need to provide a stripped down version of a PBIX file for Desktop use (i.e. a sales person who should only see their expenses is traveling and wants to view the data offline). This can easily be achieved by filtering the underlying data beforehand, thus the PBI desktop file only contains their data - problem solved. However, this is a lot of overhead of we go from 1 person to 100 people. 

 

Qlik's approach to managing this issue is to use an API engine that will automatically generate copies of the desktop file that are filtered on a named dimension (like employee), thus automating the process of what I mentioned int the previous paragraph. 

 

I was just curious if there is a 3rd party tool that exists to do this for Power BI.

 

I know that Power BI supports offline capability through a mobile device, but it isn't realistiv to analyze some data on a mobile device, and not everyone has a larger tablet.

 

Thanks!

2 REPLIES 2
Anonymous
Not applicable

Hi @Brysonds,

 

I haven't heard any APIs who can directly operate power bi desktop data model.

 

AFAIK, power bi data model is stored in AS instance, maybe you can refer to use following link to know how connect to power bi data model and export data.

Connect to Power bi data model instance

 

Regards,

Xiaoxin Sheng

Thank you for the information! I will look into this to see if this can be leveraged as a solution.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.