Forum Discussion
Power BI Report Server October 2020 update has been released.
Hi Pete,
We are facing issues during data refesh for the Data Source "Xtract Universal", which is extracting data from SAP to any destination (PBI / SQL).
Please find the below System configuration :
Power BI Server Product version : 15.0.1104.264
Power BI Desktop (RS) - 2.86.1321.0 (20.10) (x64)
OS Version: Microsoft Windows NT 10.0.14393.0 (x64 en-US)
CLR Version: 4.7 or later [Release Number = 528049]
IE Version: 11.3986.14393.0
SQL Server
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)
There are some Questions you have asked and i am providing the answer
1.Are you having issues with all reports or just this one? - Only One DataSource is having Issues.
2.Can you say the types of datasources found within this report? - "Xtract Universal" From Theobald-Software
3.Anything different/unique as it related to datasources connectivity in it? - Connectivity through XU Webserver.
4.I assume the refresh fails consistently as well? - Yes
Note : - Apart from Xtract Universal, the Power BI server doing well data refresh on other data sources.( SQL server)
Error Msg :
SessionID: abfe4b75-42fa-46ed-ac20-e3305bc21f24
[0] -1056505856: COM error: mscorlib, An item with the same key has already been added..
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.
[2] -1056505856: COM error: mscorlib, An item with the same key has already been added..
Thanks.
Musthafa