[fusion_builder_container type=”flex” hundred_percent=”no” hundred_percent_height=”no” min_height=”” hundred_percent_height_scroll=”no” align_content=”stretch” flex_align_items=”flex-start” flex_justify_content=”flex-start” flex_column_spacing=”” hundred_percent_height_center_content=”yes” equal_height_columns=”no” container_tag=”div” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” link_color=”” link_hover_color=”” border_sizes=”” border_sizes_top=”” border_sizes_right=”” border_sizes_bottom=”” border_sizes_left=”” border_color=”” border_style=”solid” spacing_medium=”” margin_top_medium=”” margin_bottom_medium=”” spacing_small=”” margin_top_small=”” margin_bottom_small=”” margin_top=”” margin_bottom=”” padding_dimensions_medium=”” padding_top_medium=”” padding_right_medium=”” padding_bottom_medium=”” padding_left_medium=”” padding_dimensions_small=”” padding_top_small=”” padding_right_small=”” padding_bottom_small=”” padding_left_small=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” box_shadow=”no” box_shadow_vertical=”” box_shadow_horizontal=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” z_index=”” overflow=”” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_blend_mode=”none” video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” absolute=”off” absolute_devices=”small,medium,large” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” sticky_background_color=”” sticky_height=”” sticky_offset=”” sticky_transition_offset=”0″ scroll_offset=”0″ animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ align_self=”auto” content_layout=”column” align_content=”flex-start” content_wrap=”wrap” spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” type_medium=”” type_small=”” order_medium=”0″ order_small=”0″ dimension_spacing_medium=”” dimension_spacing_small=”” dimension_spacing=”” dimension_margin_medium=”” dimension_margin_small=”” margin_top=”” margin_bottom=”” padding_medium=”” padding_small=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” hover_type=”none” border_sizes=”” border_color=”” border_style=”solid” border_radius=”” box_shadow=”no” dimension_box_shadow=”” box_shadow_blur=”0″ box_shadow_spread=”0″ box_shadow_color=”” box_shadow_style=”” background_type=”single” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” background_blend_mode=”none” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=”” filter_type=”regular” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″ last=”true” border_position=”all” first=”true”][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” font_size=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” line_height=”” letter_spacing=”” text_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]

Join us live as we answer your questions about Power BI!

πŸ“’ Become a member: https://guyinacu.be/membership

[/fusion_text][fusion_title title_type=”text” rotation_effect=”bounceIn” display_time=”1200″ highlight_effect=”circle” loop_animation=”off” highlight_width=”9″ highlight_top_margin=”0″ before_text=”” rotation_text=”” highlight_text=”” after_text=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” content_align_medium=”” content_align_small=”” content_align=”center” size=”2″ font_size=”” animated_font_size=”” fusion_font_family_title_font=”” fusion_font_variant_title_font=”” line_height=”” letter_spacing=”” text_shadow=”no” text_shadow_vertical=”” text_shadow_horizontal=”” text_shadow_blur=”0″ text_shadow_color=”” margin_top_medium=”” margin_bottom_medium=”” margin_top_small=”” margin_bottom_small=”” margin_top=”” margin_bottom=”” margin_top_mobile=”” margin_bottom_mobile=”” text_color=”” animated_text_color=”” highlight_color=”” style_type=”default” sep_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]

Questions answered on stream

[/fusion_title][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” font_size=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” line_height=”” letter_spacing=”” text_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]

Q: In a Composite Model, can DAX Studio clear the cache from the source or only the localhost? (14:44)

Q: I have 3 tables in my model. Sales, Dates and TimeSelector. I have This Year Sales and Last Year Sales ( used Dateadd with -364 ) as Measures. TimeSelector to Dates is one to many with bi-direction. When I use Time Selector my LY values don’t appear anymore. How can I fix this? (16:24)

Q: There are rumors about object-level-security coming to PBI Pro very soon. True? (19:10)

Q: what is the best way to make Week No. in calendar table in Europe. If you do it in Power Query with Date.WeekOfYear then it’s week 2 right now. But in Europe we say it’s week 1. (20:49)

Q: I have a facts table and calendar t – which date field should I use in a slicer? when I use the one from calendar it shows all available dates and in facts table I just have monthly observations (22:33)

Q: please share some useful links related to power apps for learning purpose (24:20)

Q: What is the best practice to deal with circular relationships (loops) in Power BI? (25:19)

Q: Any idea when would Power platform release note 2021-22 would release..? (28:08)

Q: What are the exciting BIG features that you guys are looking forward in 2021? (29:04)

