Hi all. Are Balance sheets and Income statements possible in Acumatica with Power BI?
Solved
Are Balance sheets and Income statements possible in Acumatica with Power BI?
Best answer by vkumar
Hi
You can pull existing Generic Inquires on PowerBI using Odata connection. I don't see a possibility to pull Financial report information using Generic Inquiry (there are no out of the box Generic inquiry as well). Hence, I don't see an option to get the information on Power BI at present.
Regards
Hi
You can pull existing Generic Inquires on PowerBI using Odata connection. I don't see a possibility to pull Financial report information using Generic Inquiry (there are no out of the box Generic inquiry as well). Hence, I don't see an option to get the information on Power BI at present.
Regards
VijayKumarU
1 person likes this
Hi
Please try the below approach and verify if this works.
The data required for the Financial Statements should be in the GLTran table. You can try creating a generic Inquiry with data from the GLTran table, and by enabling the ODATA checkbox.
This generic Inquiry can be pulled into Power BI and have the Balance Sheets reports designed in Power BI.
Thanks
Chandra M
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.