Hi guys, I have one of the weirdest issues. I am trying to connect the dataflow with my Salesforce and then datamart connected with dataflow: Salesforce -> dataflow -> datamart.
The actual value of the Active__c column in Salesforce is FALSE against a record. The value in the same column against same record in dataflow also matches with Salesforce i.e. FALSE. However, whenever I try to connect Datamart with Dataflow, the datamart will show TRUE for some reasons. No matter how many times I refresh dataflow or datamart, or create a new datamart, the value in datamart always remains TRUE. How do I solve this?
Dataflow:
Datamart:
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
