The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
21 | |
20 | |
16 | |
13 |