PowerBi in Azure

[sreelalimpact]

Hi, when I try to open Power BI (Screenshot 1) over a datawarehouse in Azure, there is no option to merge/join tables or Right click on the tables. Here the ribbon itself is having very minimal options(Screenshot 2). So my questions are,

1) Can we do this without Power BI Desktop (Avoiding the Get Data from Azure Data Warehouse) ?

2) Can the tables be merged with Queries like the options we have in Power BI Desktop?

3) Trying to automate the Dashboard on the basis of data updations in the tables. Is there any better way to do this?

[v-ljerr-msft · Accepted solution]

Hi @sreelalimpact,

As far as I know, common query tasks like shape and combine data can only be done within Power BI Desktop(Query Editor) currently. So I would suggest submit your requirements on Power BI Ideas forum, in order to improve Power BI on this feature. 

Regards