Forum Discussion
Date as Request Header in API
It is not the date format that is causing the issue. Its the header (such as column header) .
For example Date = Sun, 05 May 2024 02:55:55 GMT - this is the format mentioned in API documentation.
The format for date i have is correct but when i use the name "Date" the M query is returning errors.
Error that i am getting is below
Try without the space. I don't think that is the right date format, btw.
Power BI Access this date format without any issue. Please refer to this link below
Representation of date/time values in headers (REST API) - Azure Storage | Microsoft Learn
Also according to the API Documentation this is what i have
Its the name of the Header that is causing the issue. You cant directly just write "Date" in M Query. But according the API documentation this is what it should be. Looking for some workaround here
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .