Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Olá.
Veja se alguem pode me ajudar.
Eu tenho um servidor sql que possui dois bancos de dados CLIENTE_A e CLIENTE_B.
Agora os dois clientes estão querendo alguns relatorios no powerbi, minha pergunta é:
Eu consigo no mesmo servidor eu ter um Gateway para dois clientes ?
O mesmo Gateway atualizar informações do CLIENTE_A e do CLIENTE_B
Mas cada cliente só ira conseguir ver os dados dele, exemplo o CLIENTE_A só ve os dados do CLIENTE_A e o CLIENTE_B só ve os dados do CLIENTE_B
Obrigado a todos
Hi @fabiocoelho,
See if anyone can help me.
I have a sql server that has two databases CLIENT_A and CLIENT_B.
Now the two clients are wanting some reports on powerbi, my question is:
Can I get on the same server I have a Gateway for two clients?
The same Gateway update information from CLIENT_A and CLIENT_B
But each client will only be able to see the data of him, for example the CLIENT_A only sees the data of the CLIENT_A and the CLIENT_B only sees the data of the CLIENT_B
Can I get on the same server I have a Gateway for two clients?
You have installed a Gateway on a server, and want to use this single Gateway to update data for two clients' reports, right? Yes, it is possible.
But each client will only be able to see the data of him, for example the CLIENT_A only sees the data of the CLIENT_A and the CLIENT_B only sees the data of the CLIENT_B
If you create two separate reports for ClientA and ClientB, you just need to load data from each corresponding database, instead of loading all data. If you combined data from two databases, and two clients would see the same report, then, you should apply RLS to restrict data access for them.
Best regards,
Yuliana Gu
Can I get on the same server I have a Gateway for two clients?
You have installed a Gateway on a server, and want to use this single Gateway to update data for two clients' reports, right? Yes, it is possible.
Exactly what I need to do, but how can I do this?