Extracted Function/Stored Procedures resulting in empty tables

[Springrollz]

Software: CCH which is accounting software.

I am trying to import aged creditor and debtor reports from CCH, I have successfully connected CCH to PowerBI but when executing functions and/or SPs, it results in tables with correct column headers but empty tables.

This also happens in SQL also so I'm pretty sure it's not a PowerBI issue.

 let
Source = Sql.Databases("**-sql02\cchsql"),
CentralBM = Source{[Name="***"]}[Data],
Reporting_AgedCreditors = CentralBM{[Schema="Reporting",Item="AgedCreditors"]}[Data],
#"Invoked FunctionReporting_AgedCreditors1" = Reporting_AgedCreditors(null, null, null, null)
in
#"Invoked FunctionReporting_AgedCreditors1" 

I've also tried using parameters to no avail, any advice would be highly appreciated. I know fx or SPs work because on CCH  it  creates aged debtor reports on demand.

[silversea]

Are you using CCH Axcess or which CCH software? Do you still have issue with this?

[v-jingzhang]

Hi @Springrollz 

If you remove the last step as below, what result does it return? 

let
Source = Sql.Databases("**-sql02\cchsql"),
CentralBM = Source{[Name="***"]}[Data],
Reporting_AgedCreditors = CentralBM{[Schema="Reporting",Item="AgedCreditors"]}[Data]
in
Reporting_AgedCreditors

If you want to use Stored Procedures in Power BI, you may refer to the following blog:

How to Use Stored Procedure in Power BI? | by Mücahit Berçin | Akkim Akademi | Medium

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.