Scheduled Refresh with OData Feed not working within Report Server
Hello, I have created a Dataset within the on premise report server using the Report Builder. I am using OData Feed within my desktop application to create a report. Once uploaded to the server, the report works fine, but when I go to schedule refresh, it is not accepting my credentials. I have tried all authentication methods - Anonymous, Windows and Basic. I have also tried using my personal windows login credentials and the sql server credentials that I have used for connecting to the datasource, but they don't seem to work. When I open the report in the server and then click edit in the dektop application, and then manually refresh within the application, save and close it, then open it in the server, it is refreshing. But I would like to refresh the report using scheduled refresh instead. Kindly let me know if I am missing something here. Thank you
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!
Power BI Reporting Server Solution
Our client (Company A) and our project team has faced the difficulties below to deploy Power BI Report server solutions. Can you advise how we can get support on that? Company A ’s Requirement: Due to security concerns, users need to get the data in Company A ’s Oracle DB without directly connecting to Company A ’s Oracle DB. Our current solution: First, we create a Data Source connecting to Oracle DB in Power BI Report Server by using ADO.net Connector with SSL (Oracle Wallet). Then, we create a Dataset using the Data Source. And the last, users use Odata Feed connecter in Power BI Desktop/Excel or Postman to connect to the Dataset with Power BI user authentication with Company A's Active Directory. The problems of current solution: Not able to load data into Power BI Desktop/Excel/Postman from Dataset using Odata when the amount of data is large (Timeout occurred), any sizing guide or limitation on this? Not able to create Data Source connecting to Oracle DB by using ADO.net by SSL with Wallet The additional concerns: Limitations of concurrent user capacity Any other solutions could cope with the need required? Thanks for your advice!
Odata - failed to connect to data source - Remote server returned an error : (400)
Hi, Trying to connect Clarity PPM data warehouse using Odata but get this error message: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (400) Bad Request. ([HYT00][0] Login has timed out.). '. The weird things is that I am able to conncet to a different environment with no issues. Please advise how to solve this, Dovi
OData Feed SharePoint List Data Refresh Issue: Too Many Lookup Columns
Hi, I am using PBI Desktop to create a dashboard and publish it to the server. As data source, I am using OData REST service to query the data in the form of https://<SERVER_NAME/_api/web/lists(guid'<LIST_GUID>')/items?$select=Id,Title with additional columns for a total of 20. In PBI Desktop, it loads as expected and gets refreshed without a problem. When I upload to PBI Server, the OData Source Feed refers to the root data source https://<SERVER_NAME/_api/web/lists(guid'<LIST_GUID>')/items which gives back a 500 error, saying that "the number of lookup columns it contains exceeds the lookup columns threshold enforced". That is true for the entire list but that is not what I am instructing Power BI to do. Is there any way to refresh the prefiltered data source instead of the entire list? Thanks.
Refresh of Sharepoint Online Odata from power Bi report server
Hello, I was able to create a report in power bi desktop which connect to a Sharpeoint online site using Odata. To do so I had to use Organizational account as the Windows authentication was not working. Now when I publish the report on the report server and shedule a refresh I'm facing the error: The credentials provided for the OData source are invalid. So I want to edit the data source connection which is Odata. Problem is that the option are very limited and using Windows authentication fail "Log on failed. Ensure the user name and password are correct." You can't set up the the report server to use Organizational account. How to plan a refresh from the report server using Odata from a sharepoint online site ?
Reports in Power BI Report Server Shows Incorrect Project Issue data
Our on-premise Power BI Report Srever has a section for Project Issues. It should show each issues that is not complete or closed. It should also not show 'On-Track' as an issue status, as those were replaced with 'Active.' However, there are several 'On-Track' statuses present, there are missing issues, and there are issues that have modified columns values that aren't showing up. It's as if the data is stale and not representing a current snapshot of the actual data. There are even missing projects entirely as if they don't exist. I have gone into the SQL database and queried for all the issues for a given project, and I see the correct data there. I have also queried the issues for the same project via PowerShell, and the data is correct there as well. But when I use Odata via a URL to return the data, it shows incorrect data or is missing data. I've also used Odata feeds inside of Power BI Desktop to no avail. Refreshing doesn't error that I can see, but the data appears to remain stale. Does anyone know how to resovle this issue? Regards, Paul
Issue refreshing, recently added Odata feeds, issue with memory
I keep throwing an error while I am trying to refresh my data. At first it said ODB error and then an error about memory: Memory error: Memory Allocation failure : Not enough memory resources are available to process this command. . Try simplifying or reducing the number of queries. So I tried unclicking "include in refresh" on several tables got this error: Exception of type 'System.OurOfMemoryException' was thrown with the following details: Feedback Type: Frown (Error) Error Message: Exception of type 'System.OutOfMemoryException' was thrown.
