User Profile
RobWalker
New Member
Joined 3 years ago
User Widgets
Contributions
Re: Access to Snowflake via key pair authentication
Any update on Key Value Pairs for PBI/Snowflake This was the update from Chris Webb on Dec 7, 2023 where he was collaborating with MS and Snowflake, noting support for KV Pairs? Strong Authentication: Snowflake recently announced plans to deprecate single-factor password authentication (see the timeline). Power BI already supports External OAuth for connecting to Snowflake (more on this here). Snowflake continues to work diligently with Microsoft to add additional strong authentication options between Power BI and Snowflake, which we expect to be released throughout 2025, including support for key-pair (although we already see many Power BI customers using programmatic access tokens for authentication).18KViews1like0CommentsRe: Handling different dimensional granularities in Power BI
Thanks Alex, thats a great solution. So effectively ignore the month key concept and just focus on first day or last day of month as the month key proxy. It does highlight a flaw in my rather simple example though. If i change the scenario slightly: I have a fact table at the granularity of product id and i link this to the product dimension at the same level of granularity (product id) that works again like calendar date would. But if i have a fact table at the level of product parent category and i link it product dimension, how should that be handled? Unlike date i don't have first or last function to use in that scenario. Many thanks Rob1.1KViews0likes0CommentsHandling different dimensional granularities in Power BI
Hi all, A general modelling problem and would just like to understand how this is commonly approached in Power BI. As an example, I have a sales fact table and to keep it simple it just has a sales amount and a date. The date key joins to a calendar dimension that has the granularity of day. All good. However, if i have another fact table that is the level of month key and i join this to the same calendar dimension i presume i will get double counting i.e. month key multipled the days in a month? Do i just need to create another calendar dimension that is aggregated to month instead of day and join to that or is there another technique that should be applied instead? Without naming them, another vendor has a solution where the dimension table will group itself up to the appropriate granularity first and then do the join but i can't see an equivalent in Power BI or am i missing something? Any advice on how you would approach this? Many thanks1.2KViews0likes2Comments
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.