Forum Discussion
we cannot replace value null to type text
thanks, I tried both of these approached and neither worked.
Anonymous , Are you able to attached your pbix with the data source?
I don't think I can share the data.
the problem occurs as soon as I pivot
= Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Status]), "Status", "Count")
If I extract the data to a CSV and perform the same series of steps it works fine. but not on my OData source.
Anonymous that's interesting. You should open a support ticket. I hardly uses/had a chance to use ODAta so cannot help much but this seems to be a bug that it works with one type of data but not other. good luck and post your solution here so that it can help others.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
