Forum Discussion

Fern_21's avatar
Fern_21
Icon for Helper V rankHelper V
9 months ago
Solved

How to create a connection to a database with integrated credentials and then use it in PBI Desktop?

Hi all! On Power BI, is it possible to create a connection to a database that already includes credentials, so that a user in Power BI Desktop can directly use that connection without needing to p...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    9 months ago

    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

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
9 months ago

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.

Fern_21's avatar
Fern_21
Icon for Helper V rankHelper V
9 months ago

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 MySQL