Forum Discussion

arobin's avatar
arobin
Frequent Visitor
9 years ago
Solved

Create Connection: This query contains transformations that cannot be used for live connection

 I am very new to Power BI and I am not familiar with the message I encountered when trying to make a DirectQuery connection to SQL Server. Can anyone advise what does "Create Connection: This query ...
General Comment
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi arobin,

     

    Could you please test using a simple SQL statement? You can create a simple table named TableA in your database, then type the basic query statement using like: select * from TableA in Direct Query model, check if it works. Some function is not used in Direct Query model. If it works fine, it will document the function is unable. You'd better test step by step.

     

    If the function is not used, please create a new result table, then import them to Power BI. If you have any issue, please let me know.

     

    Best Regards,
    Angelia 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi arobin,

It should be error in the SQL statement. You'd better join the two table together, and "where a.InternalId=b.InternalId" is improper. You'd better propram the SQL like the following syntax.

select a.*from Table a

inner join

(select * from Table2) b

on  a.InternalId=b.InternalId

GROUP BY a.PAYMENT_TYPE
order by a.PAYMENT_TYPE

And as the Thiyagu, please test it successfully, then use it to import the data.

Best Regards,
Angelia

  • arobin's avatar
    arobin
    Frequent Visitor
    9 years ago

    Hi Angelia,

     

    Thanks a lot for your response appreciate it a lot. I will re-create my query.

     

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi arobin

      Please feel free to ask if you have other problem.

      Thanks,
      Angelia