Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I've a table from my sql dedicated pool in Azure Synapse (SQL Server 12) with all the version of applications in our server, date and obsolence (boolean).
The "Obsolescense" field is declared as BIT in my DDL and my report reads from this table.
The problem is that when I check the numbers from sql queries
select count(*) from applications_table where obsoleted = 0 /1
and the measure in dax which I use :
"They don't match." - Are you getting errors or is the value mismatched by a certain amount? I think we need to find that out first.
Is the data imported?
Can you show us a picture of the data view in powerbi with the column selected? Maybe also one from Power Query ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |