Forum Discussion
Dataset Error Column Not Found but PBI Desktop works
Hi
I am trying to schedulea web content PBI dashboard that works fine in my desktop PBI. The refresh shows no error but once I publish it and try to refresh the dataset I get this error that a column p2_onsitetime is not found. so I made a test to duplicate my PBI file and change the name. I removed all the code that manipulate the columns (change format, rename columns, calculate columns, etc) and now is just the pure code to push the data and when I publish it and try to refresh it now I get an error that another column is not found WOID. so this is an erratic behavior I want o believe it is a SW problem either not giving me the proper root cause or just a bug while fetching the columns.
I am using a script with web connects to fetch this data. Please can you help?
Processing error: The column 'WorkOrderID' of the table wasn't found.
Cluster URI: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID: e0d834d9-cfbd-449a-af84-8db541dc037e
Request ID: 56ff0d52-491f-f530-2f31-564fced9ab66
Time: 2022-07-28 15:44:59Z
13 Replies
needs more details. Is this on shared capacity or Premium? If Premium, did you update the app?
Hi I don't know if my account is premium or capacity but I know this issue is something strange. Now I made a New file without any using the first row as headers and that worked. It is not my code and It is not the column as in my powerbi desktop works with or without file manipulation.
hi now it is even worse. now the refresh doesn't show anything. I thought something was wrong with my dataset or maybe there was no activity as it is the weekend so I jumped into my laptop to check my PBI desktop and there was data after the refresh. then I decided to download a copy of the dataset to see what I can find out with my PBI desktop and surprise, the dataset works fine in my desktop. Something is not linking my query but without errors and erratic behavior I cannot tell. is there a way to debug my dataset refresh in the PBI service?
PBI service
PBI desktop
In the Power BI Service you can hover over the visuals and check the filter icon. Most likely you have a date filter there that is preventing data from being shown.
