Forum Discussion
SAP B1 Report to PowerBI
Hey Experts, Currently we have been trying to set-up a PowerBI Dashboard with Live SQL query to SAP. However, the information we want to use in the dashboard is from an overview in SAP. We believe...
Thank you everybody for the help,
We fixed the issues ourselves in the following way:
We searched the SAP B1 Report in the SQL Database in the query table "OUQR", in the OUQR you can find all the queries that are being used in SAP B1. We then found the query that was done to create the report in B1. This query had it's own query string ofcourse, we took this query string, copied it inside the powerBI SQL connect and then it worked.