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

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

Hi grazitti_sapna !

What is the fastest and most functional solution? What are the pros and cons of each?
Thanks

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

Hi Fern_21, 

 

You can go for Dataflow,

 

Fast
Easy
Secure (no credentials exposed)
Cheapest
Lets users freely model their own semantic models

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

    Hi grazitti_sapna !

    With dataflows, can the user only have access to the tables I have loaded into the dataflows? Can't he put more? furthermore, on the tables they can do all the operations they want?

    • grazitti_sapna's avatar
      grazitti_sapna
      Icon for Super User rankSuper User
      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