Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have this error code when I publish my power bi desktop report to the web workspace.
Error code:" The query referenced column 'LocalDateTable_3dcabea0-fe0e-4c98-8b6e-01a7916b0f88'[Day] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''
It shows the btm right graph on desktop version, but it could not load data on the web version.
Desktop Version:
Web Version:
Please share your thoughts, thank you
Hi, which exact dependencies should I check on? There are a lot of columns
You should look at the LocalDateTable_3dcabea0-fe0e-4c98-8b6e-01a7916b0f88'[Day] column, or the column of the visual which is not available in the visual.
Hello @anonymous1124 , as @jennratten suggestted, query dependencies can help a lot in Power Query. I'll also recomment ensuring a refresh preview in power query and a refresh in dekstop ensuring you get the data you are expecting.
I recommend checking the dependencies for the field used in the visual to locate the problem. Sometimes things appear a little differently in desktop vs. online and there can be several reasons for this. Tracing the dependencies should resolve the issue though.
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User
User | Count |
---|---|
8 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
14 | |
13 | |
8 | |
6 | |
6 |