March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi, I'm quite experienced PBI user and proficient in DAX but with networking sometimes I struggle. I've already used PBI Gateway in the past and everything worked fine but I have a tricky config that I want to understand if it's solvable.
Context
I work in Company A.
The client is in Company B and currently uses PBI for their own reporting
The client has its own PBI Gateway, sitting within their B network.
I want to develop a report on *their* tenant (see note *1)
However the data is provided by me and it's a Mysql (amazon RDS) sitting within my network A. Or, better saying it's in a network behind a firewall.
So this is the way I'm thinking it should work:
The way I think it should work:
- the gateway sitting on client network has a private IP but also a PUBLIC ip of x.y.z.w (the IP that it's using to exit from the network)
- if i know this IP I can configure the firewall on my AWS cloud to allow connections from this IP only
Questions
1) Am I correct? Will it work?
2) Which ports should I open? The standard mysql ports?
3) What about authentication? It shouldn't be a problem of domains since mysql will have a standard mysql auth and the gateway will use this same mysql auth even if it's sitting on "B" domain, correct?
Thanks
*1 = the reason why I'm not developing in my tenant and share the dashboard with the client is that unfortunately guest users (i.e. users whose the db is shared to, "b" domain users) cannot use Analyze in Excel feature
(btw I'm NOT a "new user", I use to actually being one of the most active team of helpers in the DAX community, I had call with microsoft team ahahah the forum has changed and I got reset, seem so 🙂 )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
22 | |
21 | |
10 | |
10 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |