One pibx file for multiple clients

[amaleranda]

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.

[amitchandak]

@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

[amaleranda]

@amitchandak ,

Yes, 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]

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/

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-b...

Best Regards,
Community Support Team _ Eason

[amaleranda]

@v-easonf-msft ,

Thanks for the reply, 

what I need is to create a one pbix file for all the clients. Then send it to each individual clients( Client A, Client B and Client C).

They enter their related server name.

Client A enters "clienta" in the parameter. then all related enties download into his model (GNT and BTC) dynamically, 

Client B enters "clientb" in the parameter. then all related enties download into his model (STK, PST and TSG) dynamically,

Client C enters "clientc" in the parameter. then all related enties download into his model (RTK and YUT) dynamically

by daynamically I mean Client A only enters "clienta" part as a parameter and rest of the entities load automatically to the model (only client A ones)

Hope this explains what I want to achieve.

Thanks for your reply 

[v-easonf-msft · Accepted solution]

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