Forum Discussion

cibin_louis's avatar
cibin_louis
New Member
9 years ago

Help on using IBM DB2 Z/OS Mainframe stored procedure result set (data) in PowerBI report

Hi All,   I am trying to create a report by executing a DB2 stored procedure on the mainframe (Z/OS). The stored procedure returns a single result set. Stored procedure works fine when tested but w...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi cibin_louis,

You didn't receive any errors beside empty table? I have made some research and found some tricks. Please try and check if it works fine.

  1. Click "Edit Queries" in the "Home" tab, a "Query Editor" window pops up.
  2. Click "New Source" ->"SQL Server" and fill the "server","database","Sql Statement" with "testServer","testdb","exec p4test 'goodday'", click ok.
  3. Click on that query on the left panel and click "Advanced Editor" in "Home" tab, and paste the below code.


    let
    Source = DB2.Database("server", "darabase",[Odbc.Query(“dsn=DB2EMPA”,”CALL EMPLOYEE.SUMMARY1(‘MATHS’, ‘5’)”])
in
    Source

Best Regards,
Angelia

umarsalaluddin's avatar
umarsalaluddin
New Member
9 years ago

Can you please confirm if this suggestion will work for IBM DB2 ?.  SQL Server is mentioned as the New Source in your response.