Can I add a other data source or excel file after using Power BI datasets as a datasource.

[amty63]

Can I add a new data source or excel file after using Power BI datasets as a datasource.

Because it gets disabled all the options once chosen Power BI datsets as a datasource..

is there any way or workaround to add other datasource with Power BI datasets.

[amitchandak · Accepted solution]

@amty63 , There were few enhancement in Dec 2020 for this - refer:https://powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/#_Toc58831296

or

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...

See if some setting in that can help

[v-robertq-msft · Accepted solution]

Hi, @amty63 

According to your requirement, I think you can use the preview function of the Direct query for the Power BI dataset to add other data sources with Power BI datasets, you can follow my steps:

1. Go to setting and option->Preview to turn on this function:

2. Click on the buttom right corner of the report page->make changes to this model:

3. Click on this button to convert this dataset to a direct query data model:

Then you can add other data sources, you can follow this document to get more information of this preview function:

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@amty63 , There were few enhancement in Dec 2020 for this - refer:https://powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/#_Toc58831296

or

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...

See if some setting in that can help