Forum Discussion

kenthub's avatar
kenthub
Icon for Helper I rankHelper I
9 years ago

one file with multiple companies

I have a good brain scratcher for you all and I'll do my best to explain it since I'm not the IT person. I am asking however so it will be easier to approach him when I come to him with this question...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi kenthub,

Do you connect to these files in Power BI Desktop and want to make a Power BI template for other users to instantiate reports based on their files? If that is the case, create a data source parameter in your current Power BI Desktop file, then create a Power BI Report template. For more details about Power BI template, please review the following blog and similar thread.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-create-a-template-with-a-different-data-source-every-time/td-p/50969


Thanks,
Lydia Zhang

kenthub's avatar
kenthub
Icon for Helper I rankHelper I
9 years ago

Thanks Anonymous for the reminder on the Parameters. I read that article a few months ago and forgot about it!

 

The problem I will run into with this however is a security issue. I do not want one store to have access to another stores information. Do you believe there is a way to set administrative rights to those parameters so userX can only access parameterX and userY can only access parameterY?