Forum Discussion
The query referenced column ****** which depends on another column
Hi All,
I could solve the issue with the Power Bi update via WEB update.
The problem was that on desktop, if you use int values on imported files those “variables” works fine.
But when you upload that and update, the web system don’t understand as int, and the problem come when you use related() and calculation.
Then I have changed all the columns from integer to number % and everything is fine now on the Web.
Thank you very much for your help,
Kr,
Otávio
Microsoft Employee
What kind of update you have made on Power BI Service?
If the error message mentioned a LocaDateTime column, it might be the date type or "out of bound" issue. Please refer to similar threads below:
Regards,
Hi,
It is not related to date hierachy.
I don't know what could be happening.
Someone have some guess ?
Thank you very much,
KR,
Otavio
Hi All,
I could solve the issue with the Power Bi update via WEB update.
The problem was that on desktop, if you use int values on imported files those “variables” works fine.
But when you upload that and update, the web system don’t understand as int, and the problem come when you use related() and calculation.
Then I have changed all the columns from integer to number % and everything is fine now on the Web.
Thank you very much for your help,
Kr,
Otávio
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
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.
Waht the Hack. It realy worked to replace all integer Date-Types in my Calendar Table. Thank you very very much.
What a horrible expierience, thank you MS.
Otavio_bhz i am using M query and incremental refresh in my report and I am facing a similar issue. Are you proposing to that I change all my columns with data type "decimal number" to "percentage" ?
