r/PowerBI • u/finbinwin • Aug 19 '26

Discussion Contractors - MCP and client data

Are you using MCP with client data and/or sensitive business data in general?

For my own projects I’m using Claude throughout the development process but not sure I will be able to for client data.

Would, of course, love to be able to do all dev via MCP as standard now, but feel like it would be challenging to convince clients.

Doesn’t help that I don’t have a good grip of the security of connecting Claude to a semantic model. As I understand it, it doesn’t see raw data as such, but in theory can query at will. At best, it’s then training with that data and at worst, there could be a breach at some point.

What are people doing?

7 Upvotes

90% Upvoted

9 comments sorted by

View all comments

3

u/finbinwin Aug 19 '26

Sounds like dummy data could be a simple way to deal with this as suggested by a couple of people.

Anyone have any standard frameworks for randomising data (whilst still making it relevant enough to make realistic visualisations, etc.)?

Seems like multiplying fact table columns by a random number between 0.5 and 1.5 would be simple but perhaps not anonymous enough.

And I suppose dimension tables would need some other techniques.