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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
smullan
Frequent Visitor

analyse in excel

Hi,

 

I created a number of reports in Power BI with visuals and tables which I need to share with specific people but they cannot have access to the underlying data.

 

I understand I cannot share a Power BI visual / dashboard with people without them being able to access the underlying data.

 

If I select "analyse in excel" and recreate similar tables and visuals, can I share this with individuals so that they can refresh the excel file without having access to the underlying data in Power BI?

 

If not, I am wondering what the best way to share this data might be? Any suggestions would be greatly appreciated!

 

Thank you

1 REPLY 1
augustindelaf
Impactful Individual
Impactful Individual

Hi @smullan

 

I don't think the Analyze in Excel can be used as a way to set up data refresh.

If you provide with your colleagues the "Analyze in Excel" feature, they will just be able to see the PBI data model in an Excel spreadsheet.

I think there is no more option with it.

 

Best Regards,

Augustin

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors