Forum Discussion
Issue creating SAP BW type Data source in PBI Report Server
Try this string.
DataSource=http://serverURL:8000/sap/bw/xml/soap/xmla
HI Nilesh
i am able to do so. You need to copy the DLL files in the windows program files folder in the machine where you have installed report server and sql server.
it will work
THanks
karan
how does your RSREPORTSERVER.config look?
do you have others in the list then this:
<Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>
No Extensionname like "SAPBusinessWarehouse" or?
Thanks!
for me it still looks like there are datasoure-registrations missing in the current server version?!
If i create a PBI Desktop File which connects by DirectQuery/Import Mode to BW i get a connnection for datasource-type "SapBUsinessWarehouse" published to Report Server wich THROWS error "SapBusinessWarehouse" not registered...
if i try to create a new dataconnection manually in Report Manager the dropdown list shows only "SAPBW" but threre's no "SapBusinessWarehouse" entry at all:
but be really great if someone from the productgroup can give insights on SAPBW vw SapBusinessWarehouse-Extensions differences?!
Datasources created in Power BI report server are not used by Power BI Desktop.. Is a shared data source which can be used by SSRS paginated reports and mobiles reports. see link bellow.
To create a Power BI report based on BW , you need to connect to SAP Business Warehouse server inside of the Power BI desktop by Get Data.
In the PBI desktop the report and bw connection works fine, but after you save in the "Report Server" the datasource does not connect anymore. It seems to be a product problem... Must be addressed by the "Microsoft IntegrationTeam".
We tried to copy all DLLs from NW 75 in the windows file system , but the problem persists.
Yes I do see sapbw extension entry in data node.
