Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 3 calculated columns in an imported table that gets data from live dataset in direct query mode.
DateIn = CALCULATE( MIN ( InOutOData[DateFrom] ), FILTER( InOutOData, InOutOData[SKUCode] = 'SKU Forecast'[SKU Code] && InOutOData[Status] = "INTRODUCTION"))
DateOut = CALCULATE( MIN ( InOutOData[DateFrom] ), FILTER( InOutOData, InOutOData[SKUCode] = 'SKU Forecast'[SKU Code] && InOutOData[Status] = "OUT"))
Test =
IF( 'SKU Forecast'[Week Start Date] > 'SKU Forecast'[DateIn] && 'SKU Forecast'[Week Start Date] <= 'SKU Forecast'[DateOut], "IN", "OUT")
This works in Desktop with values and visuals working correctly, but after web refresh of the live connected dataset, the report breaks down with the following error,
I couldn't understand what the problem here is, it is a simple calculation. Some things to note here, datein and dateout are of dtpye date with null values in them. Test is of type text. Any ideas what's going on here?
Hi @balaganeshmohan ,
This error may be caused if the column type of [Test] couldn't be understood by your web system. Check the type of this column.
It might be the date type or "out of bound" issue. Refer to this document to check the limitations of direct connection mode .
Please check the version of your Power BI desktop, if it is not the latest verison, update it in web and publish your report again.
You can refer to the following posts that may be helpful to you:
Solved: The query referenced column ****** which depends o... - Microsoft Power BI Community
Solved: On calculated field, using the date hierarchy caus... - Microsoft Power BI Community
Solved: Date Hierarchy - couldn't load the data for this v... - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry None of that seems to be helping, I tried changing the datatype of the calculated columns to Text and still end up with the same problem!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |