Forum Discussion
Odata with UNIX date in column headers creating error upon refresh
Hi All, I have a powerBI file that searches its content via Odata. All nice but for some reason the Odata column names sometimes contain UNIX date values ie: ABC_1577750400. And these collumns ar...
Hi DBNN ,
After you rename it, have you close and apply it in power query?
If applies but still not works, you could try to publish a copy of this pbix file after Disable the "Auto Date/Time" option for it. Please test it with an extra copy of your pbix file.
If it still has the same issue, perhaps the best workaround may be like your mentioned before, although it would be complex.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the help but it does not seem to help. When I refresh the query it blocks and tells me that column with the UNIX date is not found. Am back to my workaround 🙂