An error occurred in the ‘ftk_LoadData’ query. DataFormat.Error: We couldn't parse the input provided as a Date value.

[elvismangarae]

🐛 Problem

When trying to connect via the FinOps hubs data source in CostSummary report, unable to load the data with below error:
An error occurred in the ‘ftk_LoadData’ query. DataFormat.Error: We couldn't parse the input provided as a Date value.

👣 Repro steps

1. Create export at subscription scope
2. name export amortizesubscription and run
3. Update CostSummary report with correct storage Url: https://storageexamplename.dfs.core.windows.net/ingestion
4. Apply

🤔 Expected

No error, data loads

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

[erincon01]

Hello.

I had the same issue. I am not good at Power Query, so I commented the section with errors.
The issue is in the ftk_LoadData function in Power Query.
Scroll to the section where applies the filter and remove it.
I just hardcoded as you see below:

                // Only pull from the predefined date range (if specified)

               tbl = RemovedContent,
                // ERINCON@VERNEIT.COM --> remove filter because it failed
                FilterRowsByDate = tbl
                // FilterRowsByDate = 
                //     if start = null and end = null then tbl
                //     else Table.SelectRows(tbl, each 
                //         (start = null or (if Table.HasColumns(tbl, "Date") then Date.From([Date]) else Date.From([date])) >= Date.From(start)) 
                //         and (end = null or (if Table.HasColumns(tbl, "Date") then Date.From([Date]) else Date.From([date])) < Date.From(end))
                //     )

[erincon01]

If you change the Date column name to date (in lowercase), you will fix the issue. There are 4 occurrences. There is no need to comment the code, just change that section.

[flanakin]

Thanks for sharing, @erincon01! This has been fixed in 0.2. Stand by for the next release.

[allcontributors]

@flanakin

I've put up a pull request to add @elvismangarae! 🎉

[flanakin]

@allcontributors please add @erincon01 for question

[allcontributors]

@flanakin

I've put up a pull request to add @erincon01! 🎉

[flanakin]

This error has been fixed in the 0.2 release. Thanks again for reporting. Please let us know if you run into anything else!

https://aka.ms/ftk/latest