CODEWITHSUNDEEP
powerbipowerbi-desktoppowerbi-datasource
C V KASHYAP
C V KASHYAP

Reputation: 13

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

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?

enter image description here

Upvotes: 0

Views: 1189

Answers (1)

Jon
Jon

Reputation: 4967

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

Upvotes: 1

Related Questions