Can't refresh reports. On-Premise Gateway / DNS Problem?
Hello, I have a problem with data refresh through an On-Premise Gateway. Both planned and manual refresh are causing issues. All reports are affected. It usually takes too long to refresh (over 10 min.) and then this error code is shown. There were times when I could refresh my reports manually today, but the issue kept showing later again. I tested reports with data from different SQ servers. Then I created a new gateway on my pc and turned off the gateway we have in our virtual power bi server. The issue remained. I started to track the data traffic and apparently the gateway is sending data to these Microsoft domains: g0-prod-fra21-001-sb.servicebus.windows.net g1 g2 ... g15-prod-fra21-001-sb.servicebus.windows.net Some of these domains return a local IP address, tested with different public DNS. Currently, g8 is returning 10.218.0.23, g9 returns 10.218.0.24, g15 returns 10.218.0.30. Others seem to have a public IP, like g0 with 51.116.232.39 for example, and the traffic goes through. I'm assuming this might be the reason sometimes the refresh works and sometimes it doesn't. Is someone else having a similar problem?
Server refresh gives Table not found error but fine in desktop
I'm trying to set up my scheduled refresh for my PowerBI report - the connection is an ODBC on import, I have the required drivers and get a green check when I test the connection, however when I refresh I get the following error: SessionID: b5ba2f83-45cb-4fab-8a0e-8a79b6cdbf0c [0] -1055784932: DataSource.Error: ODBC: ERROR [42S02] [Cache ODBC][State : S0002][Native Code 30] [D:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\MDataEngine\Mi] [SQLCODE: <-30>:<Table or view not found>] [Location: <Prepare>] [%msg: < Table 'DBO.DSKILLSETSTAT' not found>]. DataSourceKind = Odbc. DataSourcePath = dsn=MYDSNLOCATION. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055129594: The current operation was cancelled because another operation in the transaction failed. [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. My refresh works just fine in PowerBI desktop, no issues with queries on any tables, it's clearly connecting to the source ok, I'm not sure what I'm missing. I can refresh and save the updated file in desktop and the report data refreshes on server. I'm not sure how or why it can't find the table any more. Here's a snip of the connection structure if I'm creating a new source - the table being queried is called dSkillsetStat in the dbo folderPower BI cloud datasets refresh setup & run has an error
Hi team, I have published one report to Power BI cloud services and setup the refresh functionality. all data source credentials defined successfully, however at the time of auto refresh I got following refresh failure message and after review of this I understood this because of one file extension is "XLS" is causing this refresh functionality failure. The file with this "XLS" extension can not be converted to any other readable format because this file is being generated on daily basis by default from another application and available on network path. Now, I am looking for solution which allows this "XLS" extension file to be refresh in cloud service without any failure error. The error message is as follow for your reference. \\Error Message Start Refresh failed: Retail Sales Report has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. <ccon>DataSource.NotFound: <ccon>Excel Workbook</ccon>: <ccon>The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.</ccon>. </ccon>. The exception was raised by the IDbCommand interface. Table: DAILYFILE. \\Error Message End Thank you. Regards Riz
