Search code examples
powerbipowerbi-datasource

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?

Solution

  • 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.