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!
Solved! Go to Solution.