We cannot apply operator < to types DateTime and Text

[mithilmehta121287]

We already extracted the data using FinOps but Date is coming as yyyy-MM-ddTHH:mm:ssZ Format which is not recognized by Power BI Report, and Power BI is throwing error "We cannot apply operator < to types DateTime and Text"

[flanakin]

@mithilmehta121287 Can you share your storage URL without the storage account name? I have a feeling this is about the file path rather than the date format but that's just a guess.

[mithilmehta121287]

@flanakin, please check attached snapshot for this.

Storage URL: https://storage_name.dfs.core.windows.net/ingestion

[flanakin]

@mithilmehta121287 Can you share what your ingestion folder path looks like for the parquet files? I'm thinking there's an issue there. If not, we should setup some time to go over this together on a call.

#needs-info

[mithilmehta121287]

@flanakin, please check below ingestion path for Parquet file. Please provide me your availability to go over with details.

[flanakin]

@mithilmehta121287, thanks for the extra details. This all looks perfect. I'm not sure what the issue could be. Can you email ftk-support@ms so we can setup some time to chat in person? I also just responded to a message from Ifeoma, who I believe you're working with. She might be in a better spot to help us coordinate a little quicker.

One other thought: Can you share the values you have in RangeStart and RangeEnd? I'm not sure that would be an issue, but checking just in case, since it is a date value that's getting parsed.