{"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":[],"_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}]}}