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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mmacdonald
Regular Visitor

Analyze in Excel and Account Sign Out

Hello, I apologize if this question has already been asked, but I did not find this specific scenario anywhere.

 

If I log into my Power BI work account from my personal laptop, I can use the "Analyze in Excel" feature to create a pivot table or do other analysis in Excel.  That works perfectly.  What concerns me is that even after I sign out of my Power BI account, both on the Power BI site and in Excel directly, I'm still able to refresh and filter the data from my work dataset.

 

Is there a way to actually sign out of the data connection once the datasource has been set up?  The only way I could think of to do it was to delete the excel file altogether.  If this is the only way, then this seems like a pretty big security flaw, since it would be pretty common for someone to access their account from both within and outside the organization, for various reasons.  Think of a shared family computer or a conference room PC.  I understand that there are other things you could do to secure the Excel file itself, like use different windows logins on those PCs or password protect it, but it seems like the data connection in Excel should authenticate each time using the current signed-in account, or prompt you to sign in if you currently are not.

 

Thank you in advance, I am relatively new to the Power BI service, so hopefully I am missing something obvious.

2 REPLIES 2
v-gizhi-msft
Community Support
Community Support

Hi,

 

Hope this helps:

https://docs.microsoft.com/en-us/power-bi/service-datasets-certify 

 

Best Regards,

Giotto Zhi

I apologize if I'm being dense @v-gizhi-msft , but I fail to see how that link correlates to my question.  My question is about ongoing authentication when analyzing power bi datasets in Excel, not certifying them as accurate.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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