User Profile
DatamirHub
Advocate I
Joined 1 year ago
User Widgets
Contributions
Getting data from Snowflake to Excel
Hello I have multiple no technical users and am trying to find a way to setup a snowflake query for them and then let them refresh it whenever they want or on a schedule, but I couldn't find a good solution this what i found so far: ODBC (Not great for non technical users needs setup on each user desktop) Power Automate (Needs Power Automate Premium which we don't have) Third Party tools (Expensive pricing models) Through Power BI (We want to separate this process from power bi) Any suggested solution please!Solved785Views1like2CommentsRe: Power BI Desktop Snowflake Refresh Fails: “Cannot Convert Null to Text” While Service Still Work
I have the same issue here https://community.fabric.microsoft.com/t5/Desktop/Snowflake-Key-Pair-Authentication-not-working-on-the-Power-BI/m-p/5205978 and i just reverted to the version of May and works fine585Views0likes0CommentsSnowflake Key Pair Authentication not working on the Power BI (June Version)
Snowflake Key Pair Authentication not working on the Power BI (June Version) 21 seconds ago I just had an issue authenticating my Power Queries to Snowflake. After a lot of investigation, I found out that the issue is in the new Power BI version of June. Version: 2.155.756.0 64-bit (June 2026) I reverted to version 2.154.1260.0 64-bit (May 2026), and everything is working fine Please help me raise this to the Power BI Dev team692Views1like4CommentsRe: Filter with union instead of intersection Issue
Thanks for replying I read the solution you provided but its very similar to what i have above which can be very consuming to the performance in tables can you please let me know whats the difference between your provided approach and my first solution above ?828Views0likes0CommentsFilter with union instead of intersection Issue
I have two slicers in Power BI, and my goal is for them to behave as a union, not an intersection. For example: Slicer A returns 10 people When I select a value in Slicer B, I want it to add to the result So the total should become 12 people, not less than 10 I understand that this behavior is not supported natively in Power BI, since slicers always intersect filters. Because of that, I created a filter measure that simulates a union and then used this measure to filter visuals. This approach: Works perfectly for card visuals Fails for table visuals For tables, it becomes extremely slow and eventually fails. This makes sense because: The filter measure is evaluated row by row For each row, the measure re-evaluates all filter logic again I tried two different approaches (see below). Both are logically correct and give the expected results, but both are very slow when applied to a table. My question is: Is there a better or more efficient approach to achieve a union-style slicer behavior in Power BI without the performance issues caused by row-level filter measures on tables? Codes Solution 1: _SHOW_ROW_FILTER_UNION = VAR Filter1Applied = ISFILTERED ( filter_1_table[source_type] ) || ISFILTERED ( filter_1_table[level_1] ) || ISFILTERED ( filter_1_table[level_2] ) || ISFILTERED ( filter_1_table[level_3] ) VAR Filter2Applied = ISFILTERED ( filter_2_table[category] ) || ISFILTERED ( filter_2_table[sub_category] ) || ISFILTERED ( filter_2_table[sub_sub_category] ) VAR CurrentPerson = SELECTEDVALUE ( fact_table[person_id] ) RETURN IF ( NOT Filter1Applied && NOT Filter2Applied, 1, IF ( Filter1Applied && NOT Filter2Applied && CurrentPerson IN VALUES ( filter_1_table[person_id] ), 1, IF ( Filter2Applied && NOT Filter1Applied && CurrentPerson IN VALUES ( filter_2_table[person_id] ), 1, IF ( Filter1Applied && Filter2Applied && ( CurrentPerson IN VALUES ( filter_1_table[person_id] ) || CurrentPerson IN VALUES ( filter_2_table[person_id] ) ), 1, 0 ) ) ) ) Solution 2: _SHOW_ROW_FILTER_UNION = VAR Filter1Applied = ISCROSSFILTERED ( filter_1_table ) VAR Filter2Applied = ISCROSSFILTERED ( filter_2_table ) VAR Filter1Persons = FILTER ( DISTINCT ( filter_1_table[person_id] ), Filter1Applied ) VAR Filter2Persons = FILTER ( DISTINCT ( filter_2_table[person_id] ), Filter2Applied ) VAR UnionPersons = DISTINCT ( UNION ( Filter1Persons, Filter2Persons ) ) VAR CurrentPerson = SELECTEDVALUE ( fact_table[person_id] ) RETURN IF ( NOT Filter1Applied && NOT Filter2Applied, 1, IF ( CONTAINS ( UnionPersons, [person_id], CurrentPerson ), 1, 0 ) )Solved847Views0likes7Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.