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 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

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

Hii 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.