[et_\u200bpb_\u200bsection fb_built=\u201c1\u201d _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d da_disable_devices=\u201coff|off|off\u201d global_\u200bcolors_\u200binfo=\u201d{}\u201d da_is_popup=\u201coff\u201d da_exit_intent=\u201coff\u201d da_has_close=\u201con\u201d da_alt_close=\u201coff\u201d da_dark_close=\u201coff\u201d da_not_modal=\u201con\u201d da_is_singular=\u201coff\u201d da_with_loader=\u201coff\u201d da_has_shadow=\u201con\u201d][et_pb_row _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201c4_4\u201d _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d text_orientation=\u201cjustified\u201d hover_enabled=\u201c0\u201d global_\u200bcolors_\u200binfo=\u201d{}\u201d sticky_enabled=\u201c0\u201d]<\/p>\n
Let\u2019s dive into the world of Microsoft Data Plat\u00adform and Pow\u00ader Plat\u00adform, and specif\u00adi\u00adcal\u00adly the events and most impact\u00adful releas\u00ades in our view, Islet\u2019s Data & Ana\u00adlyt\u00adics team mem\u00adbers Ilk\u00adka Ellil\u00e4 and Mikko Antti\u00adla. How do we lever\u00adage Microsoft cloud ser\u00advices to sup\u00adport our cus\u00adtomers\u2019 busi\u00adness and suc\u00adcess? What are the ben\u00ade\u00adfits and how can they be uti\u00adlized in dif\u00adfer\u00adent imple\u00admen\u00adta\u00adtions? What are the most antic\u00adi\u00adpat\u00aded new fea\u00adtures in these ser\u00advices in the near future and why?<\/strong><\/p>\n We both have vast expe\u00adri\u00adence in using the Microsoft ecosys\u00adtem in data ware\u00adhous\u00ading projects, cod\u00ading expe\u00adri\u00adence from the past and we both have been Microsoft cer\u00adti\u00adfied in areas of our per\u00adson\u00adal inter\u00adests. Mikko has been spe\u00adcial\u00adiz\u00ading into the Data Plat\u00adform side, and Ilk\u00adka gain\u00ading knowl\u00adedge of the fast-grow\u00ading part of low-code devel\u00adop\u00adment in Pow\u00ader Plat\u00adform and how it can be har\u00adnessed to boost effec\u00adtive\u00adness in the Data & Ana\u00adlyt\u00adics envi\u00adron\u00adment and stream\u00adline busi\u00adness users, data engi\u00adneers or ana\u00adlysts\u2019 workflows.<\/p>\n Year 2022 was full of new releas\u00ades in Microsoft Data and Pow\u00ader Plat\u00adform areas. Thoughts were thrown around in Teams about new fea\u00adtures and we came close to test\u00ading them all\u2026 Here are our most impor\u00adtant findings:<\/p>\n <\/p>\n Pow\u00ader Apps had some great releas\u00ades in 2022 regard\u00ading espe\u00adcial\u00adly the devel\u00adop\u00adment of Pow\u00ader\u00adApps Can\u00advas app, but first I think I should cast some light on Pow\u00ader Plat\u00adform devel\u00adop\u00adment with\u00adin data ware\u00adhous\u00ading envi\u00adron\u00adment in general.<\/p>\n When Pow\u00ader Plat\u00adform is need\u00aded in projects, we use Pow\u00ader Apps Can\u00advas with SQL con\u00adnec\u00adtor and Pow\u00ader Auto\u00admate (Flow) in most cases.<\/p>\n <\/p>\n Best or most dis\u00adcussed things (2022)\u2009\u2014\u2009Pow\u00ader Apps<\/strong><\/p>\n Search<\/a> <\/strong>and Find and Replace<\/a><\/strong> in gen\u00ader\u00adal might sound not that new and ground break\u00ading, but in fact, the Pow\u00ader\u00adApps Can\u00advas<\/strong> app was lack\u00ading just that. It changed renam\u00ading, code check\u00ading, vari\u00adable han\u00addling, them\u00ading etc. from agony to easy-mode. It has real\u00adly made the whole devel\u00adop\u00adment expe\u00adri\u00adence way better.<\/p>\n <\/p>\n AI was the big top\u00adic at the end of year 2022. AI seems to be the answer for everything.<\/p>\n Even Pow\u00ader\u00adApps Can\u00advas had its share of AI. Now you can code even less with Pow\u00ader Apps Ideas<\/a><\/strong>. Ideas enables the devel\u00adop\u00ader to just write the want\u00aded abil\u00adi\u00adty that Pow\u00ader\u00adFx should do and Ideas pro\u00advides the com\u00adment\u00aded code for it. I have not per\u00adson\u00adal\u00adly test\u00aded this abil\u00adi\u00adty broad\u00adly because my most used Pow\u00ader\u00adFx com\u00admands are already quite clear\u2009\u2014\u2009although if there were a lot to write and the use-case was pre\u00adsent\u00aded in clear man\u00adner for Ideas, it could lead to even less time spent cod\u00ading\u2026 These are still kind of mind-bog\u00adgling abil\u00adi\u00adties but clear\u00adly the future of coding.<\/p>\n Also, if you decide to code your\u00adself, then it can help fix\u00ading the prob\u00adlems with For\u00admu\u00adla Repair<\/a><\/strong> (pre\u00adview)<\/p>\n <\/p>\n Envi\u00adron\u00adment group\u00ading and changes in keep\u00ading the envi\u00adron\u00adment active<\/a><\/strong> is pret\u00adty handy when work\u00ading with many dif\u00adfer\u00adent envi\u00adron\u00adments and it real\u00adly helps with the work\u00adflow. There was noth\u00ading more frus\u00adtrat\u00ading than to des\u00ade\u00adlect the Default envi\u00adron\u00adment every\u2026, sin\u00adgle\u2026, time, when log\u00adging into make\u200b.pow\u200ber\u200bapps\u200b.com.<\/p>\n <\/p>\n Things to look for\u00adward to (2023)\u2009\u2014\u2009Pow\u00ader Apps<\/strong><\/p>\n Usu\u00adal\u00adly, Cod\u00ading project in gen\u00ader\u00adal does include mul\u00adti\u00adple devel\u00adop\u00aders doing simul\u00adta\u00adne\u00adous devel\u00adop\u00adment work. Co-author\u00ading fea\u00adture and Git<\/a><\/strong> repos\u00adi\u00adto\u00adry use can help with this. Git inte\u00adgra\u00adtion helps with Can\u00advas app and Mod\u00adern app.<\/p>\n With Can\u00advas app you will be able to use Git and there\u00adfore make use of Git\u2019s pow\u00ader\u00adful fea\u00adtures while devel\u00adop\u00adment. Mod\u00adel dri\u00adven apps will have an Office-like \u201cCoau\u00adthor\u00ading\u201d expe\u00adri\u00adence<\/a><\/strong> where you see every change made by your co-work\u00aders in real-time.<\/p>\n Com\u00adments<\/a> <\/strong>are great way to add notes and ques\u00adtions about the code and share infor\u00adma\u00adtion inside a team developers.<\/p>\n <\/p>\n Every\u00adone doing Can\u00advas devel\u00adop\u00adment knows App.OnStart and what it can do and what cer\u00adtain prob\u00adlems it can have regard\u00ading to the start-times of the app. Usu\u00adal\u00adly the prob\u00adlems appear when hav\u00ading mul\u00adti\u00adple glob\u00adal para\u00adme\u00adters set-up on appli\u00adca\u00adtion start. If you are fetch\u00ading data from the data\u00adbase lay\u00ader, and set\u00adting that data to para\u00adme\u00adters, then the data down\u00adload times may cause delays is actu\u00adal appli\u00adca\u00adtion start.<\/p>\n Named For\u00admu\u00adlas<\/a><\/strong> will stream\u00adline the use of basic para\u00adme\u00adters by set\u00adting those as named for\u00admu\u00adlas. When using the for\u00admu\u00adla in your appli\u00adca\u00adtion it will have the val\u00adues ready to go but load\u00ading those won\u2019t affect the actu\u00adal appli\u00adca\u00adtion start.<\/p>\n <\/p>\n You can cre\u00adate a work\u00ading app UI from your team\u2019s plan\u00adning white\u00adboard by just tak\u00ading a pic\u00adture and upload\u00ading it<\/a><\/strong>. This fea\u00adture is at a \u201cfun demo\u201d stage at the moment, but it can real\u00adly become some\u00adthing in the future. Tried it and yes, it cre\u00adat\u00aded the app, but some texts were not read cor\u00adrect\u00adly, and some box\u00ades were missed. Did my best to have as basic box\u00ades and font as I could. For demo pur\u00adpos\u00ades I will most cer\u00adtain\u00adly keep this in my playbook.<\/p>\n And if you real\u00adly want to head start plan\u00adning your UIs with some\u00adthing else than Can\u00advas app Design\u00ader, with Fig\u00adma files<\/a><\/strong> you can cre\u00adate the app\u2019s every screen. UI spe\u00adcial\u00adists can still use their Fig\u00adma and you can just ask them to cre\u00adate a new cool UI.<\/p>\n <\/p>\n Auto\u00admat\u00aded deploy\u00adment pipelines have been used in devel\u00adop\u00adment projects to auto\u00admate the solu\u00adtions deploy\u00adments into the new envi\u00adron\u00adments. Most impor\u00adtant aspect has been improved vis\u00adi\u00adbil\u00adi\u00adty about the sit\u00adu\u00ada\u00adtion between envi\u00adron\u00adments and the his\u00adto\u00adry of deployments.<\/p>\n Pow\u00ader\u00adPlat\u00adform pipelines<\/a><\/strong> will be its own instal\u00adlable appli\u00adca\u00adtion that you install into the select\u00aded envi\u00adron\u00adment. With the app you can man\u00adage all the envi\u00adron\u00adments and see the audit logs, deploy\u00adment activ\u00adi\u00adties, access errors and much more.<\/p>\n <\/p>\n Pow\u00ader BI devel\u00adop\u00adment is and will be an impor\u00adtant part of Data & Ana\u00adlyt\u00adics teams\u2019 work. Mod\u00adels, mea\u00adsures, and visu\u00adal\u00adiza\u00adtions do not hap\u00adpen by them\u00adselves, although AI can nowa\u00addays make nice sug\u00adges\u00adtions, but still good ana\u00adlyt\u00adi\u00adcal insights into the data con\u00adtext are need\u00aded to make report\u00ading solu\u00adtions work correctly.<\/p>\n There aren\u2019t many as fast evolv\u00ading report\u00ading envi\u00adron\u00adments as Pow\u00ader BI around, so keep\u00ading up with new fea\u00adtures is important.<\/p>\n <\/strong><\/p>\n Best or most dis\u00adcussed things (2022)\u2009\u2014\u2009Pow\u00ader BI<\/strong><\/p>\n Cre\u00adat\u00ading Power\u00adBI datasets has not always been as flex\u00adi\u00adble as now, and more improve\u00adments are com\u00ading. The com\u00adpos\u00adite mod\u00adels have proven to be good way to imple\u00adment datasets com\u00adbin\u00ading once-a-day-refresh\u00ading, \u201cdata ware\u00adhous\u00ading\u201d data, and dai\u00adly chang\u00ading user input (Pow\u00ader\u00adApps etc). Look and feel are that of a real-time report with this \u201cwow\u201d fac\u00adtor. We\u2019ve used this for many datasets and it always strikes me as \u201clook, how cool is this?\u201d<\/p>\n The fea\u00adture has more releas\u00ades com\u00ading and now we are able to use the Azure Analy\u00adsis Ser\u00advices mod\u00adels in com\u00adpos\u00adite model.<\/a><\/strong><\/p>\n <\/p>\n Refresh\u00ading a big dataset can be time-con\u00adsum\u00ading. In Pow\u00ader BI Pro work\u00adspace the max\u00adi\u00admum dataset size is 1GB and usu\u00adal\u00adly that max\u00adi\u00admum capac\u00adi\u00adty is not met, or you would be real\u00adly stretch\u00ading the capacity.<\/p>\n In Pre\u00admi\u00adum capac\u00adi\u00adty the datasets can be a lot big\u00adger, there\u00adfore if you had miss-clicked a dataset refresh, the pro\u00adcess\u00ading can take ages. It is very con\u00adve\u00adnient to be able to can\u00adcel the cur\u00adrent dataset refresh<\/a>.<\/strong><\/p>\n <\/p>\n Things to look for\u00adward to (2023)\u2009\u2014\u2009Pow\u00ader BI<\/strong><\/p>\n Pow\u00ader BI Pre\u00admi\u00adum has been adding fea\u00adtures into its datasets and is now pret\u00adty close to Azure Analy\u00adsis Ser\u00advices. Microsoft announced an auto\u00admat\u00aded migra\u00adtion tool that allows users to migrate their Azure Analy\u00adsis Ser\u00advices mod\u00adels into Pow\u00ader BI datasets<\/a><\/strong>. Lat\u00ader they will add a Pow\u00ader BI report rebind tool, but for now the report rebind\u00ading must be done manually.<\/p>\n With mod\u00adels in Pow\u00ader BI Pre\u00admi\u00adum you have a cen\u00adtral\u00adized place for the data and enjoy cost-relat\u00aded benefits.<\/p>\n <\/p>\n Soon you can cre\u00adate datasets in the Pow\u00ader BI ser\u00advice and then share those to users in a dif\u00adfer\u00adent ten\u00adant. It has a lot of real-world use cas\u00ades for exam\u00adple in busi\u00adness-to-busi\u00adness data shar\u00ading, and data col\u00adlab\u00ado\u00adra\u00adtion also offers busi\u00adness cas\u00ades for new features.<\/p>\n <\/strong><\/p>\n Azure Data Plat\u00adform is the back\u00adbone of a data ware\u00adhous\u00ading solu\u00adtion. Con\u00adtin\u00adu\u00adous fea\u00adture upgrades and new ways to imple\u00adment work\u00ading solu\u00adtions will keep devel\u00adop\u00adment work com\u00adpelling and meaningful.<\/p>\n <\/p>\n Best or most dis\u00adcussed things (2022)\u2009\u2014\u2009Azure Data Platform<\/strong><\/p>\n Auto\u00admat\u00aded ML pro\u00advides a user less expe\u00adri\u00adenced with fore\u00adcast\u00ading mod\u00adels, some good tools to offer usable, code-com\u00adment\u00aded, mod\u00adels. It won\u2019t remove the need for data sci\u00aden\u00adtists because the mod\u00adel is just a start that requires tweaks and mak\u00ading sure that the fore\u00adcast\u00ading mod\u00adels are opti\u00admized for more accu\u00adrate or com\u00adplex use cases.<\/p>\n After test\u00ading the fea\u00adture, I was amazed as there were a large num\u00adber of mod\u00adels and each mod\u00adel could be giv\u00aden a com\u00adment\u00aded ver\u00adsion if desired. On the whole, every\u00adthing was well doc\u00adu\u00adment\u00aded, only some undoc\u00adu\u00adment\u00aded fea\u00adtures remained.<\/p>\n <\/p>\n One of the most notice\u00adable new things in Azure Data Fac\u00adto\u00adry was that the val\u00adi\u00adda\u00adtion for cer\u00adtain com\u00adpo\u00adnents were made more intel\u00adli\u00adgent. Once you could use some com\u00adpo\u00adnents nest\u00aded and con\u00adtin\u00adue devel\u00adop\u00adment until the first time you tried to debug the run, and only then it would state that that is not the sup\u00adport\u00aded way to use the com\u00adpo\u00adnents. And then you would need to refac\u00adtor the whole thing again. Now you can\u2019t real\u00adly use the com\u00adpo\u00adnents in the way they are not sup\u00adport\u00aded. Also one wel\u00adcomed improve\u00adment: default time\u00adout was changed from 7 days to 12 hours.<\/p>\n <\/p>\n The fea\u00adture offers near real-time data move\u00adment from SQL (Azure SQL Data\u00adbase or SQL Serv\u00ader 2022) to Synapse Ded\u00adi\u00adcat\u00aded pool.<\/a><\/strong> That is great for fast report\u00ading needs. You can even have some dai\u00adly oper\u00ada\u00adtional report\u00ading done via your data ware\u00adhous\u00ading envi\u00adron\u00adment as you can see the \u201ccur\u00adrent\u201d\u2009\u2014\u2009almost live\u2009\u2014\u2009sit\u00adu\u00ada\u00adtion on reports when con\u00adfig\u00adured cor\u00adrect\u00adly. Of course, this doesn\u2019t remove the need for the actu\u00adal report\u00ading mod\u00adels and inte\u00adgra\u00adtions of a data ware\u00adhous\u00ading envi\u00adron\u00adment, but gives some rope on how often the data can be refreshed.<\/p>\n <\/strong><\/p>\n Things to look for\u00adward to (2023)\u2009\u2014\u2009Azure Data Platform<\/strong><\/p>\n Fea\u00adture still in pre\u00adview and only avail\u00adable for Pow\u00ader BI Pre\u00admi\u00adum ver\u00adsion. Data gate\u00adway cre\u00adat\u00aded a Secure con\u00adnec\u00adtion to VNET and removes the need for On-Prem gate\u00adway when con\u00adnect\u00ading to resources on pri\u00advate VNET.<\/a><\/strong> This makes con\u00adnect\u00ading a lot eas\u00adi\u00ader and removes most of the admin\u00adis\u00adtra\u00adtive work need\u00aded to keep the gate\u00adway running.<\/p>\n <\/p>\n Trig\u00adger\u00ading basi\u00adcal\u00adly any REST API from your Azure SQL DB<\/a><\/strong> is now pos\u00adsi\u00adble and this offers so many ways of using pro\u00adce\u00addures etc. There is a list<\/a><\/strong> on the doc\u00adu\u00admen\u00adta\u00adtion page that states all the allowed end\u00adpoints, but you can also expose your own API. Of course, you can use func\u00adtion app or some\u00adthing like Pow\u00ader Auto\u00admate runs that are exposed as REST.<\/p>\n If you want to invoke a REST ser\u00advice that is not with\u00adin the allowed list, you can use API Man\u00adage\u00adment to secure\u00adly expose the desired ser\u00advice and make it avail\u00adable to sp_invoke_external_rest_endpoint<\/em><\/p>\n <\/p>\n This fea\u00adture is still in pre\u00adview, but it is a must-have for every\u00adone using the Man\u00adaged Vir\u00adtu\u00adal Net\u00adworks in Synapse. Before this fea\u00adture, resources had to be fetched for each call with\u00adin the loop sep\u00ada\u00adrate\u00adly. Now, Time-To-Live fea\u00adture<\/a><\/strong> can be used to assign resource a life\u00adtime that deter\u00admines how long it will be reused for. The ben\u00ade\u00adfit of this is big when, for exam\u00adple, copy\u00ading func\u00adtions are run in a large loop, and the resource need\u00aded for copy\u00ading is not always recre\u00adat\u00aded, but an exist\u00ading one is used.<\/p>\n <\/p>\n Nat\u00adu\u00adral\u00adly, Microsoft is con\u00adstant\u00adly devel\u00adop\u00ading its solu\u00adtions, and more and more fea\u00adtures are being added all the time. So we stay alert and always ready to learn, and for a good rea\u00adson \u2013 the ben\u00ade\u00adfits they bring can be big. 2022 was a great year in this con\u00adtext, and we can\u2019t wait for the next year.<\/p>\n <\/p>\n Best regards,<\/p>\n Mikko and Ilkka<\/p>\n <\/p>\n Ps. More excit\u00ading things are com\u00ading up next year from us, so stay tuned!<\/p>\n Pps. Below some enthu\u00adsi\u00adas\u00adtic vibes from Microsoft\u00ad\u2019s Part\u00adner Archi\u00adtects Day. Best thing over\u00adall about 2022 was to be able to meet and greet peo\u00adple in real-life.<\/p>\n <\/p>\n [\/et_pb_text][et_pb_image src=\u201chttps:\/\/isletgroup.fi\/wp-content\/uploads\/2022\/12\/Picture1-311222.jpg\u201d title_text=\u201cPicture1-311222\u201d _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][\/et_pb_image][et_pb_text _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n <\/p>\n <\/p>\n Ppps. If inter\u00adest\u00aded, read more about our Data & Ana\u00adlyt\u00adics ser\u00advices here<\/a><\/strong><\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201c4_4\u201d _builder_version=\u201c4.16\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201c4.17.4\u201d _module_preset=\u201cdefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n #Islet\u00adGroup #data #ana\u00adlyt\u00adics #Pow\u00ader\u00adPlat\u00adform #Dat\u00ada\u00adPlat\u00adform #Microsoft #report\u00ading<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Let\u2019s dive into the world of Microsoft Data Plat\u00adform and Pow\u00ader Plat\u00adform, and specif\u00adi\u00adcal\u00adly the events and most impact\u00adful releas\u00ades in our view, Islet\u2019s Data & Ana\u00adlyt\u00adics team mem\u00adbers Ilk\u00adka Ellil\u00e4 and Mikko Antti\u00adla. How do we lever\u00adage Microsoft cloud ser\u00advices to sup\u00adport our cus\u00adtomers\u2019 busi\u00adness and suc\u00adcess? What are the ben\u00ade\u00adfits and how can [\u2026]<\/p>\n","protected":false},"author":20,"featured_media":228310,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":" [et_pb_section fb_built=\"1\" _builder_version=\"4.16\" _module_preset=\"default\" da_disable_devices=\"off|off|off\" global_colors_info=\"{}\" da_is_popup=\"off\" da_exit_intent=\"off\" da_has_close=\"on\" da_alt_close=\"off\" da_dark_close=\"off\" da_not_modal=\"on\" da_is_singular=\"off\" da_with_loader=\"off\" da_has_shadow=\"on\"][et_pb_row _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\"][et_pb_column type=\"4_4\" _builder_version=\"4.16\" _module_preset=\"default\" global_colors_info=\"{}\"][et_pb_text _builder_version=\"4.17.4\" _module_preset=\"default\" text_orientation=\"justified\" hover_enabled=\"0\" global_colors_info=\"{}\" sticky_enabled=\"0\"]<\/p> T\u00e4ss\u00e4 blogikirjoituksessa sukelletaan n\u00e4in vuoden lopun kunniaksi Microsoft Data Platformin ja Power Platformin maailmaan. N\u00e4iden pilvipalveluiden tuomaa lis\u00e4arvoa ja mahdollisuuksia tarkastellaan k\u00e4yt\u00e4nn\u00f6ss\u00e4 p\u00e4iv\u00e4ns\u00e4 n\u00e4iden ratkaisujen parissa viett\u00e4v\u00e4n kahden pilvidata-arkkitehdin, Ilkan ja Mikon, n\u00e4k\u00f6vinkkelist\u00e4. Kuinka me hy\u00f6dynn\u00e4mme Microsoftin pilvipalveluita tukeaksemme asiakkaidemme liiketoimintaa ja menestyst\u00e4? Mit\u00e4 hy\u00f6tyj\u00e4 n\u00e4ist\u00e4 on ja kuinka niit\u00e4 voidaan hy\u00f6dynt\u00e4\u00e4 erilaisissa toteutuksissa? Mitk\u00e4 ovat eniten odottamamme uudet ominaisuudet n\u00e4iss\u00e4 palveluissa l\u00e4hitulevaisuudessa ja miksi?<\/p> Meill\u00e4 molemmilla on pitk\u00e4 kokemus Microsoftin ekosysteemin k\u00e4yt\u00f6st\u00e4 tietovarastoinnin puolella, ja molemmilla on my\u00f6s koodauskokemusta menneisyydest\u00e4. Viimeisimp\u00e4n\u00e4 muttei v\u00e4h\u00e4isimp\u00e4n\u00e4, olemme molemmat Microsoft pilvisertifioituja omilla vahvimmilla osa-alueillamme; Mikko on erikoistunut Data Platform- puolelle ja Ilkka tekee paljon low-code- kehityst\u00e4 Power Platformilla ja yritt\u00e4\u00e4 hy\u00f6dynt\u00e4\u00e4 sit\u00e4 tietovarastoinnin n\u00e4k\u00f6kulmasta parhaalla mahdollisella tavalla.<\/p> Vuodelta 2022 Islettereiden lokikirjoihin j\u00e4i merkint\u00f6j\u00e4 useammista Microsoft Data- ja Power Platformiin liittyvist\u00e4 julkaisuista ja uudistuksista. Alla onkin nyt summattuna kiinnostavimpia nostoja aiheittain. Emme malttaneet olla kiikaroimasta hieman my\u00f6s jo tulevaan ja siihen, mit\u00e4 uusia mahdollisuuksia uusi vuosi 2023 tuo tullessaan n\u00e4iden ratkaisujen saralla.<\/p> \u00a0<\/p> POWER APPS<\/strong><\/p> Power Appsilla oli vuonna 2022 uusia julkaisuja erityisesti PowerApps Canvas- sovelluksen kehityksess\u00e4, mutta olisi hyv\u00e4 hieman valaista v\u00e4h\u00e4n my\u00f6s sit\u00e4, miksi Power Platform-kehitys kannattaisi sis\u00e4llytt\u00e4\u00e4 tietovarastointiymp\u00e4rist\u00f6\u00f6n.<\/p> Jos asiakasl\u00e4ht\u00f6ist\u00e4 tiedonsy\u00f6tt\u00f6\u00e4 tai hallintaa tarvitaan, k\u00e4yt\u00e4mme useimmin Power Apps- Canvasia SQL- liittimell\u00e4 ja Power Automatella (Flow). T\u00e4h\u00e4n liittyv\u00e4t lisenssiasiat ovat itsess\u00e4\u00e4n ihan oman blogin arvoinen juttu, joten j\u00e4t\u00e4mme ne t\u00e4ll\u00e4 er\u00e4\u00e4 k\u00e4ym\u00e4tt\u00e4 l\u00e4pi, ja keskitymme eri ominaisuuksiin.<\/p> \u00a0<\/p> Parhaat tai eniten keskustelua her\u00e4tt\u00e4neet asiat (2022) \u2013 Power Apps<\/strong><\/p> \u00a0<\/p> Haku- <\/strong><\/a>tai Etsi ja korvaa -toiminto<\/a><\/strong> yleisesti ottaen eiv\u00e4t ehk\u00e4 kuulosta kovin uusilta tai uraauurtavilta ominaisuuksilta, mutta itse asiassa PowerApps Canvas<\/a><\/strong>- kehitt\u00e4misest\u00e4 ne ovat aikaisemmin viel\u00e4 puuttuneet. Nyt uusien toimintojen avulla uudelleen nime\u00e4miset, koodin tarkistukset, muuttujien k\u00e4sittely, teeman muutokset (l\u00e4hinn\u00e4 v\u00e4rien vaihdokset) jne. tulivat helpoiksi. Ne tehostavat toimintaa ja muuttavat koko kehityskokemusta selke\u00e4sti parempaan suuntaan.<\/p> \u00a0<\/p> Teko\u00e4ly on ollut iso aihe vuoden 2022 lopulla. Teko\u00e4ly n\u00e4ytt\u00e4\u00e4 olevan vastaus kaikkeen.<\/p> PowerApps Canvasilla on jo nyt olemassa omat teko\u00e4lyll\u00e4 toimivat ominaisuudet. Power Apps Ideas- ominaisuuden<\/a><\/strong> avulla voit koodata jopa entist\u00e4 v\u00e4hemm\u00e4n. Ideas mahdollistaa, ett\u00e4 kehitt\u00e4j\u00e4 voi kirjoittaa selkokielell\u00e4 halutun kyvyn, joka PowerFx:n pit\u00e4isi toteuttaa, ja Ideas antaa sinulle erikseen kommentoidun koodin, mit\u00e4 kyseinen koodinp\u00e4tk\u00e4 tekee. N\u00e4it\u00e4 kykyj\u00e4 ei ole tultu testailtua, koska eniten k\u00e4ytetyt PowerFx-komennot ovat jo melko selkeit\u00e4, mutta jos koodattavaa olisi paljon ja k\u00e4ytt\u00f6tapaus esitett\u00e4isiin selke\u00e4sti Ideasille, se voisi johtaa viel\u00e4 koodausm\u00e4\u00e4r\u00e4n pienenemiseen ja sit\u00e4 kautta ajank\u00e4ytt\u00f6\u00f6n v\u00e4hent\u00e4v\u00e4sti. N\u00e4m\u00e4 ovat edelleen varsin h\u00e4mment\u00e4vi\u00e4 kykyj\u00e4, mit\u00e4 teko\u00e4ly voi tarjota, mutta se on selv\u00e4sti koodauksen tulevaisuutta.<\/p> Lis\u00e4ksi, jos p\u00e4\u00e4t\u00e4t koodata itse, voit k\u00e4ytt\u00e4\u00e4 apunasi uutta Formula Repair- koodikorjausominaisuutta<\/a><\/strong> ongelmien ratkomiseksi (esikatselu).<\/p> \u00a0<\/p> Ymp\u00e4rist\u00f6ryhmittely ja muutokset ymp\u00e4rist\u00f6n aktiivisena\/valittuna pit\u00e4miseen<\/strong><\/a> on helpottanut paljon ty\u00f6skennelless\u00e4 monien eri ymp\u00e4rist\u00f6jen kanssa. Ei ole ollut mit\u00e4\u00e4n turhauttavampaa, kuin vaihtaa Default-ymp\u00e4rist\u00f6n valinta joka kerta, kun kirjaudut make.powerapps.com.<\/p> \u00a0<\/p> Uudet tulevat ominaisuudet (2023) \u2013 Power Apps<\/strong><\/p> \u00a0<\/p> Yleens\u00e4 sovelluskehitysprojektissa on useita kehitt\u00e4ji\u00e4, jotka tekev\u00e4t kehitysty\u00f6t\u00e4 yhteiseen sovellukseen samanaikaisesti. T\u00e4m\u00e4n yhteisty\u00f6n sujuvoittamiseen on tulossa muutama hyv\u00e4 ominaisuus. Canvas- kehityksess\u00e4 voit k\u00e4ytt\u00e4\u00e4 Giti\u00e4<\/a><\/strong> ja siten hy\u00f6dynt\u00e4\u00e4 Gitin tehokkaita ominaisuuksia kehitysty\u00f6ss\u00e4. Mallipohjaisissa (Model-driven) kehityksess\u00e4 on Office- tyyppinen \"Coauthoring\"-kokemus<\/a>,<\/strong> jossa n\u00e4et kaikki ty\u00f6toverisi tekem\u00e4t muutokset reaaliajassa. Kommentit<\/a>-ominaisuus<\/strong> mahdollistaa koodia koskevien huomautusten ja kysymysten lis\u00e4\u00e4misen sek\u00e4 tiedon jaon tiimin kehitt\u00e4jien v\u00e4lill\u00e4 suoraan Canvas- sovelluksen kehitysn\u00e4kym\u00e4ss\u00e4.<\/p> \u00a0<\/p> Jokainen Canvas- kehityst\u00e4 tekev\u00e4 tuntee App.OnStart- funktion ja sen, mit\u00e4 se voi tehd\u00e4 ja mit\u00e4 tiettyj\u00e4 ongelmia sill\u00e4 voi olla sovelluksen k\u00e4ynnistysaikoihin liittyen. Yleens\u00e4 ongelmat ilmenev\u00e4t, kun useita globaaleja parametreja on m\u00e4\u00e4ritetty sovelluksen k\u00e4ynnistyksen yhteydess\u00e4. Jos haet tietoja tietokantakerroksesta ja asetat tiedot parametreiksi, tietojen latausajat voivat aiheuttaa viiveit\u00e4 sovelluksen varsinaisessa k\u00e4ynnistyksess\u00e4.<\/p> Nimetyt kaavat<\/a><\/strong> tehostavat perusparametrien k\u00e4ytt\u00f6\u00e4 asettamalla ne nimetyiksi kaavoiksi. Kun k\u00e4yt\u00e4t kaavaa sovelluksessasi, arvot ovat valmiina k\u00e4ytt\u00f6\u00f6n, mutta niiden lataaminen ei vaikuta sovelluksen varsinaiseen k\u00e4ynnist\u00e4miseen.<\/p> \u00a0<\/p> Nyt voit luoda toimivan k\u00e4ytt\u00f6liittym\u00e4n suoraan tiimisi suunnittelutaululta ottaman kuvan avulla ja lataamalla sen palveluun<\/a>.<\/strong> T\u00e4m\u00e4 ominaisuus tuntuu olevan viel\u00e4 \"hauska demo\" -vaiheessa, mutta se voi tulevaisuudessa tulla \u00e4lykk\u00e4\u00e4mm\u00e4ksikin. Kokeilimme ominaisuutta ja kyll\u00e4, se teki sovelluksen, mutta joitain tekstej\u00e4 ominaisuus ei lukenut oikein ja jotkut laatikot j\u00e4iv\u00e4t generoitumatta. K\u00e4ytt\u00f6liittym\u00e4 oli piirretty mahdollisimman tarkasti. Todenn\u00e4k\u00f6isesti t\u00e4t\u00e4 tullaan n\u00e4ytt\u00e4m\u00e4\u00e4n, jos halutaan demonstroida Power Platformin uusia hienoja ominaisuuksia ja mahdollisuuksia.<\/p> Jos todella haluat aloittaa k\u00e4ytt\u00f6liittym\u00e4si suunnittelun jollakin muulla kuin Canvas- sovelluksen editointiportaalista, niin nyt se onnistuu suoraan Figma-tiedostoilla<\/a>.<\/strong> Voit luoda koko sovelluksen jokaisen tarvittavan n\u00e4yt\u00f6n. K\u00e4ytt\u00f6liittym\u00e4asiantuntijat voivat k\u00e4ytt\u00e4\u00e4 Figmaa, ja voit pyyt\u00e4\u00e4 heit\u00e4 luomaan k\u00e4ytt\u00f6liittym\u00e4n.<\/p> \u00a0<\/p> Automatisoituja k\u00e4ytt\u00f6\u00f6nottoputkia on k\u00e4ytetty kehitysprojekteissa automatisoimaan ratkaisujen k\u00e4ytt\u00f6\u00f6nottoa ylempiin testaus- ja tuotantoymp\u00e4rist\u00f6ihin. T\u00e4rkeint\u00e4 t\u00e4ss\u00e4\u00a0 on yleens\u00e4 parantaa n\u00e4kyvyytt\u00e4 ymp\u00e4rist\u00f6jen v\u00e4lisest\u00e4 tilanteesta ja versiohistoriasta.<\/p> PowerPlatform- putkistot<\/a><\/strong> ovat oma asennettava sovellus, jonka asennat valittuun ymp\u00e4rist\u00f6\u00f6n. Sovelluksella voit hallita kaikkia ymp\u00e4rist\u00f6j\u00e4 ja n\u00e4hd\u00e4 tarkastuslokit, k\u00e4ytt\u00f6\u00f6nottotoiminnot, k\u00e4ytt\u00f6virheet ja paljon muuta.<\/p> \u00a0<\/p> \u00a0<\/p> POWER BI<\/strong><\/p> Power BI -kehitys on ja tulee olemaan t\u00e4rke\u00e4 osa Isletin Data & analytiikka- tiimien ty\u00f6t\u00e4. Mallit, mittarit ja visualisoinnit eiv\u00e4t synny itsest\u00e4\u00e4n, vaikka teko\u00e4ly voi nyky\u00e4\u00e4n antaa mukavia ehdotuksia, mutta silti tarvitaan hyvi\u00e4 analyyttisi\u00e4 n\u00e4kemyksi\u00e4 datakontekstista, jotta raportointiratkaisut toimivat oikein. Power BI on nopeasti kehittyv\u00e4 raportointiymp\u00e4rist\u00f6, joten uusien ominaisuuksien per\u00e4ss\u00e4 pysyminen on t\u00e4rke\u00e4\u00e4.<\/p> \u00a0<\/strong><\/p> Parhaat tai eniten keskustelua her\u00e4tt\u00e4neet asiat \u00a0(2022) - Power BI<\/strong><\/p> \u00a0<\/p> PowerBI- tietojoukkojen luominen ei ole aina ollut niin joustavaa kuin mit\u00e4 se nyky\u00e4\u00e4n on, ja lis\u00e4\u00e4 parannuksia on tulossa. Komposiittimallit ovat osoittautuneet hyv\u00e4ksi tavaksi toteuttaa tietojoukkoja, joissa esimerkiksi yhdistyv\u00e4t kerran p\u00e4iv\u00e4ss\u00e4 p\u00e4ivitett\u00e4v\u00e4n tietovaraston tiedot ja p\u00e4ivitt\u00e4in vaihtuva k\u00e4ytt\u00e4j\u00e4n sy\u00f6te (PowerApps jne.). Siten on mahdollista saada aikaiseksi reaaliaikaisesti p\u00e4ivittyv\u00e4t visualisoinnit ja data. Olemme k\u00e4ytt\u00e4neet t\u00e4t\u00e4 ominaisuutta paljon. Se on hieno tunne, kun tiedonsy\u00f6tt\u00e4misen j\u00e4lkeen juuri sy\u00f6tetyt tiedot nousevat raportille raportin sivun p\u00e4ivitt\u00e4misen j\u00e4lkeen. Ominaisuudesta on viel\u00e4 julkaisuja tulossa, ja nyt uutena asiana on, ett\u00e4 voimme k\u00e4ytt\u00e4\u00e4 Azure Analysis Services -malleja komposiittimallissa<\/strong>.<\/a><\/p> \u00a0<\/p> Suuren tietojoukon p\u00e4ivitt\u00e4minen voi kest\u00e4\u00e4 todella pitk\u00e4\u00e4n. Power BI Pro -ty\u00f6tilassa tietojoukon enimm\u00e4iskoko on 1 Gt ja yleens\u00e4 sen maksimikapasiteetti ei t\u00e4yty, tai muuten ollaan todella rajoilla ratkaisun kest\u00e4vyyden kanssa.<\/p> Premium-kapasiteetissa tietojoukot voivat olla paljon suurempia, joten jos olet klikannut tietojoukon p\u00e4ivityst\u00e4 vahingossa, prosessointi voi kest\u00e4\u00e4 kauan. On k\u00e4tev\u00e4\u00e4 pysty\u00e4 peruuttamaan nykyinen tietojoukon p\u00e4ivitys kesken prosessoinnin<\/a><\/strong>.<\/p> \u00a0<\/strong><\/p> Uudet tulevat ominaisuudet (2023) - Power BI<\/strong><\/p> \u00a0<\/p>POW\u00adER APPS<\/strong><\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
POW\u00adER BI<\/strong><\/h3>\n
\n
\n
\n
\n
AZURE DATA PLATFORM<\/strong><\/h3>\n
\n
\n
\n
\n
\n
\n