{"id":105,"date":"2022-03-18T16:49:40","date_gmt":"2022-03-18T16:49:40","guid":{"rendered":"http:\/\/powerbikiss.com\/?p=105"},"modified":"2022-04-04T19:36:01","modified_gmt":"2022-04-04T19:36:01","slug":"simple-way-to-get-power-query-intellisense-to-work-no-dots","status":"publish","type":"post","link":"https:\/\/powerbikiss.com\/?p=105","title":{"rendered":"Simple way to get Power Query Intellisense to work (NO DOTS!)"},"content":{"rendered":"\n<p>Power query intellisense can be really frustrating to use, but there is a simple solution&#8230; <br>No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"http:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/image.png\" alt=\"\" class=\"wp-image-110\"\/><figcaption>Dot<\/figcaption><\/figure>\n\n\n\n<p>Try searching without the dot, like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"362\" src=\"http:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-111\" srcset=\"https:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/image-1.png 433w, https:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/image-1-300x251.png 300w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><figcaption>No Dot<\/figcaption><\/figure>\n\n\n\n<p>You will quickly find the formula you need &amp; when you tab to accept, it will work as you would expect. \ud83d\ude18<\/p>\n\n\n\n<p>This quick video covers it too&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to use Power Query Intellisense\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/MhzJ-uAiaxs?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power query intellisense can be really frustrating to use, but there is a simple solution&#8230; No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need &amp; when you tab to accept, it [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4],"tags":[8],"class_list":["post-105","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-powerbi"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need &amp; when you tab to accept, it\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Mary Fealty\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/powerbikiss.com\/?p=105\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"- Power BI - Keeping it simple, stupid\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Simple way to get Power Query Intellisense to work (NO DOTS!) -\" \/>\n\t\t<meta property=\"og:description\" content=\"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need &amp; when you tab to accept, it\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/powerbikiss.com\/?p=105\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/cropped-Banner-2-1.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/cropped-Banner-2-1.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2022-03-18T16:49:40+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-04-04T19:36:01+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@Br0adtree\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Simple way to get Power Query Intellisense to work (NO DOTS!) -\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need &amp; when you tab to accept, it\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@Br0adtree\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/cropped-Banner-2-1.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#blogposting\",\"name\":\"Simple way to get Power Query Intellisense to work (NO DOTS!) -\",\"headline\":\"Simple way to get Power Query Intellisense to work (NO DOTS!)\",\"author\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/powerbikiss.com\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/image.png\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105\\\/#articleImage\"},\"datePublished\":\"2022-03-18T16:49:40+00:00\",\"dateModified\":\"2022-04-04T19:36:01+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#webpage\"},\"articleSection\":\"Power BI, #PowerBI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/powerbikiss.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?cat=4#listItem\",\"name\":\"Power BI\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?cat=4#listItem\",\"position\":2,\"name\":\"Power BI\",\"item\":\"https:\\\/\\\/powerbikiss.com\\\/?cat=4\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#listItem\",\"name\":\"Simple way to get Power Query Intellisense to work (NO DOTS!)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#listItem\",\"position\":3,\"name\":\"Simple way to get Power Query Intellisense to work (NO DOTS!)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?cat=4#listItem\",\"name\":\"Power BI\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/#person\",\"name\":\"mary\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b05415ac2e54d2a0d19c298e5658af0890f4cb8cc0eea52caf14562e9b9983aa?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"mary\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?author=2#author\",\"url\":\"https:\\\/\\\/powerbikiss.com\\\/?author=2\",\"name\":\"Mary Fealty\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6d290f4b53e8cd0fe2c30e72b8636767d33cbe519ed87d5a09f66a77f2b22bc3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Mary Fealty\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#webpage\",\"url\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105\",\"name\":\"Simple way to get Power Query Intellisense to work (NO DOTS!) -\",\"description\":\"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need & when you tab to accept, it\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?p=105#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/?author=2#author\"},\"datePublished\":\"2022-03-18T16:49:40+00:00\",\"dateModified\":\"2022-04-04T19:36:01+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/#website\",\"url\":\"https:\\\/\\\/powerbikiss.com\\\/\",\"description\":\"Power BI - Keeping it simple, stupid\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/powerbikiss.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Simple way to get Power Query Intellisense to work (NO DOTS!) -","description":"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need & when you tab to accept, it","canonical_url":"https:\/\/powerbikiss.com\/?p=105","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/powerbikiss.com\/?p=105#blogposting","name":"Simple way to get Power Query Intellisense to work (NO DOTS!) -","headline":"Simple way to get Power Query Intellisense to work (NO DOTS!)","author":{"@id":"https:\/\/powerbikiss.com\/?author=2#author"},"publisher":{"@id":"https:\/\/powerbikiss.com\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/image.png","@id":"https:\/\/powerbikiss.com\/?p=105\/#articleImage"},"datePublished":"2022-03-18T16:49:40+00:00","dateModified":"2022-04-04T19:36:01+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/powerbikiss.com\/?p=105#webpage"},"isPartOf":{"@id":"https:\/\/powerbikiss.com\/?p=105#webpage"},"articleSection":"Power BI, #PowerBI"},{"@type":"BreadcrumbList","@id":"https:\/\/powerbikiss.com\/?p=105#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/powerbikiss.com#listItem","position":1,"name":"Home","item":"https:\/\/powerbikiss.com","nextItem":{"@type":"ListItem","@id":"https:\/\/powerbikiss.com\/?cat=4#listItem","name":"Power BI"}},{"@type":"ListItem","@id":"https:\/\/powerbikiss.com\/?cat=4#listItem","position":2,"name":"Power BI","item":"https:\/\/powerbikiss.com\/?cat=4","nextItem":{"@type":"ListItem","@id":"https:\/\/powerbikiss.com\/?p=105#listItem","name":"Simple way to get Power Query Intellisense to work (NO DOTS!)"},"previousItem":{"@type":"ListItem","@id":"https:\/\/powerbikiss.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/powerbikiss.com\/?p=105#listItem","position":3,"name":"Simple way to get Power Query Intellisense to work (NO DOTS!)","previousItem":{"@type":"ListItem","@id":"https:\/\/powerbikiss.com\/?cat=4#listItem","name":"Power BI"}}]},{"@type":"Person","@id":"https:\/\/powerbikiss.com\/#person","name":"mary","image":{"@type":"ImageObject","@id":"https:\/\/powerbikiss.com\/?p=105#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/b05415ac2e54d2a0d19c298e5658af0890f4cb8cc0eea52caf14562e9b9983aa?s=96&d=mm&r=g","width":96,"height":96,"caption":"mary"}},{"@type":"Person","@id":"https:\/\/powerbikiss.com\/?author=2#author","url":"https:\/\/powerbikiss.com\/?author=2","name":"Mary Fealty","image":{"@type":"ImageObject","@id":"https:\/\/powerbikiss.com\/?p=105#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/6d290f4b53e8cd0fe2c30e72b8636767d33cbe519ed87d5a09f66a77f2b22bc3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Mary Fealty"}},{"@type":"WebPage","@id":"https:\/\/powerbikiss.com\/?p=105#webpage","url":"https:\/\/powerbikiss.com\/?p=105","name":"Simple way to get Power Query Intellisense to work (NO DOTS!) -","description":"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need & when you tab to accept, it","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/powerbikiss.com\/#website"},"breadcrumb":{"@id":"https:\/\/powerbikiss.com\/?p=105#breadcrumblist"},"author":{"@id":"https:\/\/powerbikiss.com\/?author=2#author"},"creator":{"@id":"https:\/\/powerbikiss.com\/?author=2#author"},"datePublished":"2022-03-18T16:49:40+00:00","dateModified":"2022-04-04T19:36:01+00:00"},{"@type":"WebSite","@id":"https:\/\/powerbikiss.com\/#website","url":"https:\/\/powerbikiss.com\/","description":"Power BI - Keeping it simple, stupid","inLanguage":"en-US","publisher":{"@id":"https:\/\/powerbikiss.com\/#person"}}]},"og:locale":"en_US","og:site_name":"- Power BI - Keeping it simple, stupid","og:type":"article","og:title":"Simple way to get Power Query Intellisense to work (NO DOTS!) -","og:description":"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need &amp; when you tab to accept, it","og:url":"https:\/\/powerbikiss.com\/?p=105","og:image":"https:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/cropped-Banner-2-1.png","og:image:secure_url":"https:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/cropped-Banner-2-1.png","article:published_time":"2022-03-18T16:49:40+00:00","article:modified_time":"2022-04-04T19:36:01+00:00","twitter:card":"summary","twitter:site":"@Br0adtree","twitter:title":"Simple way to get Power Query Intellisense to work (NO DOTS!) -","twitter:description":"Power query intellisense can be really frustrating to use, but there is a simple solution... No dots, so imagine you want to use the formula Date.ToText instead of typing e.g. date.to like this: Try searching without the dot, like this: You will quickly find the formula you need &amp; when you tab to accept, it","twitter:creator":"@Br0adtree","twitter:image":"http:\/\/powerbikiss.com\/wp-content\/uploads\/2022\/03\/cropped-Banner-2-1.png"},"aioseo_meta_data":{"post_id":"105","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2022-03-21 18:20:18","updated":"2025-06-03 18:20:13","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/powerbikiss.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/powerbikiss.com\/?cat=4\" title=\"Power BI\">Power BI<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSimple way to get Power Query Intellisense to work (NO DOTS!)\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/powerbikiss.com"},{"label":"Power BI","link":"https:\/\/powerbikiss.com\/?cat=4"},{"label":"Simple way to get Power Query Intellisense to work (NO DOTS!)","link":"https:\/\/powerbikiss.com\/?p=105"}],"_links":{"self":[{"href":"https:\/\/powerbikiss.com\/index.php?rest_route=\/wp\/v2\/posts\/105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powerbikiss.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powerbikiss.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powerbikiss.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powerbikiss.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=105"}],"version-history":[{"count":1,"href":"https:\/\/powerbikiss.com\/index.php?rest_route=\/wp\/v2\/posts\/105\/revisions"}],"predecessor-version":[{"id":112,"href":"https:\/\/powerbikiss.com\/index.php?rest_route=\/wp\/v2\/posts\/105\/revisions\/112"}],"wp:attachment":[{"href":"https:\/\/powerbikiss.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powerbikiss.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powerbikiss.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}