The query referenced column ****** which depends on another column

[Otavio_bhz]

Hi all,

I have updated done my query in power bi destop and worked well.

But when I upload that, works well to, but when I update from the web, it appear the foollowing message:

The query referenced column ******** which depends on another column, relationship or measure that is not in a valid state.

Does someone know why that is happening ?

- Power bi destop ok and update (ok)

- Power bi web after upload (ok)

- Power bi after update (Appear that problem)

Thank you very much,

KR

Otavio

[pavel_rudenko]

Same situation to me:

- power bi desktop tables/visual browsing - OK

- power bi desktop manual refresh - OK

- power bi desktop deploy to power bi service - OK

- power bi service report brows - OK

- power bi service publish to sharepoint online - OK

- power bi service set refresh schedule - OK

- once refreshed - CRASHED in power bi service and sharepoint

config is pretty much simple:

- two tables from sharepoint online list (users title and some dates)

- one table Calendat - to have all dates for some period

- one intermediate table to produce working days per month and calculate working days spent by concultants

- final reporting table (consultant name, working days in month, actual worked days in month, month workload)

visual throws an error:

Couldn't load the data for this visual

The query referenced calculated table 'ReportingData' which depends on another column, table, relationship or measure that is not in a valid state.

Please try again later or contact support. If you contact support, please provide these details.

• Activity ID8921f0a4-d8da-4c07-9929-487d2419cae7
• Request IDecaead5a-818f-eb79-ab10-967dfb52e6eb
• Correlation ID2da96bb2-b71b-16f7-5121-a5a5b9ca3998
• TimeThu Apr 09 2020 02:44:16 GMT+0300 (Eastern European Summer Time)
• Service version13.0.12739.219
• Client version2003.3.022
• Cluster URIhttps://WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net

tried to get all fields - decimal and type number - no help.

Please, sugest some possible solution - need to publish report to SPO and been able to refresh it ASAP.

Thanks all in advance

[Anonymous]

Having same problem here. PBI Desktop working fine; publishing works fine. When updating through web, crashes a few visualizations. Can somebody help? Thanks in advance.

[andrezmor]

Having the same problem here. I am working in power BI Report server, I have been troubleshooting the problem by eliminating some relationships and measures but still get the same behaviour. Everything works fine in PBI Desktop but after uploading to server and first update, all the visual crashed.