Adding a new data source to the existing report built with a dataset

Question

I am new to Power BI and trying to build a report for one of our business requirements. I have access to a Power BI dataset which I imported in the Power BI desktop version. I also need to import an excel file placed in SharePoint/OneDrive and merge the data in these two sources. When I am trying to do this, I am getting the below error.

Is this feature not available in Power BI? If not, is there a way to achieve this objective?

Jon · Accepted Answer · 2020-04-20 08:00:48Z

1

You are connected to a Tabular SSAS cube or Power BI Service dataset, you can't add other data sources.

You can only mix data source types in the modes direct query and import. See the limitations section of the MS docs

One option would be to recreate the Tabular data model in Power BI, over the base table/views it is based on in direct query mode, then add the SharePoint list, or add it as a table in the Tabular/Power BI Service Dataset

edited Apr 20, 2020 at 8:00

answered Apr 16, 2020 at 14:11

Jon

4,9953 gold badges16 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

C V KASHYAP Over a year ago

Can you please share some reference around how to recreate the tabular data model? Also, if this is done, will this data get refreshed automatically with the Power BI Service dataset?

Jon Over a year ago

You create the SSAS Tabular model in Power BI as it's SSAS Tabular, just with out some of the enterprise features, like perspectives etc.

Collectives™ on Stack Overflow

Adding a new data source to the existing report built with a dataset

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related