Forum Discussion
Leading zeros getting lost in dataflow
Somewhere these values are being changed to numbers and the leading zeros are dropping. They must be forced to be strings in the dataflow itself. If you let it detect the datatype when storing, it will use a numerical type.
No. On the DAX.Guide page there are notes that RELATED() isn't 100% functional with Direct Query tables, though it doesn't go into specifics, other than it needs a regular relationship vs a limited relationship.
I would advise you continue working with MS on the support ticket. You are beyond the normal use case here and may have found a bug or an undocumented limitation with RELATED(), and I assume RELATEDTABLE(), when using Direct Query against dataflows. I suspect this would work if your data was in a SQL Server, but cannot confirm.
Or, convert to import, as that is where Power BI and all of the DAX will work without limitation.
Alright. I will mark your first answer as the solution as it is related to the original question. Also changing the data type in the transformation is indeed what solved the original problem.
I guess I will just use Import Mode and try to streamline the refreshes with Power Automate instead. Also I'll continue working in the support ticket.
Thank you.