Hi all,
Someone asked me an excellent question, and I’m asking here because it feels like something there probably is an existing tutorial for, but I'm failing to find it in my searches.
Assuming a customer has Azure Entra ID configured for logins, and native users are all forbidden (So OData via basic Passwords isn’t available)
Has anyone got complete instructions/a complete tutorial for configuring a PowerBI connection to Acumatica as a Connected Application (To retrieve data)?
I’m slightly afraid I’m going to have to teach myself how to write a Power Query connector from scratch
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connector-extensibility#certified-connectors
(I have looked into installing the Acumatica content pack for Power BI, but I’m under the impression that pack isn’t maintained fully, and I’m having problems installing it which I’ve reached out to Microsoft support to help me diagnose.)
Question
PowerBI via OAuth connection for Acumatica site configured to Azure Entra ID SSO (Active Directory)
+3
Hi Will, Have you tried the following:
Integration with External Applications
To Integrate an External Application
+3
I’m trying to use Power BI to query data from Acumatica.
Unless I’m mistaken, those 2 articles are for Acumatica to query Power BI.
I believe the artilces are for Getting data into Acumatica for display
I’m trying to Get data out of Acumatica for calculation
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.