Forum Discussion
Combining Multiple Datasets - BigQuery and PowerBI Dataset
I had a PowerBI dataset shared with me and I am trying to use that dataset in a report and then also pull in a dataset that I pull in directly from BigQuery and can't seem to figure out how to do so.
I want to create 1 report with both datasets so I can compare the data between the two.
Any ideas?
Hi Anonymous ,
PowerBI Dataset is a Live Connection connection mode. This connection mode cannot add another data source.
You can go to File - Options - Select Preview features - DirectQuery for PBI datasets and AS in Power BI Desktop, and convert it to DQ connection mode, so that you can add another data source.
This is the related document, you can view this content:
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous ,
PowerBI Dataset is a Live Connection connection mode. This connection mode cannot add another data source.
You can go to File - Options - Select Preview features - DirectQuery for PBI datasets and AS in Power BI Desktop, and convert it to DQ connection mode, so that you can add another data source.
This is the related document, you can view this content:
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
Anonymous , Add power bi dataset into a blank file. Go to modeling tab, and change the model to the direct query model. Now you can add data from other datasources
I'm not seeing that as an option. Here are my exact steps:
Create new blank file in PowerBI DesktopSelect "Get Data" > PowerBI DataSet > Select Dataset (That I don't own but have been granted access to)
Tables get populated on the right hand side
After doing this I can no longer select "Get Data" and I don't have the options you mentioned about changing the model to direct query.
