Forum Discussion
Getting error after publishing the report using direct query.
Getting error after publishing the report using direct query.
Error :
Found illegal OLE automation date when processing column 'DATE_SHIPPED' of table 'AMZL', please check if there is invalid datetime format in the datasource.
Earlier it was in date & time format it was giving me the same error. Now I changed that to text format still it is the same.
When I refresh the same report manually it works there , but when I publish it gives me above error. Please help
Anonymous
As the message said you have invalid date format, can you show the screen shot of you date column? I guess it is because the date hierarchy.Using DirectQuery in Power BI - Power BI | Microsoft Docs
- No built-in date hierarchy: When importing data, every date/datetime column will also have a built-in date hierarchy available by default. For example, if importing a table of sales orders including a column OrderDate, then upon using OrderDate in a visual, it will be possible to choose the appropriate level (year, month, day) to use. This built-in date hierarchy isn't available when using DirectQuery. If there's a Date table available in the underlying source, as is common in many data warehouses, then the DAX Time Intelligence functions can be used as normal."
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous
As the message said you have invalid date format, can you show the screen shot of you date column? I guess it is because the date hierarchy.Using DirectQuery in Power BI - Power BI | Microsoft Docs
- No built-in date hierarchy: When importing data, every date/datetime column will also have a built-in date hierarchy available by default. For example, if importing a table of sales orders including a column OrderDate, then upon using OrderDate in a visual, it will be possible to choose the appropriate level (year, month, day) to use. This built-in date hierarchy isn't available when using DirectQuery. If there's a Date table available in the underlying source, as is common in many data warehouses, then the DAX Time Intelligence functions can be used as normal."
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.