Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

How to add new data when I already use power bi dataset

Hi,

I built power BI dataset and let my users to use it.

Now user want to combine his/her local data and my power BI dataset to adhoc analysis.

But user cannot add any new data source from "Get data" tab. (user working with PBI desktop)

TomoKawa_0-1651450043659.png

How can I make it possible to add new data by users?

Need some setting in dataset configulation?

Please help.

 

BR

Tomo

Status: Delivered

Hi @TomoKawa,

 

To combine data with Power BI datasets, you could take Direct Query to Power BI datasets. But you need to know that there are some limitations on this feature. For more details, you could refer to the doc:Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs.

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Delivered

Hi @TomoKawa,

 

To combine data with Power BI datasets, you could take Direct Query to Power BI datasets. But you need to know that there are some limitations on this feature. For more details, you could refer to the doc:Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs.

 

Best Regards,

Community Support Team _ Caiyun

TomoKawa
Regular Visitor

Thanks lot, it works.