Forum Discussion

Springrollz's avatar
Springrollz
New Member
3 years ago

Extracted Function/Stored Procedures resulting in empty tables

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, ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.