Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have an issue with table refresh, I get null value is eliminated by an aggregate or other set operation warning.
This prevents the table from refresh. It's connected to SQL view, therefore I cannot ad SET anywhere in the code (or at least I think so, it won't let me save the view).
I tried ISNULL for the numeric columns, with no luck.
What's more, the view that is connected to PBI does not have any sum/avg/min/max/count function.
The only 'extraordinary' thing is COLLATE.
I'd be really grateful for any input, thanks!
Hi @Anonymous ,
According to your description, this problem should occurs at the SQL Server end, we can check SQL Server error message and create a trace to find what has caused this problem.
Please check if you have the aggregate function in the view, for SQL Server view, it will be executed every time the view be called. Based on my experience, if you have the aggregate function in the view, and use some sort function like TOP N, some null data may be not included, but when we set different collection at the client, the null data will cause the problem.
Best Regards,
Teige
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |