CODEWITHSUNDEEP
powerbipowerbi-datasource
Vishnu Suresh
Vishnu Suresh

Reputation: 187

Can we use both Direct Query and import option in a single Power BI Report?

I'm Trying to create a Power BI Report where I have Two data Sources. One is a SQL Server Database and the other is an excel file. I was wondering If I could import the Excel File and get the data from the SQL server database using a Direct query. Is that possible?

Upvotes: 0

Views: 3611

Answers (2)

VJ87
VJ87

Reputation: 142

Since 2021-01-19 Power BI supports composite models.

composite models in Power BI Desktop

Upvotes: 1

C. Augusto Proiete
C. Augusto Proiete

Reputation: 27818

Power BI currently doesn't support mixing DirectQuery and Import data sources in the same report. You have to choose one or the other for the entire report.

In your case, you could import the data from the Excel file and also get the data from the SQL Server, using the Import mode for both (and have a copy of the data embedded in your report file).

If you import the SQL data using DirectQuery, then you won't be able to import the Excel file.

There's a feature request to allow mixing DirectQuery and Import which you can vote.

Upvotes: 1

Related Questions