Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI Report Builder - Query Designer

Hi, 

 

Any idea how I can enable my Report Designer to show the Database view so I can drag and drop variables, please?

This is the only view I can see.....

 

but I should apparently be able to see something like this.....

 

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, Anonymous ;

    Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi,, Anonymous ;

    I think maybe you need to connect to the data source.

    In the Report Data pane, select New > Power BI Dataset Connection.

    https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets


    Create a data source. You simply have to right-click the “Data Sources” option from the left. If you want to use the already published Power BI datasets, choose “Add Power BI Dataset Connection …”. To add a new data source, choose “Add Data Source”. 

     

    https://hevodata.com/learn/power-bi-report-builder/

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.