There might be a scenario when you have one or more than one Power BI Datasets published on the service which you want to utilize to create a new report. Now since Microsoft has rolled out the preview feature Using DirectQuery for datasets and Azure Analysis Services (preview) – Power BI | Microsoft Docs this can be done.
So what do you need ?
You would need one or more than one report published on the Power BI Service in a workspace. Using my workspace in this case is not supported.
Additionally Users need to be provided Build Permissions to use this feature on all the datasets.
Let’s Get Started
To begin enable the preview feature -directquery for Power BI Datasets and AS feature
To connect to the first report start by selecting Get Data-> Power Bi Datasets and then select the report from the list of reports this will create a Live connection to that report.
Once a live connection is established to the first report you will notice a message on the bottom right showing the Report Name and Workspace Name along with an option that says Make Changes to this model
Now to use a second report click on the make changes to this model on the bottom right. This will display a message asking that this action will require the connection to be changed to the direct query mode. Select Add a local model to proceed.
In order to change the connection from Live to directquery you have to select the list of tables and press the submit button.
Once this is done you can again select Get Data-> Power bi dataset to add the second report dataset. You can also select which tables you want to import in your report once these tables are added you will be able to see all the tables from each of the datasets you have used in the field/table section.