error handling
5 TopicsEvaluation of one of the rows caused an error (desktop OK)
Hello everyone! Could I get some help with the situation bellow: I have two Power BI reports, from different data models. -On report 1, I have a table of company stock by reference, also has the last movement for each material. -On report 2, I have a table for purchase orders by material. Both reports have updated data Now, I want to know in the purchase orders table the latest movement (if the material is in the stock table. If not, blank). For that, I have created a table using SUMMARIZE that contains only the material and last movement date. The table has no errors. I am importing this table to model 2 (direct query from power bi data model). I can see in model 2 no errors related to this table. I can see the data fine both desktop and online. No repeated references. Finally, I have created a column on the purchase orders table with the date. I have tried with both LOOKUPVALUE and MAXIMUM. In both cases, it works well on the desktop and crashes online with the error: "evaluation of one of the rows caused an error", referring to this column. Because I am going crazy, I have tried to import to model 2 directly the full stock table (was avoiding to reduce storage and duplicity). I get the same error. Thank you so much in advance!Solved859Views0likes3CommentsProblems to show images in paginated report
I am trying to show some images in the body report but, nothing is happening, as can you see the column D from the screenshot, it is only showing the code, I am resolving the column from the data base, on the other hand I did add an Image object to the body and setup it as Database source, see figure two, you can notice that it has being showing without problems, can you guys advice me about the best way to solve this issue, also I drag and drop the image column to the body, nothing special785Views0likes2Commentstime intelligence quick measure problem
I have been having a significant issue with time intelligence quick measure function which I can't seem to find a way to fix . I have been continuously getting that error saying " time intelligence quick measure can only be grouped or filtered by the power bi provided date hierarchy or primary date column" despite my date on date dimension is set up in a hierarchy . autodate function in the power bi main option was already on. I have tried a few things after googling 1. tried to set the date dimension table as " mark as date table" and nominated the " date" column to be the date. however this screwed up all my visualisations and I had to start from the beginning basically. 2. I tried to make a new table with a date, year,month and day all in separate column with hiearachy and created a relationship with the sale fact table to see if that worked and the visualisation just looked weird . It didn't seem to make sense. I am not sure what I am doing wrong 😞 Would really appreciate if someone could help!3.1KViews0likes5CommentsIO Error '6' when schedule refresh
Hello Everyone, Good Day! I keep on getting IO error '6' while schedule a refresh in report server. I can refresh using Power BI desktop without any issue. But when it comes to report server, the report may or may not refresh and when it failed it will definitely show IO error '6'. The error happened intermittent, anyone know what is IO error '6' about and what should I do to avoid this error? SessionID: 2dd0ba01-6f91-48c0-b0b0-b8957f043d4b [0] -1055784932: We got the IO error '6' while trying to access the path '\\SAMPLEFOLDER\*'.. The exception was raised by the IDbCommand interface. [1] -1055784934: The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. [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.1.8KViews0likes4CommentsCan't schedule refresh due to cannot find file with a file error handling
I've published a PowerBI file that is working on my desktop refreshing the data etc. but when i published it's not letting me refresh because it can't find the files. I'm getting my files from a folder path (csv) and from a database. The issue is, i've already accounted the missing files with a file error handler ,that if a file is missing or is not present on a folder, it will get data from a table. which is working fine if i do it on desktop. (see below) So trying to refresh will give me an error on the workspace Dataset settings. Has anyone encountered this issue? any suggestions to resolve this? thank you932Views0likes1Comment