microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
297 stars 103 forks source link

We cannot apply operator < to types DateTime and Text #918

Open mithilmehta121287 opened 2 months ago

mithilmehta121287 commented 2 months ago

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" FinOps_Issue

flanakin commented 2 months ago

@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 commented 2 months ago

@flanakin, please check attached snapshot for this.

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

image

flanakin commented 2 months ago

@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 commented 2 months ago

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

image

flanakin commented 2 months ago

@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.