Hey,
I work with few clients providing them with reports in PBI. For each client I created Big Query project where I store data and PBI workspace for reports. I use my credentials to pull data from BQ to PBI. My clients have viewer access to reports and use their own PBI Pro accounts to access it (as guest users).
However one of my clients wants contributor access so that he can also work on the PBI report. As I understand if I grant him such access after downloading pbix file he will also have access to other BQ projects of my clients (downloaded pbix will enable him to connect BQ using my credentials).
Is that correct? How can I limit his access to only his BQ project?
I tried to create separate gmail accounts (needed for BQ) for each client with limited BQ access but it seems that even if I change credentials in PBI Desktop once the project is uploaded my credentails are used. Moreover even changing credentials in PBI service to those associated with separate gmail accounts does not solve the problem (still my credentials are in use).
Any ideas would be more than welcomed.
Thanks!
