Forum Discussion
Date as Request Header in API
Can you show the header for the successful Postman request? Maybe the date format is expected to be in ISO-8601.
- this_is_pk2 years agoRegular Visitor
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
- lbendlin2 years agoSuper User
Try without the space. I don't think that is the right date format, btw.
- this_is_pk2 years agoRegular Visitor
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