Skip to main content
Solved

Power BI Connection

  • 18 April 2024
  • 4 replies
  • 201 views

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 5
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 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. 

jamest
Rank
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. 

Reply


Terms & ConditionsCookie settings