Skip to main content
Solved

Power BI Connection

  • April 18, 2024
  • 4 replies
  • 525 views
jamest
Varsity I
Forum|alt.badge.img

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!

Best answer by Keith Richardson

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/

View original
    Did this topic help you find an answer to your question?

    4 replies

    Keith Richardson
    Semi-Pro I
    Forum|alt.badge.img+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)
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    F
    Jr Varsity I
    Forum|alt.badge.img

    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.

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    jamest
    Varsity I
    Forum|alt.badge.img
    • jamest
    • Author
    • Varsity I
    • 41 replies
    • April 19, 2024

    @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
    Varsity I
    Forum|alt.badge.img
    • jamest
    • Author
    • Varsity I
    • 41 replies
    • April 19, 2024
    Keith Richardson wrote:

    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. 

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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