Forum Discussion
Post PatronOne pibx file for multiple clients
Hi Gurus,
I have a difficiult requst (for me anyway). I have three difffernt clients, each clients has multiple diffrent entities under them as below
CLIENT NAME ENTITY NAME API LINK
Client A GNT www.clintaapilink/clienta/gnt/podetails.com
Client A BTC www.clintaapilink/clienta/btc/podetails.com
Client B STK www.clintbapilink/clientb/stk/podetails.com
Client B PSK www.clintbapilink/clientb/psk/podetails.com
Client B TSG www.clintbapilink/clientb/tsg/podetails.com
Client C RTK www.clintcapilink/clientc/rtk/podetails.com
Client C YUT www.clintcapilink/clientc/yut/podetails.com
all the client detials are stored in difrent APIs as above, what I want to achieve is create a one pbix file for me and send it to diffrent clients (ClientA, ClientB and so on), ther are only two parts of the API changes from client to client.
What I want to creat is a one pbix file that can send to clients, they enter theri API as a parameter then there related entity load into there pbix file. For instance if I am client A i will enter "clintaapilink" as a parameter and then entity gnt and btc load into the pbix file.
If I am client B I willl enter "clintbapilink" as the parameter before the model loads, entity stk, psk and tsg only.
is there any way I can acheve what I want. hope my requirment is clear enough.
Hi, amaleranda
I am afraid that currently powerbi does not support this function, even if you store your data source address with parameters, you can only switch parameters in the datasource setting.
I would suggest you add it as an idea on Power BI Ideas forum. If there are enough votes, the Product Team will evaluate and take good consideration about it.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Community Support Team _ Eason
5 Replies
- amitchandak
Super User
amaleranda , We have RLS , but that will work in power BI service. You can test on desktop. The other thing I can think of is the source parameter.
Refer if this can help you to achieve that
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
amalerandaYes, RSL can work for each client for filter diffrent entities, but it is not going to work for diffrent clients as my idea is to create one single PBIX file (PowerBI gold dataset) and sent that out to diffrent client, purpose is the manage change easily, I can have multiple pbix files for each client but change management would not be that easy. What I am trying to achieve is one data model (pbix file for differnt clients)
- v-easonf-msft
Community Support
Hi , amaleranda
Not very clear.
Are you referring to parameterized data sources ?
If it is ,please check if the following posts help.
https://data-marc.com/2018/11/15/parameterize-your-data-source/
Best Regards,
Community Support Team _ Eason
