As we can see from the Power BI Desktop, there isn't a connector like "SAP business one". So my suggestion is connecting to the database directly. You also can try other connectors that the SAP Business One can provide. For example, sapbusinessone/odata/.
Please note: I'm not a professional of SAP. I can only provide some suggestions.
Best Regards, Dale
Community Support Team _ Dale If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I come across this post and am wondering if you have found a solution to this use case? If yes, would you mind to share some hints?
My understanding is that Power BI is like Excel as a reporting tool to B1. You can connect Power BI to the SQL/HANA database and do more modeling once the data is loaded to Power BI. But I am not aware of any pre-defined Power BI Content Packs by Microsoft that one can just plug-and-play. You may have to look at some 3rd party add-ons, if there is, please do share the info; or you may need to build your own model.
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?