{"id":196,"date":"2020-08-14T19:35:24","date_gmt":"2020-08-15T00:35:24","guid":{"rendered":"http:\/\/ninmonkeys.com\/blog\/?page_id=196"},"modified":"2021-11-04T09:39:04","modified_gmt":"2021-11-04T14:39:04","slug":"power-bi-and-power-query-resources","status":"publish","type":"page","link":"https:\/\/ninmonkeys.com\/blog\/power-bi-and-power-query-resources\/","title":{"rendered":"Power BI and Power Query Resources"},"content":{"rendered":"\n<p>A list of useful PBI related blog posts and docs<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n<\/div><\/div>\n\n\n\n<h2>DAX<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.daxpatterns.com\/\">Dax Patterns<\/a><\/p>\n\n\n\n<h2>Dynamic M Query Parameters (preview)<\/h2>\n\n\n\n<p><a href=\"https:\/\/community.powerbi.com\/t5\/Community-Blog\/Unlock-the-power-of-dynamic-parameter-binding-for-Direct-Query\/ba-p\/1448000\">Unlock the Power of Dynamic Parameter Binding for DirectQuery<\/a><br>a Tutorial by <strong>Artemus<\/strong><br><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-dynamic-m-query-parameters#considerations-and-limitations\">Dynamic M query parameters (preview)<\/a> [docs]<br>Power BI 2020 Feature Summary: <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-october-2020-feature-summary\/#_Toc52195564\">Dynamic Parameters in DirectQuery<\/a><\/p>\n\n\n\n<h2>Office Scripts \/ Excel Online<\/h2>\n\n\n\n<ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/dev\/scripts\/develop\/power-automate-integration\">\/office\/dev\/scripts\/develop\/power-automate-integration<\/a><\/li><li><a href=\"https:\/\/github.com\/OfficeDev\/office-scripts-docs\/blob\/master\/docs\/develop\/power-automate-integration.md \">https:\/\/github.com\/OfficeDev\/office-scripts-docs\/blob\/master\/docs\/develop\/power-automate-integration.md <\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/dev\/scripts\/\">docs.microsoft.com: Office Dev Scripts<\/a> ( or <strong>github<\/strong>: <a href=\"https:\/\/github.com\/OfficeDev\/office-scripts-docs\">OfficeDev\/office-scripts-docs<\/a> )<\/li><\/ul>\n\n\n\n<h2>Saving Power Query source code in one copy<\/h2>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"http:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2020\/10\/exporting-powerquery-to-vs-code-2020-10-07.mp4.mp4\"><\/video><figcaption>You can copy a single query, or select them all to save <strong>all queries<\/strong>!<br>If the query has dependencies, they are automatically copied!<br>You can paste into another PBI report or a text editor.<\/figcaption><\/figure>\n\n\n\n<h3>VS Code: Power Query Addon<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"623\" height=\"302\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2020\/10\/image-13.png\" alt=\"\" class=\"wp-image-707\" srcset=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2020\/10\/image-13.png 623w, https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2020\/10\/image-13-300x145.png 300w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/figure>\n\n\n\n<p>get the <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=PowerQuery.vscode-powerquery\">VS Code: Power Query Addon<\/a><\/p>\n\n\n\n<h2>Improving Report Performance<\/h2>\n\n\n\n<p>Convert Multiple visuals to a matrix and background image<br><a href=\"https:\/\/alluringbi.com\/2019\/10\/21\/background-concepts-for-power-bi\/\">alluringbi.com\/2019\/10\/21\/background-concepts-for-power-bi\/<\/a><br><a href=\"https:\/\/alluringbi.com\/2020\/08\/06\/consolidating-report-elements-for-improved-performance\/\">alluringbi.com\/2020\/08\/06\/consolidating-report-elements-for-improved-performance\/<\/a><br><a href=\"https:\/\/dax.tips\/2019\/08\/05\/dax-fusion\/\">https:\/\/dax.tips\/2019\/08\/05\/dax-fusion\/<\/a><br><a href=\"https:\/\/data-mozart.com\/vertipaq-brain-muscles-behind-power-bi\/\">https:\/\/data-mozart.com\/vertipaq-brain-muscles-behind-power-bi\/<\/a><br><a href=\"https:\/\/data-mozart.com\/tiq-part-1-how-to-destroy-your-power-bi-model-with-auto-date-time\/\">https:\/\/data-mozart.com\/tiq-part-1-how-to-destroy-your-power-bi-model-with-auto-date-time\/<\/a><br><a href=\"https:\/\/data-mozart.com\/inside-vertipaq-compress-for-success\/\">https:\/\/data-mozart.com\/inside-vertipaq-compress-for-success\/<\/a> <br><a href=\"https:\/\/data-mozart.com\/how-i-speed-up-my-power-bi-report-5x\/\">https:\/\/data-mozart.com\/how-i-speed-up-my-power-bi-report-5x\/<\/a><br><\/p>\n\n\n\n<h2>SQL Native queries<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-chris-webb-039-s-bi-blog wp-block-embed-chris-webb-039-s-bi-blog\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"uySObiYyDI\"><a href=\"https:\/\/blog.crossjoin.co.uk\/2016\/12\/11\/passing-parameters-to-sql-queries-with-value-nativequery-in-power-query-and-power-bi\/\">Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And Power BI<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And Power BI&#8221; &#8212; Chris Webb&#039;s BI Blog\" src=\"https:\/\/blog.crossjoin.co.uk\/2016\/12\/11\/passing-parameters-to-sql-queries-with-value-nativequery-in-power-query-and-power-bi\/embed\/#?secret=uySObiYyDI\" data-secret=\"uySObiYyDI\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><figcaption>[blog.crossjoin.co.uk] Chris shows how to use <strong>Parameterized Native SQL queries<\/strong><\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\" data-line=\"\">let\n    Source = Sql.Database(&quot;localhost&quot;, &quot;Adventure Works DW&quot;),\n    Test = Value.NativeQuery(\n        Source,\n        &quot;SELECT * FROM DimDate \n        WHERE EnglishMonthName=@MonthName&quot;,\n        &#091;\n            MonthName = &quot;March&quot;,\n            DayName = &quot;Tuesday&quot;\n        ]\n    )\nin\n    Test<\/code><\/pre>\n\n\n\n<p>docs <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/value-nativequery\">Value.NativeQuery()<\/a><\/p>\n\n\n\n<h2>Power Query Tutorials | Docs.microsoft<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<h2>Performance<\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-directquery-about#guidance-for-using-directquery-successfully\">Guidance for using DirectQuery successfully [docs.microsoft.com]<\/a><br><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/monitor-report-performance\">Monitor Report Performance [docs.microsoft.com]<\/a><br><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-performance-analyzer\">Use Performance Analyzer to examine report element performance [docs.microsoft.com]<\/a><\/p>\n\n\n\n<h3>Caching: <code class=\"\" data-line=\"\">Binary.Buffer<\/code>, <code class=\"\" data-line=\"\">List.Buffer<\/code>, <code class=\"\" data-line=\"\">Table.Buffer<\/code><\/h3>\n\n\n\n<p>Power Query, Performance, Microsoft Employee, Mashup, Engine, Quality<br>https:\/\/bengribaudo.com\/blog\/2019\/12\/20\/4805\/power-query-m-primer-part13-tables-table-think-ii<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-ben-gribaudo wp-block-embed-ben-gribaudo\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"U8dSg4ZRqC\"><a href=\"https:\/\/bengribaudo.com\/blog\/2019\/12\/20\/4805\/power-query-m-primer-part13-tables-table-think-ii\">Power Query M Primer (Part 13): Tables\u2014Table Think II<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Power Query M Primer (Part 13): Tables\u2014Table Think II&#8221; &#8212; Ben Gribaudo\" src=\"https:\/\/bengribaudo.com\/blog\/2019\/12\/20\/4805\/power-query-m-primer-part13-tables-table-think-ii\/embed#?secret=U8dSg4ZRqC\" data-secret=\"U8dSg4ZRqC\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><figcaption>Discusses performance related to using <code class=\"\" data-line=\"\">Keys<\/code>, <code class=\"\" data-line=\"\">*.buffer<\/code>, <code class=\"\" data-line=\"\">Formula.Firewall<\/code>, and links to <code class=\"\" data-line=\"\">Power Query<\/code> team posts about performance<\/figcaption><\/figure>\n\n\n\n<p>&#8211; <a href=\"https:\/\/social.technet.microsoft.com\/Forums\/en-US\/70ec6d1a-4fcc-4d8e-a131-df2f9267969b\/how-do-i-cache-or-buffer-an-intermediate-query-result-for-repeated-use?forum=powerquery#59060ae6-9e41-4512-9a57-d4fc3f90a740-isAnswer\">how-do-i-cache-or-buffer-an-intermediate-query-result-for-repeated-use<\/a> <br>&#8211; <a href=\"https:\/\/social.technet.microsoft.com\/Forums\/en-US\/34e454b5-3a18-4eef-b920-40703c93f390\/tablebuffer-for-cashing-intermediate-query-results-or-how-workaround-unnecessary-queries-issue#92ebd39c-18e3-4a02-ac56-15a36090a826-isAnswer\">tablebuffer-for-cashing-intermediate-query-results-or-how-workaround-unnecessary-queries-issue<\/a><br>&#8211; <a href=\"https:\/\/social.technet.microsoft.com\/Forums\/en-US\/8d5ee632-fdff-4ba2-b150-bb3591f955fb\/queries-evaluation-chain?forum=powerquery#8777a936-b36f-454a-bb0f-2905c40611f7\">queries-evaluation-chain<\/a><br><\/p>\n\n\n\n<h3>Direct Query<\/h3>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-directquery-about\">About using DirectQuery in Power BI Desktop [docs.microsoft.com]<\/a><\/p>\n\n\n\n<h2>Incremental Refresh<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.poweredsolutions.co\/2020\/01\/19\/incremental-refresh-for-files-in-a-folder-or-sharepoint-power-bi\/\">https:\/\/www.poweredsolutions.co\/2020\/01\/19\/incremental-refresh-for-files-in-a-folder-or-sharepoint-power-bi\/<\/a><br><a href=\"https:\/\/radacad.com\/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only\">https:\/\/radacad.com\/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/refresh-data\">Data Refresh in Power BI [docs.microsoft.com]<\/a><\/p>\n\n\n\n<h2>Tracing and Diagnostics<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-ben-gribaudo wp-block-embed-ben-gribaudo\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"kmPGPuSyIv\"><a href=\"https:\/\/bengribaudo.com\/blog\/2020\/03\/11\/5057\/power-query-security-evidence-left-behind\">Power Query Security: Evidence Left Behind<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Power Query Security: Evidence Left Behind&#8221; &#8212; Ben Gribaudo\" src=\"https:\/\/bengribaudo.com\/blog\/2020\/03\/11\/5057\/power-query-security-evidence-left-behind\/embed#?secret=kmPGPuSyIv\" data-secret=\"kmPGPuSyIv\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><figcaption><br>bengribaudo.com covers locations of caches, logs, tracing, and query diagnostics<\/figcaption><\/figure>\n\n\n\n<h2>Connectors<\/h2>\n\n\n\n<p>list of all Power platform connectors <a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/connector-reference\/\" data-type=\"URL\" data-id=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/connector-reference\/\">docs.microsoft.com\/en-us\/connectors\/connector-reference\/<\/a><\/p>\n\n\n\n<p>list of all <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/power-bi-data-sources\">Power BI data sources<\/a> docs.microsoft<\/p>\n\n\n\n<p>Specific connectors: <a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/sql\/\">SQL Connector<\/a><\/p>\n\n\n\n<h2>Query Folding<\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-query-folding\">Query folding guidance in Power BI Desktop<\/a> docs.microsoft.com<\/p>\n\n\n\n<h2>Referenced Queries<\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-query-referenced-queries\">Referencing Power Query queries [docs.microsoft.com]<\/a> Explains why <code class=\"\" data-line=\"\">referenced queries<\/code> run the base query multiple times<\/p>\n\n\n\n<h2>Dataflows<\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/service-dataflows-best-practices\">Best practices for dataflows [docs.microsoft.com]<\/a><\/p>\n\n\n\n<h2><code class=\"\" data-line=\"\">Formula.Firewall<\/code> errors<\/h2>\n\n\n\n<ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/power-query\/dataprivacyfirewall\" target=\"_blank\">Docs: Behind the scenes of the Data Privacy Firewall<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.poweredsolutions.co\/2019\/03\/12\/data-privacy-and-the-formula-firewall\/\" target=\"_blank\">Data Privacy and the Formula Firewall in Power BI \/ Power Query<\/a><\/li><li><a href=\"https:\/\/blog.crossjoin.co.uk\/2017\/06\/26\/data-privacy-settings-in-power-bipower-query-part-3-the-formula-firewall-error\/\">Data Privacy Settings In Power BI\/Power Query, Part 3: The Formula.Firewall Error<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/admin\/desktop-privacy-levels\">Docs: Power BI Desktop privacy levels<\/a><\/li><\/ul>\n\n\n\n<h2>Videos<\/h2>\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 title=\"6 ways to go bananas with Column from Examples in Power BI\" width=\"580\" height=\"326\" src=\"https:\/\/www.youtube.com\/embed\/GUwtPIKtqO0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><figcaption>Add by examples works better than it should. <br>It dynamically displays the <strong>PowerQuery<\/strong> used while you&#8217;re entering examples<\/figcaption><\/figure>\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 title=\"PowerBI.Tips - PUG - Calculated Columns - A Love Hate Relationship\" width=\"580\" height=\"326\" src=\"https:\/\/www.youtube.com\/embed\/6X2vH5Rn3x4?start=2664&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><figcaption><strong>Alex Powers<\/strong>: Calculated Columns<\/figcaption><\/figure>\n\n\n\n<h2>Time Zones<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-powered-solutions wp-block-embed-powered-solutions\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/www.poweredsolutions.co\/2019\/10\/21\/handling-different-time-zones-in-power-bi-power-query\/\n<\/div><\/figure>\n\n\n\n<h2>Web.Contents<\/h2>\n\n\n\n<p><a href=\"https:\/\/blog.crossjoin.co.uk\/2019\/04\/25\/skip-test-connection-power-bi-refresh-failures\/\">https:\/\/blog.crossjoin.co.uk\/2019\/04\/25\/skip-test-connection-power-bi-refresh-failures\/<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-chris-webb-039-s-bi-blog wp-block-embed-chris-webb-039-s-bi-blog\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"HbkpDj4kbk\"><a href=\"https:\/\/blog.crossjoin.co.uk\/2016\/08\/23\/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi\/\">Web.Contents(), M Functions And Dataset Refresh Errors In Power BI<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Web.Contents(), M Functions And Dataset Refresh Errors In Power BI&#8221; &#8212; Chris Webb&#039;s BI Blog\" src=\"https:\/\/blog.crossjoin.co.uk\/2016\/08\/23\/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi\/embed\/#?secret=HbkpDj4kbk\" data-secret=\"HbkpDj4kbk\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2>Privacy and Credentials<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-ben-gribaudo wp-block-embed-ben-gribaudo\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"kmPGPuSyIv\"><a href=\"https:\/\/bengribaudo.com\/blog\/2020\/03\/11\/5057\/power-query-security-evidence-left-behind\">Power Query Security: Evidence Left Behind<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Power Query Security: Evidence Left Behind&#8221; &#8212; Ben Gribaudo\" src=\"https:\/\/bengribaudo.com\/blog\/2020\/03\/11\/5057\/power-query-security-evidence-left-behind\/embed#?secret=kmPGPuSyIv\" data-secret=\"kmPGPuSyIv\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-chris-webb-039-s-bi-blog wp-block-embed-chris-webb-039-s-bi-blog\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"IQ6lNzaz24\"><a href=\"https:\/\/blog.crossjoin.co.uk\/2018\/11\/06\/the-credentialquery-option-for-web-contents-in-power-bi-custom-data-connectors\/\">The CredentialQuery Option For Web.Contents() In Power BI Custom Data Connectors<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;The CredentialQuery Option For Web.Contents() In Power BI Custom Data Connectors&#8221; &#8212; Chris Webb&#039;s BI Blog\" src=\"https:\/\/blog.crossjoin.co.uk\/2018\/11\/06\/the-credentialquery-option-for-web-contents-in-power-bi-custom-data-connectors\/embed\/#?secret=IQ6lNzaz24\" data-secret=\"IQ6lNzaz24\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2>Binary data<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-matt-masson wp-block-embed-matt-masson\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"CaxqjMrqP1\"><a href=\"https:\/\/www.mattmasson.com\/2014\/11\/parsing-binary-data-using-power-query-formulas\/\">Parsing Binary data using Power Query formulas<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Parsing Binary data using Power Query formulas&#8221; &#8212; Matt Masson\" src=\"https:\/\/www.mattmasson.com\/2014\/11\/parsing-binary-data-using-power-query-formulas\/embed\/#?secret=CaxqjMrqP1\" data-secret=\"CaxqjMrqP1\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><figcaption>Read headers of<code class=\"\" data-line=\"\">.png<\/code> images<\/figcaption><\/figure>\n\n\n\n<h2>Using Python<\/h2>\n\n\n\n<ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-python-scripts\">Using Python as a Data Source<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-python-visuals\">Custom Report Visuals written in Python<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-python-packages-support\">Modules available on the Power BI Service when using Custom Visuals written in Python<\/a><\/li><\/ul>\n\n\n\n<h2>More<\/h2>\n\n\n\n<p><a href=\"https:\/\/radacad.com\/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns\">https:\/\/radacad.com\/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-the-biccountant wp-block-embed-the-biccountant\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"llEUmAYO5g\"><a href=\"https:\/\/www.thebiccountant.com\/learning-resources\/\">Learning resources<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Learning resources&#8221; &#8212; The BIccountant\" src=\"https:\/\/www.thebiccountant.com\/learning-resources\/embed\/#?secret=llEUmAYO5g\" data-secret=\"llEUmAYO5g\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-data-mozart wp-block-embed-data-mozart\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"MnyteAHERu\"><a href=\"https:\/\/data-mozart.com\/handling-blanks-in-power-bi\/\">Handling BLANK in Power BI<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Handling BLANK in Power BI&#8221; &#8212; Data Mozart\" src=\"https:\/\/data-mozart.com\/handling-blanks-in-power-bi\/embed\/#?secret=MnyteAHERu\" data-secret=\"MnyteAHERu\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-data-mozart wp-block-embed-data-mozart\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"WJDJQsKG3T\"><a href=\"https:\/\/data-mozart.com\/safe-click-trick-in-power-bi\/\">Safe click trick in Power BI<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Safe click trick in Power BI&#8221; &#8212; Data Mozart\" src=\"https:\/\/data-mozart.com\/safe-click-trick-in-power-bi\/embed\/#?secret=WJDJQsKG3T\" data-secret=\"WJDJQsKG3T\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><a href=\"https:\/\/radacad.com\/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns\">https:\/\/radacad.com\/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns<\/a><br><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-data-mozart wp-block-embed-data-mozart\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"bcaHbPMwiL\"><a href=\"https:\/\/data-mozart.com\/bookmarks-in-power-bi-what-this-data-mean\/\">Bookmarks in Power BI &#8211; What this Data mean?<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Bookmarks in Power BI &#8211; What this Data mean?&#8221; &#8212; Data Mozart\" src=\"https:\/\/data-mozart.com\/bookmarks-in-power-bi-what-this-data-mean\/embed\/#?secret=bcaHbPMwiL\" data-secret=\"bcaHbPMwiL\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-data-mozart wp-block-embed-data-mozart\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"L2XRAgEuow\"><a href=\"https:\/\/data-mozart.com\/dynamic-filtering-in-power-bi\/\">Dynamic filtering in Power BI<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Dynamic filtering in Power BI&#8221; &#8212; Data Mozart\" src=\"https:\/\/data-mozart.com\/dynamic-filtering-in-power-bi\/embed\/#?secret=L2XRAgEuow\" data-secret=\"L2XRAgEuow\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3>Tooltips<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-data-mozart wp-block-embed-data-mozart\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"CnqvDPpt9l\"><a href=\"https:\/\/data-mozart.com\/enhance-power-bi-report-with-tooltip-pages\/\">Enhance Power BI report with Tooltip pages<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Enhance Power BI report with Tooltip pages&#8221; &#8212; Data Mozart\" src=\"https:\/\/data-mozart.com\/enhance-power-bi-report-with-tooltip-pages\/embed\/#?secret=CnqvDPpt9l\" data-secret=\"CnqvDPpt9l\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A list of useful PBI related blog posts and docs DAX Dax Patterns Dynamic M Query Parameters (preview) Unlock the Power of Dynamic Parameter Binding for DirectQuerya Tutorial by ArtemusDynamic M query parameters (preview) [docs]Power BI 2020 Feature Summary: Dynamic Parameters in DirectQuery Office Scripts \/ Excel Online \/office\/dev\/scripts\/develop\/power-automate-integration https:\/\/github.com\/OfficeDev\/office-scripts-docs\/blob\/master\/docs\/develop\/power-automate-integration.md docs.microsoft.com: Office Dev Scripts ( [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages\/196"}],"collection":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":47,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages\/196\/revisions"}],"predecessor-version":[{"id":1991,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages\/196\/revisions\/1991"}],"wp:attachment":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media?parent=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}