Report Server Power BI

Anonymous — Tue, 01 Dec 2020 10:48:55 GMT

Hi,

Please help me urgently.

Thanks in advance.

I migrated .rdl file from sharepoint server to power BI. By doing i used below urls

web service=http://<MyServer>/ReportServer/ReportExecution2005.asmx

web url=http://<MyServer>/Reports/report/YTKMaatila/Taloustiedot

and getting run time error as below:

[Script Task Error] Error: System.Web.Services.Protocols.SoapException: The path of the item 'http://<MyServer>/Reports/report/YTKMaatila/Taloustiedot' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item 'http://<MyServer>/Reports/report/YTKMaatila/Taloustiedot' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo3& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ST_773ec818944c451cba56db5c807bb394.<myserver>.ReportExecutionService.LoadReport(String Report, String HistoryID) in C:\Users\xxxxxx\AppData\Local\Temp\1\Vsta\05c10c4b4fb74e8a9aca8df97cd3a5a9\Web References\<myserver>\Reference.cs:line 332
at ST_773ec818944c451cba56db5c807bb394.ScriptMain.Main() in C:\Users\xxxxx\AppData\Local\Temp\1\Vsta\05c10c4b4fb74e8a9aca8df97cd3a5a9\ScriptMain.cs:line 130

it seems that Power BI has not compatibilty with rld file and it is not able to load the report.

Could you help me with the url's i have used and any changes required in settings.

Tested=reportservice2010.asmx used in assembly reference but load report method is not in reportservice2010.asmx .

topic Report Server Power BI in Report Server

Report Server Power BI