Skip to main content

Hello all, 

Quick question. Can Power BI only connect to Generic Inquiries? Or is there a way to connect to the instance directly like you would a SQL Server connection? We’re on a cloud instance. Thanks!

You would look at making them available via OData, and connecting them to PowerBI. Doug Johnson has a blog on it here: 

https://www.acumatica.com/blog/technical-tuesday-doug-johnsons-data-visualization-tutorial-odata-and-power-bi/

Hi @jamest , you can connect Power Bi directly to SQL. When creating the reports on your computer you would need to be able to access the SQL server, usually with a VPN. Then you can get the data from a SQL view or a query you write in BI

 

 

After that you would need to install the power BI gateway on the SQL server so that your report will be able to refresh automatically if you want to set it up like that.

@frederickodendaal77 This only works with the onpremise version correct? We are cloud so I’m thinking this data can only be accessed through GIs. 

You would look at making them available via OData, and connecting them to PowerBI. Doug Johnson has a blog on it here: 

https://www.acumatica.com/blog/technical-tuesday-doug-johnsons-data-visualization-tutorial-odata-and-power-bi/

Yes, this confirms what I was thinking. For the cloud version, you only have access to GIs from PBI. Thanks. 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved