Kqlmagic bug report #475d7641-83a9-4804-8ed4-8368fa5a7e10

[ianhelle]

Please copy the bug report from the notebook and paste it to the template below

BEFORE YOU SUBMIT IT, MAKE SURE THAT ANY SENSITIVE INFORMATION IS OBFUSCATED

Installed KqlmagicCustom with [jupyter-basic] extra. Environment variable KQLMAGIC_EXTRAS_REQUIRES, set to "jupyter-basic" Expected no warnings about missing imports but got these:

Please wait. Loading Kqlmagic extension...

ImportWarning: failed to import 'pyperclip' from 'pyperclip', copy/paste feature will be disabled in device code authentication
ImportWarning: failed to import 'plotly' from 'plotly', won't display charts with plotly
ImportWarning: failed to import 'plotly.graph_objs' from 'plotly', won't display charts with plotly
MissingEnvironmentVariable: KQLMAGIC_AZUREML_COMPUTE is not set. Popup windows might not work properly (copy/paste compute host value from the address bar of the notebook when activated in azureml Jupyter mode)

{
    "Kqlmagic_last_execution": null,
    "kqlmagic": {
        "version": "0.1.114.dev25"
    },
    "kqlmagic_connections:": {},
    "kqlmagic_default_env": {
        "KQLMAGIC_CONFIGURATION": "try_azcli_login=True",
        "KQLMAGIC_EXTRAS_REQUIRES": "jupyter-basic",
        "KQLMAGIC_LOAD_MODE": "silent"
    },
    "kqlmagic_default_options": {
        "add_kql_ref_to_help": true,
        "add_schema_to_help": true,
        "allow_single_line_cell": true,
        "assign_var": null,
        "auth_token_warnings": false,
        "auto_dataframe": false,
        "auto_limit": 0,
        "auto_popup_schema": true,
        "cache": null,
        "cache_folder_name": "cache_files",
        "check_magic_version": true,
        "cloud": "public",
        "columns_to_local_vars": false,
        "cursor_var": null,
        "debug": false,
        "device_code_login_notification": "auto",
        "device_code_notification_email": "",
        "display_limit": null,
        "dsn_filename": "odbc.ini",
        "dynamic_to_dataframe": "object",
        "enable_curly_brackets_params": false,
        "enable_sso": false,
        "enable_suppress_result": true,
        "export_folder_name": "exported_files",
        "extras_require": "default",
        "feedback": true,
        "is_magic": true,
        "json_display": "formatted",
        "kernel_id": "51390d22-5634-4d63-910c-5166edf25d91",
        "kernel_location": "remote",
        "kqlmagic_kernel": false,
        "last_raw_result_var": "_kql_raw_result_",
        "notebook_app": "azuremljupyterlab",
        "notebook_service_address": null,
        "palette_colors": 10,
        "palette_desaturation": 1.0,
        "palette_name": "tab10",
        "popup_interaction": "auto",
        "prettytable_style": "DEFAULT",
        "query_link_destination": "Kusto.WebExplorer",
        "request_app_tag": null,
        "request_cache_max_age": 0,
        "request_id_tag": null,
        "request_user_tag": null,
        "schema_json_display": "auto",
        "short_errors": true,
        "show_conn_info": "current",
        "show_init_banner": false,
        "show_query": false,
        "show_query_link": false,
        "show_query_time": true,
        "show_what_new": true,
        "sso_db_gc_interval": 168,
        "table_package": "prettytable",
        "temp_files_server": "auto",
        "temp_files_server_address": null,
        "temp_folder_location": "starting_dir",
        "temp_folder_name": "temp_files",
        "test_notebook_app": "none",
        "timeout": null,
        "try_azcli_login": true,
        "try_azcli_login_subscription": null,
        "try_kqlmaic_sso": false,
        "try_msi": null,
        "try_token": null,
        "try_vscode_login": false,
        "use_cache": null,
        "validate_connection_string": true,
        "warn_missing_dependencies": true,
        "warn_missing_env_variables": true
    },
    "packages": {
        "azure-common": "1.1.26",
        "azure-identity": "1.5.0",
        "beautifulsoup4": "4.9.3",
        "cryptography": "3.2",
        "flask": "1.1.2",
        "ipykernel": "5.5.0",
        "ipython": "7.16.1",
        "ipywidgets": "7.6.3",
        "isodate": "0.6.0",
        "lxml": "4.6.3",
        "markdown": "3.3.4",
        "matplotlib": "3.2.1",
        "msal": "1.9.0",
        "msrestazure": "0.6.4",
        "pandas": "0.25.3",
        "prettytable": "2.1.0",
        "psutil": "5.8.0",
        "pygments": "2.8.1",
        "python-dateutil": "2.8.1",
        "requests": "2.25.1",
        "setuptools": "50.3.0",
        "traitlets": "4.3.3"
    },
    "platform": {
        "release": "5.4.0-1040-azure",
        "system": "Linux"
    },
    "python": {
        "name": "CPython",
        "version": "3.6.9"
    }
}

[mbnshtck]

You need to set the right env variable