{"id":61,"date":"2020-12-20T20:00:00","date_gmt":"2020-12-20T19:00:00","guid":{"rendered":"http:\/\/blog.dataengineer.at\/?p=61"},"modified":"2021-01-18T23:48:55","modified_gmt":"2021-01-18T22:48:55","slug":"wie-testet-man-1-000-user-auf-power-bi-teil-2","status":"publish","type":"post","link":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/","title":{"rendered":"Wie testet man 1.000 User auf Power BI? [Teil 2]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Inhalt<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69f475e279cac\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69f475e279cac\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#Fortsetzung_von_Teil_1\" >Continuation of part 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#Vergleich_AAS_vs_PBI\" >Comparison of AAS vs. PBI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#Ergebnisse\" >Results<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#SSIS_Logs\" >SSSI logs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#ADF_Diagnostic\" >ADF Diagnostic<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#ADF_Diagnostic_Logs\" >ADF Diagnostic logs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#Azure_Datafactory_Log\" >Azure Datafactory Log<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#ERGEBNIS\" >RESULT<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#AAS_S2\" >AAS S2<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#ERGEBNIS_Grafiken\" >RESULT graphics<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#AAS_Scale_Out\" >AAS Scale Out<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#Conclusio\" >Conclusion<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Fortsetzung_von_Teil_1\"><\/span>Continuation of part 1<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>Mass user test for Power BI - why and how you can find out in <a href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-1\/\" target=\"_blank\" rel=\"noreferrer noopener\">Part 1<\/a>\u2026<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vergleich_AAS_vs_PBI\"><\/span>Comparison of AAS vs. PBI<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>During the test, I also wanted to establish the basics as to whether an AAS (Azure Analysis Services) has an advantage over Power BI Premium, because I'm biased here, it is the same technology, but Power BI is more or less a \"black box\" and instinctively I like to have all backend services \u201cunder one roof\u201d in Azure under control and well monitored and only the reporting in Power BI.<\/p>\n\n\n\n<p>Therefore, all tests run on an identical model and also the same scaling against AAS S1 and Premium P1.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"163\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-1024x163.png\" alt=\"\" class=\"wp-image-75\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-1024x163.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-300x48.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-768x122.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-16x3.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-600x96.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches-945x151.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_ParallelBatches.png 1375w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Time shifted parallel jobs in ADF<\/figcaption><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ergebnisse\"><\/span>Results<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p>Great, the mass test is running - with ADF and SSIS, a strong IR and even in the full configuration up to 750 simultaneous processes (DAX queries), against Azure Analysis Services and against Power BI Premium Dataset.<\/p>\n\n\n\n<p>Now I just need to analyze the results ...<br>But how?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SSIS_Logs\"><\/span><img loading=\"lazy\" decoding=\"async\" width=\"30\" height=\"31\" class=\"wp-image-32\" style=\"width: 30px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No.png\" alt=\"\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No.png 314w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No-293x300.png 293w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No-150x150.png 150w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/> SSSI logs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A lot is logged by SSIS, which ends up in the SSISDB or in the file system, there you can evaluate it a bit cumbersome but with SQL.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"599\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-1024x599.png\" alt=\"\" class=\"wp-image-78\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-1024x599.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-300x176.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-768x450.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-16x9.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-600x351.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog-945x553.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSISLog.png 1131w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>But<\/strong>, from a certain point in time on, nothing arrived here, the logging system was overloaded or deadlocks - it is probably not thought that 750 processes are running.<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>No results without full logs!<\/p><\/blockquote><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ADF_Diagnostic\"><\/span>ADF Diagnostic<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>So I tried it differently, with the diagnostics of the Azure Data Factory.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"516\" height=\"278\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_Diagnostics.png\" alt=\"\" class=\"wp-image-79\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_Diagnostics.png 516w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_Diagnostics-300x162.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_Diagnostics-16x9.png 16w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/figure>\n\n\n\n<p>These logs are essentially the same SSIS logs plus those of the ADF, and it is obviously not a problem to stream all processes in parallel to a datalake.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"202\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-1024x202.png\" alt=\"\" class=\"wp-image-80\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-1024x202.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-300x59.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-768x151.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-16x3.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-600x118.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog-945x186.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLog.png 1193w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The logs are partitioned into \u201chundreds\u201d of sub-folders, as is usual on the Datalake with many files and parallel processes.<\/p>\n\n\n\n<p>But that's not a problem either, because with Power BI you can easily read in an entire folder recursively and Power BI can also resolve JSON - and then the evaluation can begin ...<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>Unfortunately not. Power BI denied!<\/p><\/blockquote><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ADF_Diagnostic_Logs\"><\/span>ADF Diagnostic logs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you want to import all of the files you will not have luck because the log is an invalid JSON! (I've been discussing this with Microsoft for months).<br>It is a line JSON which as a whole has no valid structure, so I copied the files together manually because I wanted to finally (!!!) see the results.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"465\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-1024x465.png\" alt=\"\" class=\"wp-image-81\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-1024x465.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-300x136.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-768x349.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-16x7.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-600x273.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON-945x429.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_DiagnosticsLogJSON.png 1351w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Individual JSON logs copied into valid overall JSON<\/figcaption><\/figure>\n\n\n\n<p>By the way, if you work with large files and also want to do \u201cFind &amp; Replace\u201d inside, you will quickly reach your limit with Notepad ++ or something similar - I recommend: <strong><a href=\"https:\/\/de.emeditor.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">EmEditor<\/a><\/strong> \u2013 impressiv!<\/p>\n\n\n\n<p>After the import and some tinkering in PowerQuery, the data can be analyzed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Azure_Datafactory_Log\"><\/span>Azure Datafactory Log<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The ADF log also provides some information about which process ran and which went wrong, how stressed the IR is, etc.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"583\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_PipelineLog.png\" alt=\"\" class=\"wp-image-82\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_PipelineLog.png 813w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_PipelineLog-300x215.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_PipelineLog-768x551.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_PipelineLog-16x12.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_PipelineLog-600x430.png 600w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><figcaption>ADF Pipeline Logs<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"148\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_IR.png\" alt=\"\" class=\"wp-image-83\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_IR.png 559w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_IR-300x79.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/ADF_IR-16x4.png 16w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><figcaption>ADF IR Monitor<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERGEBNIS\"><\/span>RESULT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Azure Analysis Services<\/strong> (AAS S1) is very stable, practically no failures, but has a significantly lower throughput.<br>The memory utilization is consistently high, with an increasing number of processes everything remains in operation.<br>AAS manages 200 simultaneous queries, an average of 120 (per 5 minutes).<\/p>\n\n\n\n<p><strong>Power BI Premium<\/strong> (P1) has some failures of individual queries, takes a long time to \"calm down\" from the maximum memory usage, but has a very high throughput.<br>The memory usage and CPU go up quickly and stay at the limit, new queries are rejected.<br>PBI comes up to 500 queries, sometimes more, an average of 280 (per 5 minutes).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"AAS_S2\"><\/span>AAS S2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Somehow I didn't want it to be true that the AAS had done so badly and so I repeated the test with S2, the result was even worse.<\/p>\n\n\n\n<p>These are of course only snapshots and many factors play a role, such as regions of the services, Azure fluctuations, allocated resources, etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ERGEBNIS_Grafiken\"><\/span>RESULT graphics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"341\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-1024x341.png\" alt=\"\" class=\"wp-image-96\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-1024x341.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-300x100.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-768x255.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-1536x511.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-16x5.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-600x200.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1-945x314.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_500_Memory-1.png 1834w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>AAS \u2013 Memory (1 Error)<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"325\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-1024x325.png\" alt=\"\" class=\"wp-image-98\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-1024x325.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-300x95.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-768x244.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-1536x488.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-2048x651.png 2048w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-16x5.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-600x191.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/IR_Memory-1-945x300.png 945w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Integration Runtime (1 Error)<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"663\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-1024x663.png\" alt=\"\" class=\"wp-image-87\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-1024x663.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-300x194.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-768x498.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-16x10.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-600x389.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker-945x612.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_marker.png 1153w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Power BI Premium \u2013 CPU &amp; Memory<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"581\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-1024x581.png\" alt=\"\" class=\"wp-image-88\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-1024x581.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-300x170.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-768x436.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-16x9.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-600x340.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich-945x536.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich.png 1461w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>AAS \/ PBI \u2013 Execution &amp; Query Duration<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"582\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-1024x582.png\" alt=\"\" class=\"wp-image-89\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-1024x582.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-300x171.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-768x437.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-1536x873.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-16x9.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-600x341.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich-945x537.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_S2_PBI_Vergleich.png 1544w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Concurrent Queries AAS \/ PBI<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"AAS_Scale_Out\"><\/span>AAS Scale Out<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>I still didn't want it to be true and I tuned the AAS, because the test was already finished and only had to be started with one click.<\/p>\n\n\n\n<p>First I changed the query priorities so that shorter queries get resources even in the middle of long queries.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"163\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_SchedulingBehavior.png\" alt=\"\" class=\"wp-image-91\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_SchedulingBehavior.png 647w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_SchedulingBehavior-300x76.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_SchedulingBehavior-16x4.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_SchedulingBehavior-600x151.png 600w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><figcaption>Short Query Bias<\/figcaption><\/figure>\n\n\n\n<p>It will use the full memory very quickly, but at some point that hardly helps and there is hardly any improvement in the S2 either, so it must be because of the compute power to process more at the same time, so I have done a <strong>Scale Out<\/strong> .<\/p>\n\n\n\n<p>You can see immediately that the maximum possible 100 QPU are doubled with the scale out and the memory is also used by the replica.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"336\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-1024x336.png\" alt=\"\" class=\"wp-image-100\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-1024x336.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-300x98.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-768x252.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-1536x504.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-16x5.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-600x197.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker-945x310.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_QPU_ScaleOut_Marker.png 1837w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"306\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-1024x306.png\" alt=\"\" class=\"wp-image-101\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-1024x306.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-300x90.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-768x230.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-1536x459.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-16x5.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-600x179.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker-945x283.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_S1_Memory_ScaleOut_Marker.png 1839w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Lo and behold, the throughput immediately comes close to that of Power BI Premium.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-1024x576.png\" alt=\"\" class=\"wp-image-92\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-1024x576.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-300x169.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-768x432.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-1536x864.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-16x9.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-600x338.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut-945x532.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut.png 1553w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>30 minutes under full load, the simultaneous queries are almost the same.<\/p>\n\n\n\n<p>The performance is still better with PBI.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-1024x576.png\" alt=\"\" class=\"wp-image-93\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-1024x576.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-300x169.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-768x432.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-1536x864.png 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-16x9.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-600x337.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast-945x531.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/AAS_PBI_Vergleich_ScaleOut_Performance_Volllast.png 1551w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Concurrent Queries<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusio\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Power BI Premium<\/strong> can still operate the relatively small but complex model even with many accesses, some queries no longer come to the end user when the system is up, but most of them have a good throughput and response time.<br>The system should be able to deal with 500 users, with the planned 1,000 or more it will get exciting...<\/p>\n\n\n\n<p>The <strong>AAS <\/strong>is not an alternative to this context, at least in the comparable variant.<br>An enormous increase of results you get from a scale out.<\/p>\n\n\n\n<p>Power BI is much better, the main advantage of AAS is its easy scalability, at any time, as required - if the month-end closing is tight, you add 1-2 replicas for a few hours and switch them off completely at the weekend to save money.<\/p>\n\n\n\n<p>Maybe I'll do a third part when the 1,000 users actually start - hopefully not with the title \u201cDream and Reality\u201d...<\/p>","protected":false},"excerpt":{"rendered":"<p>After a detailed test with up to 750 simultaneous queries to Power BI Premium, the results should now be evaluated.<br \/>\nHow well does PBI do and how does AAS do?<\/p>","protected":false},"author":1,"featured_media":197,"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":[5,3,7],"tags":[21,45,17,16,19,13,20,22,46],"class_list":["post-61","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-power-bi","category-tabular-analysis-services","tag-aas","tag-adf","tag-analysis-services","tag-azure","tag-dax","tag-powerbi","tag-premium","tag-ssis","tag-test"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Wie testet man 1.000 User auf Power BI? [Teil 2] - Data.Engineer BLOG<\/title>\n<meta name=\"description\" content=\"Nach ausf\u00fchrlichen Test mit bis zu 750 gleichzeitigen Abfragen an Power BI Premium sollen nun die Ergebnisse ausgewrtet werden.Wie gut schneidet PBI ab und wie AAS?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie testet man 1.000 User auf Power BI? [Teil 2] - Data.Engineer BLOG\" \/>\n<meta property=\"og:description\" content=\"Nach ausf\u00fchrlichen Test mit bis zu 750 gleichzeitigen Abfragen an Power BI Premium sollen nun die Ergebnisse ausgewrtet werden.Wie gut schneidet PBI ab und wie AAS?\" \/>\n<meta property=\"og:url\" content=\"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Data.Engineer BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-20T19:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-18T22:48:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/The-Matrix-640x360_PowerBI_AAS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"data.engineer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"data.engineer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/\"},\"author\":{\"name\":\"data.engineer\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\"},\"headline\":\"Wie testet man 1.000 User auf Power BI? [Teil 2]\",\"datePublished\":\"2020-12-20T19:00:00+00:00\",\"dateModified\":\"2021-01-18T22:48:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/\"},\"wordCount\":943,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\"},\"image\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/The-Matrix-640x360_PowerBI_AAS.jpg\",\"keywords\":[\"aas\",\"adf\",\"analysis services\",\"azure\",\"dax\",\"powerbi\",\"premium\",\"ssis\",\"test\"],\"articleSection\":[\"Azure\",\"Power BI\",\"Tabular \\\/ Analysis Services\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/\",\"name\":\"Wie testet man 1.000 User auf Power BI? [Teil 2] - Data.Engineer BLOG\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/The-Matrix-640x360_PowerBI_AAS.jpg\",\"datePublished\":\"2020-12-20T19:00:00+00:00\",\"dateModified\":\"2021-01-18T22:48:55+00:00\",\"description\":\"Nach ausf\u00fchrlichen Test mit bis zu 750 gleichzeitigen Abfragen an Power BI Premium sollen nun die Ergebnisse ausgewrtet werden.Wie gut schneidet PBI ab und wie AAS?\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#primaryimage\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/The-Matrix-640x360_PowerBI_AAS.jpg\",\"contentUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/The-Matrix-640x360_PowerBI_AAS.jpg\",\"width\":640,\"height\":360,\"caption\":\"1.000 User auf Power BI (2)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/wie-testet-man-1-000-user-auf-power-bi-teil-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"http:\\\/\\\/blog.dataengineer.at\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie testet man 1.000 User auf Power BI? [Teil 2]\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#website\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/\",\"name\":\"Data.Engineer BLOG\",\"description\":\"All about data...\",\"publisher\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/blog.dataengineer.at\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\",\"name\":\"data.engineer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\",\"contentUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\",\"caption\":\"data.engineer\"},\"logo\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\"},\"sameAs\":[\"http:\\\/\\\/dataengineer.at\"],\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/author\\\/data-engineer\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie testet man 1.000 User auf Power BI? [Teil 2] - Data.Engineer BLOG","description":"Nach ausf\u00fchrlichen Test mit bis zu 750 gleichzeitigen Abfragen an Power BI Premium sollen nun die Ergebnisse ausgewrtet werden.Wie gut schneidet PBI ab und wie AAS?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/","og_locale":"en_US","og_type":"article","og_title":"Wie testet man 1.000 User auf Power BI? [Teil 2] - Data.Engineer BLOG","og_description":"Nach ausf\u00fchrlichen Test mit bis zu 750 gleichzeitigen Abfragen an Power BI Premium sollen nun die Ergebnisse ausgewrtet werden.Wie gut schneidet PBI ab und wie AAS?","og_url":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/","og_site_name":"Data.Engineer BLOG","article_published_time":"2020-12-20T19:00:00+00:00","article_modified_time":"2021-01-18T22:48:55+00:00","og_image":[{"width":640,"height":360,"url":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/The-Matrix-640x360_PowerBI_AAS.jpg","type":"image\/jpeg"}],"author":"data.engineer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"data.engineer","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#article","isPartOf":{"@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/"},"author":{"name":"data.engineer","@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a"},"headline":"Wie testet man 1.000 User auf Power BI? [Teil 2]","datePublished":"2020-12-20T19:00:00+00:00","dateModified":"2021-01-18T22:48:55+00:00","mainEntityOfPage":{"@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/"},"wordCount":943,"commentCount":0,"publisher":{"@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a"},"image":{"@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#primaryimage"},"thumbnailUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/The-Matrix-640x360_PowerBI_AAS.jpg","keywords":["aas","adf","analysis services","azure","dax","powerbi","premium","ssis","test"],"articleSection":["Azure","Power BI","Tabular \/ Analysis Services"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/","url":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/","name":"Wie testet man 1.000 User auf Power BI? [Teil 2] - Data.Engineer BLOG","isPartOf":{"@id":"http:\/\/blog.dataengineer.at\/#website"},"primaryImageOfPage":{"@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#primaryimage"},"image":{"@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#primaryimage"},"thumbnailUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/The-Matrix-640x360_PowerBI_AAS.jpg","datePublished":"2020-12-20T19:00:00+00:00","dateModified":"2021-01-18T22:48:55+00:00","description":"Nach ausf\u00fchrlichen Test mit bis zu 750 gleichzeitigen Abfragen an Power BI Premium sollen nun die Ergebnisse ausgewrtet werden.Wie gut schneidet PBI ab und wie AAS?","breadcrumb":{"@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#primaryimage","url":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/The-Matrix-640x360_PowerBI_AAS.jpg","contentUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/The-Matrix-640x360_PowerBI_AAS.jpg","width":640,"height":360,"caption":"1.000 User auf Power BI (2)"},{"@type":"BreadcrumbList","@id":"http:\/\/blog.dataengineer.at\/en\/wie-testet-man-1-000-user-auf-power-bi-teil-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"http:\/\/blog.dataengineer.at\/"},{"@type":"ListItem","position":2,"name":"Wie testet man 1.000 User auf Power BI? [Teil 2]"}]},{"@type":"WebSite","@id":"http:\/\/blog.dataengineer.at\/#website","url":"http:\/\/blog.dataengineer.at\/","name":"Data.Engineer BLOG","description":"All about data...","publisher":{"@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/blog.dataengineer.at\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a","name":"data.engineer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg","url":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg","contentUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg","caption":"data.engineer"},"logo":{"@id":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg"},"sameAs":["http:\/\/dataengineer.at"],"url":"http:\/\/blog.dataengineer.at\/en\/author\/data-engineer\/"}]}},"post_mailing_queue_ids":[],"_links":{"self":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":18,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":352,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts\/61\/revisions\/352"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/media\/197"}],"wp:attachment":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}