Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
dskeane
Helper I
Helper I

Power BI with Great Planes - odata

Looking to create a link from Greate Planes to Power BI. My question comes down to the odata path that GP provides me to link to Power BI odata gateway.

I get a link that doesnt have a http:// it just has the path /GPOData/Information/Account Summary.



When in power bi I am unable to load using the odata path, i have tried server path ip and name also to no avail.

Any suggestions welcome.

3 REPLIES 3
StevenC6
New Member

Try this link, you have to install the OData system fromt he Great Plains installer and have IIS running on the server

 

https://dynamicconsulting.com/2019/01/15/configuring-the-odata-service-for-dynamics-gp/

amitchandak
Super User
Super User

@dskeane , see if this can help

https://www.youtube.com/watch?v=heytwLhHj6k

 

All links I got are pretty old. And do not have full setup. see if this can help

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks this video overall lets me know the choices and found a step i was missing. I am getting an error however after it try's to connect in PBI see below. My only thought would be that that I am trying to connect to the odata from a remote source?

 

dskeane_0-1651672022368.png

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.