Forum Discussion

tempranello's avatar
tempranello
Icon for Advocate I rankAdvocate I
10 years ago
Solved

DirectQuery append

Hello there   I understand that Power BI Desktop currently provides limited functionality when using DirectQuery, but I'm having trouble establishing if I've bumped into the limit of its capabiliti...
  • HarrisMalik's avatar
    HarrisMalik
    10 years ago

    tempranello I dont understand why you are getting the error when you use your query with unions. I have tested the following query

     

    SELECT A, B, C
FROM dbo.TABLE1

UNION 

SELECT A, B, C
FROM dbo.TABLE2

UNION

SELECT A, B, C
FROM dbo.TABLE3

    It is working fine.

     

    Steps:

    1. Get data -> SQL Server

    2. Give SQL Server name in first field

    3. Give Database name in second field 

    4. Open SQL Statement and paste the union query

    5. Click load and select DirectQuery option

     

     

HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
10 years ago

tempranello I dont understand why you are getting the error when you use your query with unions. I have tested the following query

 

SELECT A, B, C
FROM dbo.TABLE1

UNION 

SELECT A, B, C
FROM dbo.TABLE2

UNION

SELECT A, B, C
FROM dbo.TABLE3

It is working fine.

 

Steps:

1. Get data -> SQL Server

2. Give SQL Server name in first field

3. Give Database name in second field 

4. Open SQL Statement and paste the union query

5. Click load and select DirectQuery option

 

 

tempranello's avatar
tempranello
Icon for Advocate I rankAdvocate I
10 years ago

Thanks for that.  Very helpful!