Question

Power BI Connection

  • 18 April 2024
  • 4 replies
  • 33 views
jamest
Rank
Userlevel 2
Badge

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!

4 replies

Keith Richardson
Rank
Userlevel 4
Badge +2

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/

-Keith Richardson (Acumatica Developer MVP)
F
Rank
Userlevel 3
Badge

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.

jamest
Rank
Userlevel 2
Badge

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

jamest
Rank
Userlevel 2
Badge

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