Solved

Power BI Connection

  • 18 April 2024
  • 4 replies
  • 76 views

Userlevel 3
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!

icon

Best answer by Keith Richardson 18 April 2024, 18:00

View original

4 replies

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/

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.

Userlevel 3
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. 

Userlevel 3
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. 

Reply


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