Forum Discussion
How to create a connection to a database with integrated credentials and then use it in PBI Desktop?
Hi Fern_21,
Users can ONLY access the tables you include in the Dataflow.
When users connect to your Dataflow in Power BI Desktop, they can:
Import only the entities (tables) inside the Dataflow
Build their own model on top of those tables
Combine with other local files (Excel, CSV, etc.) if they want
Hii Fern_21
Desktop always connects to a database using the credentials of the person who is running Desktop, and it will always ask them to authenticate.
If you want users to connect without entering credentials, this is only possible in Power BI Service using a Gateway + SSO (Kerberos/Entra ID).
There is no method or workaround to pass integrated credentials automatically into Power BI Desktop.
Hi rohit1991 !
On power bi service how can the user develop a report? I really need the power bi desktop to create a report from Azure MySQLHii Fern_21
In Power BI Service, a user can only build a report from an already-published dataset.
They can go to Get Data >> select the existing dataset >> Create report and design it in the browser.But connecting to a new database, creating a new data model, or using Import/DirectQuery is only possible in Power BI Desktop.
Power BI Service cannot create new connections so Desktop is still required.
