Comment on Data Flows with null in boolean by Data Flows with null in boolean | 365 Community


This article discusses an issue with null values in boolean columns when using Data Flows in the Power Platform. The author encountered generic errors when trying to publish a data flow that pulled data from a datalake synchronized with Azure Synapse Link. After troubleshooting, they discovered that the issue was caused by null values in boolean columns. The author fixed the problem by replacing the null values with false using Power Query/M. The article provides an example of the code used to replace the values. Overall, the article serves as a troubleshooting guide for dealing with null values in boolean columns in Data Flows.


Article 22m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time