error handling
3 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 special783Views0likes2CommentsIO 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.8KViews0likes4Comments