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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors