Forum Discussion

MRRAC's avatar
MRRAC
Regular Visitor
9 years ago
Solved

Excel and SQL server direct query

Hi, I´ve tried to connect an excel file into a report which already have a sql server connection as direct query, but BI forces to change both to import data. How can I have SQL server data as direct query and excel as imported data? Or is not possible.

 

Thanks in advance.

 

Regards.

  • Anonymous's avatar
    Anonymous
    9 years ago

    MRRAC It isn't possible. You are not able to mix connection types. I would suggest loading the Excel file as a table in the database so that you can pull it in via DQ.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    MRRAC It isn't possible. You are not able to mix connection types. I would suggest loading the Excel file as a table in the database so that you can pull it in via DQ.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      Hello, I know that power bi gets updated monthly. Does anyone know if this is still the case?
      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Anonymous Yes, this is still the case. The Desktop gets monthly updates (occasionally more for bug fixes). The Service is on a quicker cadence usually, I think it releases 2x a month, but for sure it is at least 1x.

         

        Desktop Release Archive

        Service Updates