Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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/
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.
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.
Can we not use Odata feed ??
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/
User | Count |
---|---|
82 | |
80 | |
71 | |
71 | |
55 |
User | Count |
---|---|
108 | |
108 | |
97 | |
86 | |
68 |