Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
amaleranda
Post Patron
Post Patron

One 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.

1 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

 

 

View solution in original post

5 REPLIES 5
amitchandak
Super User
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

@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)

Hi , @amaleranda 

Not very clear.

Are you referring to parameterized data sources ?

 

31.png

33.png

 

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

 

 

 

 

@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 

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

 

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.