unable to connect power BI with SAP BW
Hi Power BI experts, I have issue in connecting my SAP BW system with power BI gate ways, please find the details. What i have done sofar 1.I have installed .net connector 2.Then using SAP BW ware house connection i have succesfull able to connect SAP BW bex queries and model the data in power BI desk top 3.Then i have saved the report and published the report which returned with no gate way acess to data source 4.Then i have succesfully installed SAP gate way cluster and it says online---you can only get started 5.I have installed SAP 7.5 RFC netweaver libary menyioned in the SAP note 1025361, copied dll files from lib folder and placed it in cdrive---windows---system 32 What i am unable to achieve 1.When i try adding data source with option sap buisness warehouse and provided, server instance clinet and user ID and password details and now i get the error message Cannot connect: An error has occurred while connecting to. Details: Cannot register this data source for gateway instances in this cluster. For more information about specific errors for each gateway instance, see below. show details Troubleshoot connection issues 1.I am using Power BI desktop version 2.65.5313.1381 64-bit (desember 2018) 2.I have downloaded 64 bit version SAP NW RFC SDK 7.50 library from the below link link, please see the first screen shot https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVEN... 3.I have copied dll filtes from the downlaled SAP RFC libarary from step 2 4. 4.Pasted the copied files in step 3 in to c----windows---system32folder 5.Then created a gate and tried adding data source which gave us the error. BR LakshmikanthPower BI Report Server role
Hi I am new to the Power BI Report Server. I do some research on roles (security) and I would like to know even more about the My Reports role knowing then that I have a free version of Power BI Report Server and I do not use SQL Server Management Studio. I can not find the "My Reports" folder. thank you in advance
Issues with Power BI report server and Basic Authentication
Hi All, I am facing an issue with Power BI Report Server (august preview version) We have configured the Power BI report server to use Basic Authentication (<RSWindowsBasic/> in the rsreportserver.config file) But now deployed Power BI reports throw an error (the Something went wrong message ) when I open the report for viewing. Also Power BI reports that just contain a text label will not open. The log file also shows errors related to this problem, here is a fragment from RSPowerBI log file: 2017-10-12 10:28:14.3631|ERROR|4|GetDataSource ERROR for catalogItem=b319987d-65cd-4bf5-9a70-d1d0cdc0adec, Exception=The format of value '<null>' is invalid., ElapsedMs=7| RequestID = 0d131cc1-61d5-8e4c-a9d2-9e8e3abd192f ClientSessionID = b7ecce4c-9ff5-7df2-f941-41993b719e65 2017-10-12 10:28:14.3631|ERROR|4|Failure in conceptualschema| RequestID = 0d131cc1-61d5-8e4c-a9d2-9e8e3abd192f ClientSessionID = b7ecce4c-9ff5-7df2-f941-41993b719e65 System.FormatException: The format of value '<null>' is invalid. at Microsoft.PowerBI.ReportServer.WebApi.ASConnection.RSDataSourceProvider.GetDataSource(Int64 modelId) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.CreateModelKeyFromId(String modelIdFromClient) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.EnsureSession(String modelId) at Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.<RunAsync>b__8_0() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ExploreHost.ExploreClient.<GetClientConceptualSchemaAsync>d__11.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.ExploreHost.RSExploreHost.<GetConceptualSchemaAsync>d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetConceptualSchemaAsync>d__d.MoveNext() 2017-10-12 10:28:14.3936|INFO|8|Sending response. Response code JoostPOC\Administrator 200, Elapsed time 0:00:00,6367781| RequestID = 0d131cc1-61d5-8e4c-a9d2-9e8e3abd192f ClientSessionID = b7ecce4c-9ff5-7df2-f941-41993b719e65 I also noticed that Power BI Desktop RS does not function when Power BI Report Server is set to Windows Basic Authentication, deploying Power BI reports won't work. My question: is this a bug or is Power BI report server not supposed to work with Basic Authentication? Thanks! Joost