Q: Creating a new measure on my model (compressed size 50mb) takes some time to load. Short of ‘it depends’, what are the biggest bottlenecks? (#measures, #tables, relationships/schema etc etc?) (30:29)

Q: To calculate turnover, I expanded the dates between dates in ‘start’ and ‘termination’ columns. This works, but since it creates millions of extra rows it feels inefficient. Optimization ideas? (36:13)

Q: Adding new column in ‘DQ over AS’ seems like a DAX operation by using DEFINE COLUMN. So, technically shouldn’t this functionality be allowed directly in live connection as well? (38:46)

Q: Do you guys have a follow up on our comments about the future direction of GIAC? From the last video of last year? (41:11)

Q: What is your favorite feature release of 2021 thus far and why is it dataflows Query Folding visual indicators? (42:19)

Q: I’m looking for an overview of users that used the ‘Opt-In’ experience for PPU. So not those that had the license assigned by an admin, but the ones that did it themselves in the PBI Service. (45:24)

Q: I am trying to change colors of a bar chart for Red/Yellow/Green indicators based on percentage. (47:40)

Q: Would like to use RLS on dataflows but it’s not possible. Users should only see their countries offices. (51:38)

Q: Why do you trace models with Profiler and not with Extended events? (55:33)
Q: A user change a column type from Text to date in desktop composite model, so it converted to a date. Is there any way to fix the change? Going back to text didn’t fix it. (57:19)

Q: I understand Tabular Editor is going to paid subscription in 2021 in latest version. Will prior free version continue to work? (Some workplaces need to approve such spending; also do we know cost?) (59:03)
Q: what was your favorite gift (given or received) from the recent holiday season? (1:00:17)

Q: When I publish a pbix file sometimes it creates a new data set with the same name as existing data set. why is that? (1:01:54)

Q: any plans in doing more M / Power Query and Data Modeling videos this year? (1:03:00)

Q: I am receiving a couldn’t load the data for this visual error on a card visual The function SUM cannot work with values of a string. Any ideas? (1:08:27)

Q: With Tabular models using modern data source (aka power query) is there a way to kinda schema compare to data source for scenario where different team members working on db dev and model dev. (1:09:39)

[/fusion_text][fusion_title title_type=”text” rotation_effect=”bounceIn” display_time=”1200″ highlight_effect=”circle” loop_animation=”off” highlight_width=”9″ highlight_top_margin=”0″ before_text=”” rotation_text=”” highlight_text=”” after_text=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” content_align_medium=”” content_align_small=”” content_align=”center” size=”2″ font_size=”” animated_font_size=”” fusion_font_family_title_font=”” fusion_font_variant_title_font=”” line_height=”” letter_spacing=”” text_shadow=”no” text_shadow_vertical=”” text_shadow_horizontal=”” text_shadow_blur=”0″ text_shadow_color=”” margin_top_medium=”” margin_bottom_medium=”” margin_top_small=”” margin_bottom_small=”” margin_top=”” margin_bottom=”” margin_top_mobile=”” margin_bottom_mobile=”” text_color=”” animated_text_color=”” highlight_color=”” style_type=”default” sep_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]

Other questions asked

[/fusion_title][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”default” rule_size=”” rule_color=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” font_size=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” line_height=”” letter_spacing=”” text_color=”” animation_type=”” animation_direction=”left” animation_speed=”0.3″ animation_offset=””]

Q: Why Power Query’s user interface doesn’t allow you to set type table? Same for parameter type.

Q: When I connect to a PBI dataset in PBIX. Does that bypass an existing RLS? So I can see all the data in PBIX although I am not allowed? Can anybody do so who has access to the dataset?

Q: How to get measures into a slicer?

Q: Can you talk about the OLS feature that will be released in February?

Q: When turning on Gen 2…download pbix is greyed out. Is this a known issue or something local? fix?

Q: Would RLS works with DirectQuery?

Q: Based on user / condition certain pages to be displayed. user 1 should see report 1 & user should see report 2 based on certain conditions.

Q: In Power Query what are some use cases for using Python instead of using M code?

Q: Is there a translator from M language to SQL?

Q: Please share some useful links related to Power Apps

Q: Is there any improvement in the dashboard mobile view coming soon?

Q: Conversion of UTC time to local time works fine in PBI Desktop. But does not work on PBI service. Any idea why? How to fix it?

Q: What are the best practices when working with data in weekly ISO 8601?

Q: Do you have any recommendations for documenting and maintaining the documentation of Measures & Calc Columns when we have many individual pbix?

Q: I have a measure and a calculation group which shows YOY for CY, LY, and LLY. I wish to create a slicer \ button which if I press changes from YOY to MOM (Month, Month-1, Month-2). Any Ideas?

Q: Any page level security in same report? certain pages to be restricted based on user / condition

Q: What workspace setting (Large Dataset Format) does internally? and how much it can grow the model size in PBI Premium?

Q: My data model has YYMonth & YY-WK periods no date column can you help how to i.) Create a forecast value for future periods ii) how do i show current week and Month Highlighted when user drilldown?

Q: Does PBI support working with date format YYYYWW with weeks in ISO8601 format? Any tips?

Q: how can we Connect Power BI dataset from SQL Server?

Q: Is Sort by Columns in composite model still broken?

Q: Which open-source programming language do you guys prefer…. Python or R?

Q: any thoughts/update on timing for deployment pipelines extending to support dataflows?

Q: have you ever created a 2nd slicer displaying values not selected in 1st slicer?

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]