The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi!
Does anyone know how to force a variable to enter as logical (True/False) on data load?
Thanks!
You can set the datatype of a column in Power Query.
Thanks for the reply, I mean that the variable already enters with that type without having to change it.
Thanks.
That would depend on your source, but I think if it returns true and false as text values, rather than 1 and 0 for example, it should get picked up automatically.