Connecting Power BI to two different FE NXT databases

@Jim Powers
you said

I can't figure out how to retrieve the data from PFS_DB2. Has anyone had success connecting to two FE NXT databases in different Environments?

I assume this means you already got PFS_DB1 having data of environment 1 and PFS_DB2 having data of environment 2.

retrieving data from these database just means connection setting to these database separately. when you setup azure sql server connection in POwer BI, it ask you which database to connect to

@Jim Powers
there is a few prep work you need to do (double of what you did for the first database).

You need to create a 2nd Application in your developer account, then go to marketing place and connect the 2nd application to your 2nd environment.

Once you do that, you will need to create a new connection in flow. So you can “copy” the flow that you have already that is pulling data from your first environment, then on the “send http” action, change the connection to “new” and it will let you sign in and select another environment.

as for the azure sql database, it depends on how you config, if you config a separate database and use same table name, then on the sql action, selet a new connection and sign in and select a different database. if you use same database, but use different table name that indicate which fe database, then you don't need a new connection, just need to change the table name in the SQL insert.