cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

OneDrive credentials stored in PBIX file?

Hi all,

 

I have an excel report on OneDrive for Business, I used the Web data source and pointed it directly to the Excel file on One Drive in the cloud. I authored the report, uploaded to service, everything works great.

 

A question - If I send this .pbix file to a colleague, it appears it stores my one drive credentials within it, therfore they can see all of the data in my copy of the Excel report. I'd like to be able to send it and force them to update the data source settings, so they can provide their own URL / One Drive credentails to THEIR version of the report. Assuming we have the same column headings and such, it should re-map the visuals. Any ideas on how to do this? Assuming we have different versions of the same Excel report with different data or security applied within the Excel report itself. 

 

I know that by creating a content pack, it will store my data source credentails, which means my only option is to use RLS at that point. Was hoping to re-map data source settings as a workaround. All thoughts and input warmly appreciated!

 

Mark

1 ACCEPTED SOLUTION
Memorable Member
Memorable Member

1 REPLY 1
Memorable Member
Memorable Member

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors