Power BI - Blending PBI Dataset with Other Datasets
Power BI (PBI) is a great tool for data visualization. In the past, we cannot make use PBI dataset with other datasets at the same time such as PBI dataset and Excel/ SQL Server/ OneDrive etc.
A good news is that Microsoft has brought this functionality to the latest versions of PBI Desktop by the end of 2020. By somehow, it is still a preview feature not the official one. It means that the feature might change or be removed in the future releases.
Therefore, if you wish to use the functionality for now. There is a couple of steps to carry out before utilizing it as follows.
1. Go to Options and settings\ Options
2. Enable DirectQuery for PBI datasets and AS
3. Restart PBI Desktop
Hope this helps. If you have any ideas or comments please share!