Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi, Good day !
I have a question when I want to return a dataset by running multiple sql in POWER BI ingres ODBC.
I used the vectorwise DB, use Ingres Driver to create ODBC, when ran single sql, it is ok, but when I run several SQL, POWERBI show a error as below, I want to konw whether exists a solution for it.
Also attached the M language:
let
Source = Odbc.Query("dsn=VW_US",
"drop table if exists part;#(lf)create table partas select sku_no from cis.part_master where vend_no in(12345,6789)#(lf);#(tab)#(lf)select * from part;#(lf)#(tab)")
in
Source
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.