How do I connect to Microsoft GP data from the desktop

[Kp-8500]

Hi,

Currently, my requirement is to work with Microsoft GP data, but GP does not use SQL Server. So, how can I connect to GP data from Power BI Desktop?

Thanks

[AnalyticPulse · Accepted solution]

yes you can do it , you can setup a odbc connection for DP data  and while retriving data in powerbi use the ODBC connector and select your ODBC data sounce connection.

and there is also a connector for connecting to GP data in powerbi i guess. other methods are either time consuming or costly ineffective.

My blog:
https://analyticpulse.blogspot.com/

https://analyticpulse.blogspot.com/2024/04/case-study-powerbi-dashboard-developer.html

See my Pins :
https://pin.it/5aoqgZUft
https://in.pinterest.com/AnalyticPulse/

[v-binbinyu-msft · Accepted solution]

Hi @Kp-8500 ,

First of all, many thanks to @AnalyticPulse  for your very quick and effective replies.

You could refer this document, it introduce how to access GP data in Power BI Desktop: Power BI, Excel & GP - Data Access (jenkuntz.ca)

Hope it is helpful for you.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kp-8500]

Can we not use Odata feed ??

[AnalyticPulse · Accepted solution]

yes you can do it , you can setup a odbc connection for DP data  and while retriving data in powerbi use the ODBC connector and select your ODBC data sounce connection.

and there is also a connector for connecting to GP data in powerbi i guess. other methods are either time consuming or costly ineffective.

My blog:
https://analyticpulse.blogspot.com/

https://analyticpulse.blogspot.com/2024/04/case-study-powerbi-dashboard-developer.html

See my Pins :
https://pin.it/5aoqgZUft
https://in.pinterest.com/AnalyticPulse/