Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Error in SQL query in Power BI in advanced editor (PostgreSQL)

Hello,

 

I have a SQL (PostgreSQL) which not works, I am writing that SQL in Power BI advanced editor. 

 

SELECT rws.zu0_kod AS zu0_kod,
rws.did_nr AS did_nr,
rws.adm_var AS adm_var,
rws.did_dat AS did_dat
,COUNT (1) AS eil.skaicius
FROM (SELECT tab1.zu0_kod,
tab1.did_nr,
tab1.adm_var,
tab1.did_dat
FROM (SELECT id_vidp AS id_vidp2,
zu0_kod AS zu0_kod,
AS did_nr,
adm_var AS adm_var,
did_dat AS did_dat
FROM s.vidp
WHERE s.vidp.did_dat >= filterdate) tab1
LEFT OUTER JOIN s.vidp tab2
ON tab1.id_vidp2 = tab2.id_vidp) rws

 

I am getting this error:

DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near ".";
Error while executing the query
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=dbname
OdbcErrors=[Table]

2 Replies

  • Analitika , Rename of count seems to have issue

     

    SELECT rws.zu0_kod AS zu0_kod,
    rws.did_nr AS did_nr,
    rws.adm_var AS adm_var,
    rws.did_dat AS did_dat
    ,COUNT (1) AS eil_skaicius
    FROM (SELECT tab1.zu0_kod,
    tab1.did_nr,
    tab1.adm_var,
    tab1.did_dat
    FROM (SELECT id_vidp AS id_vidp2,
    zu0_kod AS zu0_kod,
    AS did_nr,
    adm_var AS adm_var,
    did_dat AS did_dat
    FROM s.vidp
    WHERE s.vidp.did_dat >= filterdate) tab1
    LEFT OUTER JOIN s.vidp tab2
    ON tab1.id_vidp2 = tab2.id_vidp) rws

    • Analitika's avatar
      Analitika
      Post Prodigy

      amitchandak 

      SELECT rws.zu0_kod AS zu0_kod,
      rws.did_nr AS did_nr,
      rws.adm_var AS adm_var,
      rws.did_dat AS did_dat
      ,COUNT (1) AS ""eil.skaicius""
      FROM (SELECT tab1.zu0_kod,
      tab1.did_nr,
      tab1.adm_var,
      tab1.did_dat
      FROM (SELECT id_vidp AS id_vidp2,
      zu0_kod AS zu0_kod,
      did_nr AS did_nr,
      adm_var AS adm_var,
      did_dat AS did_dat
      FROM public.vidp
      WHERE public.vidp.did_dat >= '" & sFilterDate & "') tab1
      LEFT OUTER JOIN public.vidp tab2
      ON tab1.id_vidp2 = tab2.id_vidp) rws
      GROUP BY rws.zu0_kod,
      rws.did_nr,
      rws.adm_var,
      rws.did_dat

       

      Getting empty table: