OData V4 scheduled refresh in Power BI Report server error
In Power BI Report Server I'm trying to add a scheduled refresh with Data from Business Central using the Odata V4 feed. Unfortunately, I am getting this message: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Cannot process the request because the default company cannot be found. You can specify a default company in the service configuration file, or specify one for each tenant, or you can add a query string in the form of "company=[name]". You can see the available companies by accessing the default OData web service, Company. For more information, see "OData Web Services" in Help. CorrelationId: abf464e6-9697-433b-8469-79be61ed1476.) I've tried all types of verification options (Key, OAuth2 etc) Using the OData Feed in the Power BI desktop is no problem. All data is Refreshing and available. Also in the OData feed Url, the Company name is set. I don't understand why it is asking for the "company=[name]" in the report server while it is already set and works in Power BI Desktop. I look forward to your reply!
Lookup error for session ID using report server DB or API
Hi, We are using SSRS APIs to create refresh plan schedule for PBIX report on PBI report server. And we get the last run status but it does not return details. Data Refresh failed, contact the administrator, SessionId: dd13d7bf-56ef-4eed-865a-de6f67d3a50e. We do have the session ID and if we search for it in report server logs then we find the details. Also we can see details if we go to refresh plan details on report server UI. Details in SSRS log: Data Refresh failed, contact the administrator, SessionId: dd13d7bf-56ef-4eed-865a-de6f67d3a50e. Details in refresh plan UI: But we want to show this info on our web application. We already tried searching report server DB (tables, executionlog views, etc) for these details but did not find any thing. Where can we find these information/details other than reporting services logs? Any API or DB table?
Authentication error when refreshing API dataset
I have a report which has been running for almost four years that uses multiple API calls to a cloud service to pull in several different data elements in both JSON and CSV formats. These data sources are on a nightly scheduled refresh and have been working just fine until recently. I noticed as I was asked to look into an upcoming modification that the refreshes are now failing with an error stating the credentials are not valid. Thinking the bearer token in the connection string may have expired, I opened my local copy of the report in Desktop and tested the connection, and it worked just fine. The only notes I can find refer to PBIRS not supporting Web.Page and Web.BrowserContents methods for scheduled refresh, but this connection uses Web.Contents, which is supported. The connection authentication is Anonymous as the bearer token is embedded in the connection string, and this has been working until I noticed this issue. Has something changed in how the Report Server manages these types of connections? It's imperative I find a solution as my client is somewhat anxious to have their reporting stay up to date, and will have an effect on the future development they are considering.Dates value changes after schedule refresh
Hi I have a table with one column which is a date value only and the latest date value is 9/11/22. the date is linked to a number of other tables and runs as expected on my on prem version of Power BI as well as when I publish the report to our server. The issue I have is when I run a schedule refresh on the server the latest date value changes to an earlier date 19/04/20. I have attempted to change the date format in power query with no luck. Does anyone know what could be causing this?
Errors occured during data refresh
We are using Power BI Report Server Version 1.11.7815.2641 The connection to PostgreSQL works fine (see connection sucessful below) However, system returns an error message when trying to refresh the data. Would you kindly help with this error ? Thanks. DataSource.Error: PostgreSQL: 08P01: No such user: ServiceGRCMPBIRSPROD. DataSourceKind = PostgreSQL. DataSourcePath = ddlgpmprd11.us.dell.com: 6420;gp_ns_ddl_prod. Message = 08P01: No such user: ServiceGRCMPBIRSPROD. ErrorCode = -2147467259. ;PostgreSQL: 08P01: No such user: ServiceGRCMPBIRSPROD. The exception was raised by the IDbCommand interface.
