error on data load

6 Topics

Error in visuals from outside - Couldn't retrieve the data for this visual
Hi all, I am having an issue loading visuals in my report on Power BI Report Server (January 2025). The visuals do not load in first trial but can load eventually by switching report pages multiple times (see below). The report has 6 unhidden and three hidden pages. Four of the unhidden pages each have a number of visuals (custom column charts) and eleven slicers. My report is build in Power BI Desktop RS (January 2025 version) with import data. The Access database with the full dataset is 333 MB and the PowerBI report on Desktop is 196 MB. From the server itself I can open the reports and load the visuals in Power BI Desktop for RS and in Power BI Report Server via a browser without any problems. From outside the server I can log in and load the first page of the report. I can (often) load the other report pages with the standard filtering. On each page I can filter my results using a number of slicers. The slicers are used on several visuals at the same report page AND synchronized on several report pages. When I try to filter using the slicer, the report server returns an "A network error was encountered Please check your connection to the internet". In "See details" I get: "Error fetching data for this visual Couldn't retrieve the data for this visual. Please try again later. Please try again later or contact support. If you contact support, please provide these details. Http Status Code200" If I try to select another report page (still with the slicer active) the new report page (often) doesn't load either. BUT if I return to the first report page (still with active slicer) then suddenly the visuals loads!!! If I add another slicer, again it will fail, but can eventually load using the above steps. This tells me that I have access and that the report is able to load, but for some reason it is not able to load in the first trial. Does any of you know what can cause this, and how to fix it? Any help will be much appriciated!
Solved
MarieKAA
1 year ago Place Report Server
2.9KViews
0likes
13Comments
Error refreshing datasource - "Unexpected number of disk files associated with database object."
Hey guys, We're using the latest release of the on-premise SSRS/Power BI server, and we recently got this error message we haven't seen before, and there's very little information via google and it seems to be related to SSAS, which I assume is part of the Power-BI components complaining. "Unexpected number of disk files associated with database object. Possible cause for that is missing or corrupt cryptokey.bin or detach.log file" Has anyone come across it and knows the next steps to diagnose and fix? Andrew
Solved
AndrewTobin
4 years ago Place Report Server
4.9KViews
0likes
2Comments
Error Token Comma expected.
I am trying to connect to a table in SQL Server Database in our dwh and when I do GetData and select my table from the list, it displays and when I click Load I get Error Token Comma expected. It does not matter what table I select. When I try to connect in PBI desktop it works fine but not in PBI RS and I have tried multiple tables. Please HELP
Solved
LynnG
4 years ago Place Report Server
10KViews
0likes
9Comments
Error message - DirectQuery
Hi all, I keep getting the below error when using directquery. This is the line of SQL it is referring to but I don't get any error messages / warnings when running it in SQL server? ,MAX(REPLACE(RIGHT([Event Recorded By], LEN([Event Recorded By])-13), '.',' ')) AS [Event Recorded By] Anyone come across this before and can help! TIA
Naverie
5 years ago Place Report Server
964Views
0likes
2Comments
error Error on Data load when open report in server "An error has occurred"
Hi, there are errorwhen I trying to open report it show up the message " An error has occurred. Something went wrong. Please try again later." like this =- Also, When I trying add new report to server got this error as well Does there any suggest to solve the problem?
Solved
Anonymous
6 years ago Place Report Server
1.3KViews
0likes
2Comments
Error On Data Load and Refresh
I am trying to do a refresh of my dataset on PowerBi Desktop but i keep getting this error below "OLE DB or ODBC error: [DataSource.Error] ERROR [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents." Worse still, it first tries to evaluate, then goes on to load some rows but stops after several minutes with the error above. How can i correct this?
Anonymous
6 years ago Place Report Server
551Views
0likes
0Comments