Cannot connect Power BI with SQL server
Hi, I found issues with connecting Micsrosft SQL Server with Power BI. I do not have any experience in such connections, so I am blindly doing different steps but I simply don't uderstand what I am doing, hence I am not able to know what's going wrong. So, I read I need gateway installed, and I did. Install an on-premises data gateway | Microsoft Learn Then I set up gateway name and key based on another article. And then, what's next? I found this article Add or remove a gateway data source - Power BI | Microsoft Learn but I am unable to folllow steps, I can't find setting button. Do I need any additional version or access to be able to complete this? I tried to put in Power Bi credintials that theye were given to me around the server, but no luck with any connections. Instead of Server name, I have Port number, but I reckon this is the same. I put passowrd and user's name into Power BI server query, but I encounter error message, hence I think this gateway needs some further steps I haven't completed yet? Thanks!
Report Server Power BI
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 .Removing large white space underneath report in report server
Hi Is there any way to remove the white space underneath a report ? I have a report where the page height is only 400 as its a small but wide report , however when I publish this , there is a large white space under the report which has an affect when I am using this on full screen for a wallboard. Can anyone advise how to do this so my page size takes up the whole screen ?
CLIENT who launched the report LOCALTIME
Good afternoon, Please tell me how, when starting a report on a report server, take computer time where this report was started? Get the update time of the report on the server, taking into account the local time that started the report Those. Server has Moscow Time. or i don't understand maybe has time without UTC...because (And why in the update schedule on the server says "All times are expressed in (UTC + 03: 00) Russia TZ 2 Standard Time." But is it not so and utc = 00:00?) I mean DateTimeZone.LocalNow() when the report updated - Time without UTC, when i update from computer its time with correct utc I need When I run the report from Arizona there will be -7 hours from server time, if it is Novosibirsk +7 hours ...Power BI Server Scheduled Refresh fail
Hi, I am struggling with A powerBI report which pulls data in from and Access database and Excels. It works fine in PowerBI Desktop and refreshs correctly. When it is uploaded to PowerBI server it throws the follwing error when attemting to refresh the data: SessionID: d1d3c3e1-7dbc-46a4-bbba-fb80019a37d3 [0] -1055784932: Unspecified error. The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [8] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [9] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [10] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [11] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [12] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [13] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [14] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [15] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [16] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [17] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [18] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [19] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. In "data sources" all the files connects fine. Any sugesstions would be very helpful. Thanks.PDF folder source datasource issue in Gateway Refresh Issue:
PDF folder source datasource issue in Gateway Refresh : I have created Power BI report using PDF files in Folder based. If I use sharepoint location without gateway, the refresh works fine. But it is taking lots of time. If want to extract 3-4 pdf it takes 20 mins. I have tried with one of the local folder(\\server\e\source\), it works very fast. Almost in seconds I can get the report. But when I tried to configure gateway online, could create the gateway. Issue is it not refreshing with below error. " Every time it shows different queires. Has anyone come acorss this issue. Please suggest. The import Pdf.Tables matches no exports. Did you miss a module reference? Regards,
Offline maps for Power BI? No internet available to report users.
Hello, Does Power BI Reporting Server offer any support for maps when the report users are cut off from the internet? PBIRS is an on-prem solution and some on-prem report users do not have access to the internet. I understand that SSRS has offline map functionality through shapefiles. Does Power BI RS have a similar functionality? If not, what other options are available? Thanks
