We are in the process of migrating an existing application on premise database to Azure and were intending to import existing SSRS reports as paginated reports in Power BI but have an issue connecting these to the database using a gateway. Our organisation security people have diasabled connections from Power BI service to Azure SQL databases which is why we will use a gateway.
We did a proof of concept using the on premise database and a gateway connection and this worked ok
i.e we imported the rdl file with the connection string set something like <ConnectString>Data Source=myonPrem\inst1.;Initial Catalog=db1</ConnectString> and were prompeted to select a gateway and this worked just fine.
However for the Azure SQL version:
We succesfully created a connection to the azure SQL instance in a gateway (on a vm running in Azure).
we imported the same rdl file as above but with the connection string: <ConnectString>Data Source=my-azure-db.database.windows.net.;Initial Catalog=my-db1</ConnectString>
After I import the file into my premium workspace I get prompted to enter credentials for a basic connection type when I was expecting to select the gateway that I wanted to use. Unfortunately because of our security the Power BI service will not have direct access to the database.
Can anyone help figuring out if this will work?
v-yetao1-msft
on:
Unable to create new dataflows Power BI GCC tenant
on:
BUG::SLICER::IDbConnection interface