Forum Discussion
RahimZulfiqar
Advocate II
8 years agoHow to connect POWER BI with SAP Business One Software?
How to connect POWER BI with SAP Business One Software?
calerof
Impactful Individual
7 years agoHi Anonymous ,
I used the SQL Server data source in Power BI.
The following link may help you. Tutorial: Connect to on-premises data in SQL Server
Cheers and good luck,
Fernando
Anonymous
7 years agoNot applicable
Hi Fernando,
Thank you for sharing.
I have some reports and dashboards using Excel pivot tables which retrieve data from B1 using SQL queries and ODBC connections (for budgeting, sales, and warehouse operations). I find Power BI a good option to replace these Excel files for key users considering the mobility benefits Power BI offers.
For my curiosity, how do you find this PBI and B1 combined solution so far for you? And if you don't mind, would you please share if you are from a B1/Power BI partner's or an end cusotmer's perspective?
Thank you,
Jimmy
- calerof7 years ago
Impactful Individual
Hi Jimmy,
I'm an independent BI consultant.
It's difficult at the beginning, but after struggling a bit with the tables the rest goes in a more decent way.
If I could be of any help please let me know.
Kind regards,
Fernando