Microsoft Power BI Flow and PowerApps: Connecting to data using the on-premises data – BRK3048

>> SO WELCOME EVERYONE. THANK YOU FOR COME TO THE ON PREMISE DATA GETWAY. I AM THE PROGRAM MANAGER FOR ON PREMISE GATEWAY AND THIS IS NAVEEN. >> SO HYBRID DATA LANDSCAPES ARE QUITE COMMON. ENTERPRISE CHOOSE TO HAVE THE DAY ON CLOUD OR ON PREMISE OR A COMBINATION OF BOTH, BUT THEY CAN STILL USE CLOUD SERVICES LIKE POWER BI, POWERAPPS TO CONNECT THE DATA TO ON PREMISE. HOW DO WE ENABLE THAT. IT ACTS AS A BRIDGE BETWEEN YOUR CLOUD SERVICES AND YOUR ON PREMISE DAY. AND IT NEEDS TO BE INSTALLED ON A DOMAIN MACHINE AND IT USES THE AZURE SERVICE BUS RETREES SECURELY COMMUNICATE WITH YOUR CLOUD SERVICES . THE — THE ON PREMISE DATA GTHE — THE ON PREMISE DATA GATEWAY COULD BE USED AS DESIGNED WITH DIFFERENT APPLICATIONS. SO, FOR INSTANCE, POWER BI WOULD USE ON PREM MISS IS GATEWAY TO REFRESH AND POWERAPPS COULD BE USED TO WRITE ACTIONS TO AN ON PREMISE DATA SOURCE SO JUST TO. JUST TO GO WITH THIS AGAIN, THE ON PREMISE DATA GETWAY PROVIDE A SECURE AND OPTIMIZED COMMUNICATION CHANNEL TO CONNECT TO YOUR CLOUD SERVICES WITH YOUR ON PREM DAY NOT THE GENERAL FOCUS AND THAT MEANS YOU CAN’T CONNECT SERVICE WITH THE ON PREM GATEWAY. YOU WILL NEED TO CONNECT IT WITH ONE OF THE SERVICES WE CALLED OUT IN THE EARLIER SLCALLED OUT IN THE EARLIER SLIDE. IT NEEDS TO BE INSTALLED ON A DOMAIN MACHINE, AND YOU DO NOT HAVE TO CONFIGURE ANY INBOUND PORTS FOR THE GATEWAY TO WORK, AND CREATES AN OUTBOUND CONNECTION WITH THE SERVICE BUS, SO LONGS YOU CONFIGURE THE — THAT SHOULD WORK FINE. AND WHEN YOU INSTALL AND REGISTER A GATEWAY , THE AZURE AUTOMATICALLY GETS CONFIGURED SO YOU DON’T REALLY NEED TO DO MANUAL SET-UP AFTER THAT. AND FINALLY THE GATEWAY NEEDS TO BE UP AND RUNNING FOR IT TO EXECUTE ANY OF THE — WHICH COMES FROM THESE CLOUD SERVICES TO YOUR ON PREM GATEWAY . SO LET’S JUST GO THROUGH AN EXAMPLE OF A POWER BI DIRECT QUERY SCENARIO USING ON PREMISE GATE WAY. TO CALL THIS OUT, AGAIN, NAVEEN IS GOING TO EXPLAIN, BUT DIRECTLY AS SUCH, JUST A GIVE A QUICK OVERVIEW, THAT IT DOES IMPORT OR CACHE YOUR DATA, IT RUNS ON YOUR UNDERLYING DATABASES WHEN YOU HAVE QUERIES RUN AGAINST THEM. IN THIS SCENARIO A COUPLE OF THINGS TO NOTE, WHEN THE GATEWAY GETS INSTALLED AND REGISTERED , THE AZURE SERVICE BUS IS CONFIGURED AUTOMATICALLY AND WHEN YOU CLEAR IT A POWER BI DATA SOURCE, WHAT IS ASSOCIATED WITH THAT DATA SOURCE IS TESTED, ENCRYPT ED AND STORED WITH THE CLOUD AND THAT SPECIFIC GATEWAY CAN BE WITH THESE CREDENTIALS. TO GET STARTED WITH IN SCETO GET STARTED WITH IN SCENARIO, I GO INTO A POWER BI DASHBOARD AND CLICK — AND AT THAT POINT, WHAT HAPPENS IS THE POWER B iCLOUD SERVICE KICKS OFF A DIRECT QUERY AND THIS CLOUD SERVICE DOCKS WITH THE GATEWAY SERVICE TO ACQUIRE WITH THAT SPECIFIC GACQUIRE WITH THAT SPECIFIC GATEWAY. AND ONCE IT GETS THIS PERMISSION, IT WILL SEND THIS QUERY OVER TO THE GATEWAY, AND THE GATE WAY RECEIVES THE QUESTIONERI , CREDENTIALS AND SENDS TO THE QUERY FOR EXECUTION. THE NEXT STEP THAT THE DATA SOURCE EXECUTES THE SPECIFIC QUERY AND PUSHES THE DATA BACK OVER TO THE GATEWAY WHICH IS THEN SECURELY COMMUNICATED BACK TO THE CLOUD SERVICE SO THIS IS HOW AN END-TO -END QUERY WORKS. AND THEN POWERAPPS, LOGIC APPS, FLOW, ALL USE A DIRECT QUERY SCENARIO YOU COULD TECHNICALLY WITH THE POWER BI, IT COULD BE A POWERAPPS SERVICE OR THE WHOLE THING WILL WORK. ALSO GATEWAY SECURITY. A QUICK SHOW OF HANDS. HOW MANY OF YOU USE GATEWAYS WITH POWER BI HERE? GREAT AND HOW MANY OF YOU USE IT WITH POWER APPS OR FLOW. OKAY. THAT — THAT IS A GOOD NUMBER . SO I JUST

WANTED TO TOUCH UPON THE DIFFERENCES — THE SLIGHT DIFFERENCES IN THE GATEWAY SECURITY AMONG THESE APPLICATIONS BECAUSE WE HAVE BEEN RECEIVING A LOT OF QUESTIONS AND IT WAS A GOOD TIME TO CLARIFY. IF YOU LOOK AT THE — SO, FIRST OF ALL, WHEN YOU STAIN ALL AND REGISTER A GATEWAY YOU AUTOMATICALLY BECOME AN ADMIN OF THE GATEWAY AND WE DO ADVISE THAT YOU SHARE THAT GATEWAY OR MAKE A COUPLE MORE PEOPLE IN THE SECURITY GROUP SO YOU DON’T END UP WITH ORPHAN GATE WAY. GATEWAY ARE SET BETWEEN POWERAPPS AND DAY FLOW. AND IT WILL BE FOR THEM TO BE ABLE TO ADD OTHER AD MINS AND ADD DATA SOURCES, ADD USER TO THE DATA SOURCES AND USE MANAGEMENT FOR HIGHER ABI MANAGEMENT FOR HIGHER ABILITY LOAD BALANCING, ETC. THE TWO EXTRA LOADS IN THE POWERAPPS AND THE FLOW AREAS. CAN USE AND SHARE. CAN USE GIVES THE USER AN ABILITY TO USE A GATE WAY SHARE THE DATA SOURCES TO OTHER USER BUS CANNOT PERFORM ANY ADMINISTRATION FUNCTION THE LIKE LOAD BALANCING, ET CETERA. USERS ARE ABLE TO DO WHAT THE CAN USE USERS CAN DO BUT CAN SHARE THESE USERS TO OTHER GATEWAYS AS WELL. ANOTHER THINGS TO REMEMBER BUT FOR THESE TWO I MENTIONED ANOTHER CRITERIA IS THE DATA SOURCE TYPE YOU COULD SHARE A GATEWAY FOR CAN USE AND CAN USE OF SHARE FOR SPECIFIC DATA SOURCE TYPES. SHARE THIS GATEWAY WITH SOMEONE ONLY FOR SQL AND THEY WILL BE ABLE TO CREATE ONLY SQL CONNECTIONS . AND FINALLY THE DATA SOURCE AND CONNECTION SECURITY WHERE YOU HAVE USERS ADDED TO THESE — THESE CONNECTION OBJECTS AND THESE USERS ARE ALLOWED TO JUST USE THESE CONNECTION S AND POWERAPPS. BASED ON THE USER OF THIS PARTICULAR SCENARIO PERFECT . SO OVERALL, THERE HAVE BEEN QUESTIONS LIKE IN THE PAST, WE HAD QUESTIONS SAYING THAT THERE ARE SO MANY GATEWAYS INSTALLED IN MY ENTERPRISE AND I DON’T REALLY HAVE THIS ABILITY INTO THESE GATEWAYS AND THIS HAS BEEN A COMMON QUESTION SPECIFICALLY FROM SERVICE ADMINS, TENANTED A MINUTES FROM COMPANIES — ADMINS BY COMPANIES. IN THE PAST THE WORK AROUND EVERY GATEWAY ADMIN NEEDS TO ADD THE GLOBAL OR SERVICE ADMIN AS AN ADMINISTRATOR AS WELL AND GO TO POWER BI OR POWERAPPS AND MANAGE THESE GATEWAYS WHICH IS NOT A FEASIBLE SOLUTION. WE CREATED THIS CALLED THE TENANT LEVEL ADMINISTRATION PORTAL ON THE ADMIN CENTER THAT GIVES ALL THE GATEWAYS, AND ALSO PERFORM MANAGEMENT ACTIVITIES THERE SO QUICKLY WALK YOU THROUGH THAT SPECIFIC PORTAL . SO AS A TENANT ADMIN, WHEN WE LOG IN TO ADMIN CENTER CLICK ON DATA GATEWAYS, AND THIS WILL LOAD ALL THE GATEWAYS IN MY COMPANY. SO ALL — HERE AS YOU SEE, IT IS THE GATEWAY CLUSTER NAME THE CONTACT INFO OF THE GATEWAY AND THE LIST OF ADMINISTRATORS WHO CAN MANAGE THE GATEWAYS AS OF TODAY, AND THE GATEWAY IS THE NUMBER OF GATEWAY MEMBERS EACH OF THESE GATEWAY CLUSTERS HAVE. SO, FOR INSTANCE, THE GATEWAY CLUSTER HERE AS YOU CAN SEE HAVE TWO GATEWAY MEMBERS A FEW MANAGEMENT ARE VISIBILITY AND PROVIDE AND TO BE ABLE TO OPEN THE GATEWAY CLUSTER AND SAY USING THE FUNCTION HERE OR THIS ICON HERE AND TO BE A I BELIEVE TO SEE THE LIST OF DEVICES OF WHICH GATEWAYS AND OF THE GATEWAY CLUSTER. HERE YOU SEE TWO DEVICES, AND EACH OF THESE ARE RUNNING A SPECIFIC PORTION OF GATEWAY. OF COURSE THERE ARE SCENARIOS YOU MAY BE RUNNING DIFFERENT GATEWAY VERSIONS ON DIFFERENT MACHINES WE DON’T ADVISE THAT — ADVISE THAT TO HA, BUT WE DO GIVE YOU VISIBILITY AND WHAT IS RUNNING ON EACH OF THESE MACHINES AS WELL. ANOTHER OPTION WE HAVE IS TO BE ABLE TO CLICK ON A GATEWAY AND BE ABLE TO MANAGE ADMINISTRATORS WITH THIS GATEWAY WE ARE ABLE TO ADD GROUPS. FOR NOW IT IS GROUPS WITH E-MAIL ADDRESSES, BUT WE ARE FIXING THAT SOON AS WELL BUT YOU ARE ABLE TO ADD USERS SO, FOR INSTANCE, IF WANTED TO ADD ANNA AS A USER FOR THIS GATE WAY — >>

SHOULD SHOW UP. YEAH . IT’S QUITE SIMPLE. WE JUST SELECT THAT USER AND TO BE ABLE TO ADD THAT USER AND AT THE SAME TIME, DELETING A USER AS A GATEWAY ADMINISTRATOR IS AS SIMPLE AS THAT AND DELETE THE USER AS WELL. THESE ARE A COUPLE OF FEATURES WE HAD. WE ADDED PERSONAL GATEWAYS SPECIFICALLY USED WITH POWER BI. AND ALL ADMINISTRATORS OR FEN ANT AD MINS CAN SEE WHAT IS WAS INSTALLED. AND HERE YOU CAN SEE THE PERSONAL GATEWAYS. THIS BRINGS IN THE STANDARD GATEWAYS BUT YOU CAN WORK AROUND THAT. GOING BACK TO THE STANDARD MGOING BACK TO THE STANDARD MODE. THERE IS A SEARCH OPTION AS WELL THAT YOU CAN SEARCH EITHER ON THE CLUSTER NAME OR THE CONTACT INFO. WE ARE EXPANDING IT TO THE OTHER ATTRIBUTES AND I DID SEARCH OR IF I WANTED TO SEE HOW MANY GATEWAYS ANNA IS ACTUALLY A MEMBER OF OR CONTACT INFO, THEN CAN LOOK THAT UP. AND FINALLY ONE OF THE IMPORTANT FEATURES WE RELEASED IN THE LAST COUPLE OF MONTHS IS THE MANAGED GATEWAY INSTALLERS SO IN AN ENTERPRISE TODAY, ANYONE CAN GO IN AND INSTALL A ENTERPRISE GATEWAY OR HOW CAN WE ACTUALLY — HOW DO TENANT ADM INS MANAGE THIS ONCE THEY CLICK ON THIS OPTION, DEFINE ENTERPRISE CAN INSTALL GATEWAYS BUT YOU CAN’T TURN IT ON, AND THEN PROVIDE ACCESS TO SELECTIVE USERS AND ONLY THESE USERS WILL BE ALLOWED TO INSTALL GATEWAYS WITHIN YOUR ENTERPRISE. HERE AS YOU CAN SEE, ANNA CAN INSTALL GATEWAYS NOW AND LET ME ACTUALLY JUST DELETE ANNA FOR NOW. AND LET’S SEE IF THIS FUNCTIONALITY ACTUALLY WORKS. SO HERE I HAVE — I AM TRYING TO INSTALL GATEWAY HERE, AND I AM — I HAVE TO REGISTER THIS USER. THIS GATEWAY FOR ANNA. AND I AM GOING TO TRY TO REGISTER THIS GATE WAY . LET’S PICK ANNA . AND PASS WORD. GO WITH THAT. AND HERE IS SOMETHING WE NEED TO REMEMBER THAT REMOVING A USER FROM INSTALLING GATEWAYS DOES NOT IMPACT ANY OF THE GDOES NOT IMPACT ANY OF THE GATEWAYS THEY HAVE ALREADY INSTALLED SO ANYTHING THEY HAVE ALREADY INSTALLED, THEY ARE ALREADY ADMINS OF. THEY CAN MANAGE THAT AND MIGRATE AND TAKE OVER OF THE GATEWAY. BUT THEY CAN’T JUST INSTALL NEW GATEWAYS REGISTER A NEW GATE WAY AND — LET’S SEE TEST GATEWAY INSTALL , AND TYPE IN A RECOVERY KEY . AND TRY CONFIGURE IT. AND AT THIS POINT ANNA WILL GET A MESSAGE DO NOT HAVE SIGNIFICANT PERMISSION TO INSTALL A GATEWAY PLEASE CONTACT YOUR TENANT ADMIN UNTIL HE GRANTS ANNA ACCESS ANNA CANNOT CONFIGURE THIS GANNA CANNOT CONFIGURE THIS GATEWAY. LET’S JUST ADD ANNA BACK HERE AND THE CONFIGURATION SHOULD GO THROUGH . >> TODAY IT IS NOT POSSIBLE. >> WE ARE LOOKING AT THAT TIME FOR A FEATURE IN THE LONG RUN. >> YOU SEE ANNA WAS ABLE ACTUALLY ABLE TO INSTALL THE GATEWAY AFTER THE TENANT ADMIN WAS GIVEN PERMISSION TO THAT. THIS SPECIFIC PORTAL WAS OPEN ONLY FOR GLOBAL OFFICE 36 5 ADMINS UNTIL MIDMAY AND MADE IT AVAILABLE FOR ADMINS NOW. AND WE MAKE IT AVAILABLE FOR POWERAPPS AND FLOW ADMINS LATER IN THE FUTURE HERE. SO SWITCHING BACK TO THE — PERFECT. SO NEXT NAVEEN WILL TALK ABOUT GATEWAYS >> THANK YOU. SO LET’S TALK A LITTLE BIT MORE INTO WHAT YOU NEED TO INSTALL WHY YOU DO NEED TO INSTALL THE GATEWAY AND GET INTO MORE DETAILS. SO WE HAVE BEEN TELLING PEOPLE THAT WE NEED A EIGHT CORE MISSION, STANDARD AND WE GET INTO MORE DETINTO MORE DETAILS SOON HOW WE ARE IMPROVING

THE ACORN MISSION. IF YOU HAVE IT WE WILL TWEAK YOUR PERFORMANCE AND WE WANT TO KEEP IT THERE. SO WE ALSO WANT YOU TO KEEP MONITORING THE PERFORMANCE OF YOUR MISSION HOW IS YOUR CPU, HOW WAS YOUR NETWORK, AND HOW WAS YOUR MEMORY. BASED ON THE QUERIES AND WHAT USAGE . YOU NEED TO PEAK YOUR CONFIGURATION AND ADD ONE MORE GATEWAY MEMBER TO YOUR CLUSTER AND MANAGE IT. AND SO YOU BASICALLY ARE SCALE IT BASED ON IT . SO PEOPLE USED TO ASK WHETHER WE RUN IT ON THE SAME GATEWAY. THE GATEWAY ON THE SAME DAY SOURCES IN MOST CASES IT IS OKAY TO RUN THERE, AND ALSO DEPENDENT ON HOW MUCH OF THE DATA SOURCES IS TAKING IF YOU RUN SQL ON THE SAME MISSION, SQL USES ALL THE MEMORY AVAILABLE ON MISSION. IF YOU WERE ON THE SAME MISIF YOU WERE ON THE SAME MISSION, OUT NOT GET THE SAME — IT WILL BE AN ISSUE TRYING TO CONNECT TO — FOR THE GATEWAY TO USE THE MEMORY AND MAY BE SLOWER AND MAY NOT BE A GOOD PERFORMANCE SOURCE. BETTER TO LOCATE CLOSER TO YOUR VALUE AND DATA SOURCES . DATA SOURCES IN ONE REASON . CAN USE A VIRTUALIZED MISSION YES. THE ONE THING I WOULD ASK FOR THAT YOU HAVE A — SO THAT’S NEXT AND WE DO A LOT OF CACHING. AND WE DO SPOOLING. AND AN IMPORT WHEN YOU ARE TRYING TO IMPORT THE LAST DATA SET. AND LOCAL AND THEN PUSH IT TO THE CLOUD. IT IF YOU WANT TO WRITE — IF YOU WANT THAT PERFORMANCE WILL BE FASTER AND ALSO WHEN YOU DO A DATA QUERY KIND OF SCENARIO WE TRY TO CATCH CERTAIN THINGS LIKE IF YOU ARE SCHEME OFF YOUR DATABASE AND SOMETHING THAT IS CACHED FOR A BETTER PERFORMANCE AND AUTHORIZE FOR WHAT YOU ARE LOOKING FOR. THAT IS ALSO CACHED LOCALLY. AND IF — THAT WILL ACTUALLY IMPROVE YOUR PERFORMANCE . AND AND GENERALLY DOESN’T TAKE THAT MUCH TIME BUT HAVING IT WILL BE MUCH BENEFICIAL AS WELL WILL BE MUCH BENEFICIAL AS WELL. FROM THE POWER BI PERSPECTIVE, IT IS REALLY IMPORTANT. DOING FOR IMPORT AND DATA QUDOING FOR IMPORT AND DATA QUERY, I WILL AGAIN GO BACK AND LOOK TO SEE WHETHER MY GATEWAY IS STILL HEALTHY OR MEMORY IS IN A GOOD SHAPE, BUT MAKE SURE HOW YOU ARE DOING AND FAIMENT SOMEBODY WILL RUN BQ YOU HAVE THE CAPABILITY LOOK AT HOW AND WHEN EVERYTHING HAS HAPPENED . GA GATEWAY HAS HIGH AVAILABLE AND LOW BALANCING. THAT AVAILABLE, AND BASICALLY IF THE IF THE GATEWAY GOES OFFLINE, IT CAN IMMEDIATELY SWITCH TO THE NEXT ONE AND IF YOU ARE TRYING TO DO A SOFTWARE UPDATE THE SUCCESS WILL NOT FAIL YOU GO TO THE SECOND GFAIL YOU GO TO THE SECOND GATEWAY AND START WORKING. AND THE HIGHER FEATURE, PEOPLE ARE ASKING THAT GATEWAY IS SITTING IDLE. I WANT TO USE THAT GATEWAY AS WELL. WE STARTED USING THE LOAD BARRIER FEATURE. AND TURN ON A BUTTON FOR LOAD BALANCES AS WELL. AND OFF THE GATEWAYS WE ARE TRYING TO ROUND ROBIN KIND OF TO, OKAY, I WANT TO SEND THIS REQUEST AND IF YOU GO ONE OFF THE GATEWAY IT WILL GET EXECUTED THERE . YOU WILL SEE OPTION FOR EXISTING STRUCTURE AND AVAILABLE GATEWAY CLUSTERS AND THIS GATEWAY WILL BE ADD ED. AND WE ALSO HAVE PORTION COMMANDS. THAT IS TO ALLOW TO YOU MANAGE IT. AND IN THE SCENARIO, YOU WANT TO HAVE — YOU WANT TO TAKE DOWN A PARTICULAR GATEWAY FOR MAINTENANCE. YOU CAN GO TO THE POWER SHELL AND SAY I WANT TO TAKE THAT GATEWAY OFF LINE WILL NOT GO TO THE GATEWAY AND THE SYSTEM WILL SOON BE PROCESSING GIVE SOME TIME BEFORE TAKING IT OFF LINE. IF YOU WANT TO SHUT DOWN AND DO A UPGRADE OR SOMETHING, YOU CAN DO THAT OPTION. YOU GO THERE, TURN IT OFF, GIVE IT SOME TIME , LIKE AN HOUR OR SO AND POWER BI

GIVE TWO HOURS. AND OTHERWISE IT IS PROBABLY FIVE MINUTES OR SO AGAIN RMLY WHEN WE CONNECT TO THE POWER BI IT NEEDS CONNECTIVITY TO THE EST IN. THAT’S ALL WE ASK FOR AND WE SECT TO — THAT IS THE ONLY POINT WE CONNECT TO WHEN THE GATEWAY IS RUNNING. ALL OF THIS STUFF IS REQUIRED ONLY DURING SET UP. DURING SET UP CONNECT TO CERTAIN SERVICES AND POWER BI AND ALL THIS STUFF BUT AFTER YOU ARE SET UP WE DON’T ASK FOR EXTRA END POINT. THE END POINT THAT WE WANT ACCESS TO AND IF THIS IS ENACCESS TO AND IF THIS IS ENABLED AND A NEW RECOMMENDATION, WE WANT YOU TO BE RUNNING AND THEY WERE SAYING IT DOES BETTER TO REVIEW ALL THE NETWORK RELATED ISSUE S RUNNING — IT REQUIRES CERTAIN IP ADDRESSES. , IT SOME PROXY SERVERS THAT SAY THESE ARE ALL THE SET-UPS SO WE BASICALLY HAVE A LIST OF IP AVAILABLE FOR PARTICULAR REGION OF THE DAY IP ADDRESS, AND IT IS ALSO AVAILABLE IN OUR DIAGNOSE US PARTICULARS WHEN WE SAY — YOU CAN SEE THAT IS A START — UNDER — THAT WILL LOOK AT THIS PARTICULAR GATEWAY WILL TRY TO CONNECT TO AND WILL HAVE A LIST OF ALL IP ADDRESSES YOU CAN BASICALLY GRANT PERMISSION TO THE SPECIFIC IP ADDRESS AND THAT IS OUR RECOMMENDATION THERE . SO NEXT, WE ARE GOING TO LOOK AT PERFORMANCE MONITORING. SO FAR IT HAS BEEN A BLOCK BOX LOOKING INTO OUR GATEWAY WHEN SOMEONE ASKS US WHAT IS RUNNING ON TRUNNING ON THE GATEWAY AND WHO IS USING YOUR GATEWAY. WHAT ARE ALL THE DATA SOURCES THAT ARE GOING THROUGH THE GTHAT ARE GOING THROUGH THE GATEWAY, PROBABLY YOU WON’T TELL, BUT THAT IS COMING UP LATER BUT WE WANT TO SAY HOW WE CAN OPTIMIZE WHAT IS RUNNING IN THE GATEWAY AND HOW WILL THIS RUN. SO BEFORE WE GO INTO THE — THE DETAILS OF WHAT CAN BE PERFORMANCE, WE WANT TO LOOK AT SOME UNDERSTANDING OF CONSOME UNDERSTANDING OF CONTAINERS. ANY QUERY THAT RUNS THROUGH THE CONTAINER — THROUGH THE GATEWAY, GENERALLY THAT USES THE MASH-UP PROCESS LIKE IF YOU TAKE A SQL IMPORT JOB. OFF SQL DATA SOURCE AND OFF MATCH -UP AND THAT ACTUALLY SENT TO THE GATEWAY, AND GATEWAY EXECUTES ALL THIS STUFF ON A MASH -UP CONTAINER PROCESS WE NEED A MASH UP CONTAINER PROCESS IF YOU HAVE A POURER BI, YOU MAY HAVE SEEN. SO EACH GRADE YOU WILL HAVE A MISSION TO EXECUTE A QUERY SO BASICALLY CONNECTS TO THE DAY SOURCE AND DOES A QUERY AND ALL THAT YOU ARE ASKED FOR AND PUSHES THE DATA BACK. IT IS A PROCESS WHERE BASICALLY TO ISOLATE THE UNLOADING DRIVERS OR SOMETHING. SO YOU MAY HAVE A THIRD-PARTY DRIVER AND MAY BE LOADING THEM IN THE ISOLATOR PROCESS AND WE TRY FLUSH ALL DATA RIGHT AWAY . SO USE SOME OF THESE CONTAINER FOR EVERY GREAT EXECUTION SO WE DON’T — ONCE THE PROCESS STARTED IT IS KEPT ACTIVE FOR TEN, 15 MINUTES AND RUNS AS MANY QUERIES AS POSSIBLE. IF THE QUERY TAKES RESPONSIBLE IT KEEPS THE PROCESS RUNNING AS WELL . AND CLEAR THE PROCESS. IF NO ONE IS USING WE RECYCLE AND KILL THOSE PROCESSES . AND WE ALSO ARE SEEING SOME MEMORY. THE NEXT SLIDE WE ARE GOING TO TALK ABOUT. BASICALLY THIS MATCH-UP CONTAINER USES MEMORY AND WE SAY THAT, OKAY, HOW MUCH MEMORY YOU NEED AND FOR THAT HOW MUCH . AND I WANT TO QUICKLY WALK THROUGH WHAT HAPPENS IN A POWER BI REFRESH. SO YOU HAVE A POWER BI IMPORT. ONLY HAVE A POWER BI FOR YOUR COMPANY . OKAY. SO IT’S

— SO YOU HAVE MULTIPLE QUERIES INSIDE A POWER BI DATA SET. AND I SEE YOU HAVE NINE QUERIES HERE AND YOU HAVE A GATEWAY. WITHIN GATEWAY TWO SET OF CONTAINERS. WE TALK ABOUT ONE — WE TALK WHAT THE CONTAINER S ARE. TWO SETS OF CONTAINERS FOR POWER BI TO WORK. AND INITIALLY IT IS STARTED ON — ALL THESE QUERIES BASICALLY GO TO THE GATEWAY AND THEY BASICALLY USE SOME OF THE — THE CONTAINER PROCESS TO BE FINAL ACCESS THE DATA SOURCES. SO EACH QUERY COMES INDEPENDENTLY TO THE GATEWAY AND SAY AM I ABLE TO OPEN THE DATA SOURCE FOR THIS PARTICULAR QUESTIONER TOW WORK. IF EVERYBODY SAYS OKAY , THEN — THEN YOU BASICALLY START THE REFRESH PROCESS. SO REFRESH — POWER BI CONTROLS HOW MANY REFRESHES CAN RUN AT THE TIME. SO THEY SAY WITH ONE DATA CENTER REFRESH. AND BESIDE ONE DAY SET CAN HAVE SIX REFRESHES, AND BASICALLY SEND SIX QUERIES BACK AND THE FIRST BUCKET OF CONTAINER BASICALLY START PROCESSING THOSE JOBS. EACH AND EVERY QUERY MAY RUN FROM — PROBABLY COUPLE OF HOURS BASED ON WHERE YOU ARE POWER BI — YOU ARE CREATING AND RUN FOR TWO OF US. AND IF YOU ARE IN PRE AND IF YOU ARE IN PREMIUM SPACE, RUN UP TO FIVE OF US. BASED ON THAT THE QUERY CAN RUN THE CLOCK SO ONCE THESE QUERIES ARE COMPLETED ONE IS HE IS COMPLETED WILL TRY TO BRING THE NEXT QUERY. MAKE SURE ONLY SIX PER DATA SET THAT IS RUNNING AT A POINT OF TIME. AND FINALLY WHEN EVERYONE IS DONE THEY SAY YOUR REFRESH IS DONE. THIS IS HAPPENING FOR ONLY ONE DAY SET AND TRYING TO REFRESH MULTIPLE DATA SETS AT THE SAME TIME, WHAT PEOPLE GENERALLY DO AT THE TOP — LIKE AT 8:00 I WANT ALL MY REPORTS TO BE REFRESHED AND EVERY ONE NEED TO BE REFRESHED AT THE SAME TIME. AND USING THE SAME GATEWAY . IMAGINE WHAT WILL HAPPEN FOR A SINGLE DAY IS A SET ALL SET FOR THE GATEWAY AND DO A TEST DOEPTION SEE THE QUERY AND ONLY A CONNECTION TO THE DAY SOURCE AND BRING QUERIES AND RUN A MASH-UP ON YOUR QUERIES. ANY QUESTIONS ON THIS ONE? OKAY, I WILL GO AHEAD THE CONFIGURATIONS AVAILABLE ON THE LOCAL MISSION THAT SAYS HOW TO CONFIGURE FOR IMPORT. THIS IS FOR AZURE ANALYSIS SERVICE. AZURE IS USED AS A SAME MECHANISM TO RUN IMPORT JOBS . KNEES CAN RUN FOR LONGER TIME AND TO RUN WHATEVER YOU CAN CONFIGURE IT TO. AND YOU CAN CONFIGURE HOW LONG YOU WANT IT TO RUN. AND WE HAVE SOME DEFAULT CONFIGURATIONS BASED ON YOUR MISSION AND I KNOW WE CAN SAY IF YOU HAVE A CORE MISSION, YOU WILL HAVE 16 CONTAINERS AND BASICALLY RUN 16 QUERIES AT THE SAME TIME ON THE MISSION . SO WE ARE BASICALLY SAYING ROUGHLY HALF FOR QUERY. AND SO WE TALKED ABOUT THE TEST CONNECTION ON THE — ON THE DATA SOURCES THAT WILL BE 48. AND ALSO THE — VERY FEW MILL SECONDS AND IF YOUR DATA SOURCE IS SLOW, YOU SEE THAT IT IS HAPPEN MUCH EARLIER BEFORE — BEFORE THE TWO — WINDOW. YOU SEE WITHIN A MINUTE OR SO YOU MAY SEE WITHIN FIVE MINUTES YOU CAN SEE WHAT IS HAPPENING ON YOUR REPORTS THAT IS BECAUSE WE ARE NOT ABLE TO SUCCESSFULLY OPEN A CONNECTION TO YOUR DATA SOURCE , AND VALIDATE THAT WE HAVE A GOOD CONNECTION SO WE BASICALLY DISCONNECT THE CONNECTION AT THE POINT. A COUPLE OF SETTINGS AVAILABLE TODAY. WE HAVE — SO WHEN — CONFIGURE — THIS BASICALLY SAYS I WANT TO MANUALLY CONTROL THE NUMBER OF CONTAINERS ON MY MISSION. BY DEFAULT NUMBER TIMES TWO. BUT IF YOU WANT — TO BE MORE THAN THAT AND DECREASE IT BASED ON HOW YOU SEE PERFORMANCE ISSUES, YOU CAN TAKE — BUT THE CONFLICT TO — TO FOR MASH THEN YOU CAN SET THE VALUES ON THE DEFAULT CONTAINER AND TEST CONNECTION FOR CONTAINER MAX AND THAT COULD BE THE NUMBER OF CONTAINERS

THAT WOULD BE AVAILABLE. ONCE YOU INCREASE IT, MAKE SURE YOU ARE INCREASING — OR DES CREIT, MAKE SURE YOUR CPU IS WELL WITHIN THE LIMITS. WE DON’T HAVE CONTROL OF WHAT YOUR QUESTIONERY IS GOING THROUGH THE CONTAINER. IF YOUR QUERY IS MORE COMPLEX, DALE USE MORE CPU AND WE DON’T HAVE MORE CONTROL OVER IT AND YOU MAY WANT TO GO BACK AND TWEAK THAT NUMBER. SO COMMON ISSUES WITH — WITH THE IMPORT. YOU MAY SEE ERRORS RELATED TO PRIVACY LEVELS WHEN YOU ARE TRYING TO MERGE TWO DATA SOURCES THAT’S BEEN — IF A SINGLE QUERY CONTAINS MULTIPLE DATA SOURCES , IT SAYS I AM NOT ABLE TO EXPAND THIS DATA SOURCE AND UNABLE TO FIND — EXPAND A PARTICULAR COLUMN THAT BASICALLY CAN BE — BY SETTING THE PRIVACY LEVEL ON CLOUD AND ON PREM SOURCE. SO IF YOU — IF YOUR QUERY TAKES LONGER, IF IT IS WITHIN THE FIRST FIVE-MINUTE WINDOW, THAT MEANS WE ARE NOT ABLE TO CONNECT TO YOUR — TO YOUR DATA SOURCE SUCCESSFULLY AND FAILING BEFORE ITS TIME . AND A COUPLE OF ISSUES . MULTIPLE THAT ARE RUNNING SLOW ON YOUR MISSION AND YOU ARE NOT HAVING ENOUGH — ENOUGH CONTAINERS TO RUN IT MUCH FASTER, OR YOUR QUERY IS TAKING MORE TIME. SO YOU NEED TO — YOU NEED TO SEE WHAT CAN BE DONE TO YOUR QUERY TO BE COMPLETED FASTER AND INCONSISTENT PERFORMANCE IS SOMETHING THAT PEOPLE HAVE NOTICED AT SOME POINT WHEN IT RUNS FASTER , SOMETIMES IT IS BASICALLY TAKING FOREVER TO RBASICALLY TAKING FOREVER TO RUN. SO THERE IT IS AGAIN HOW MANY ARE RUNNING AT THE SAME TIME BESIDE BASED ON HOW MANY CONTAINERS WE HAVE. WE WILL BASICALLY NEED TO UNDERSTAND TO DEVELOP PERFORMANCE AT THE SAME TIME, THE SAME TIME OF QUERY RUNNING AND IF WE HAVE ENOUGH CONTAINERS IF IT WAS PICKED RIGHT AWAY AND EXECUTING. THAT’S WHY YOU WILL SEE CONSISTENT PERFORMANCE AND SOMETIMES THE DATA SOURCE ITSELF IS PROBABLY SLOW, SO YOU TRY TO — DURING PEAK HOURS WHEN YOU TRY TO REFRESH, THE QUERY TAKES A LITTLE LONGER AND YOU MAY FIND INCONSISTENT PERFORMANCE. ANY QUESTIONS HERE? OKAY. SO NOW MOVING TO THE DATA QUERY. DATA QUERY IS PRETTY SIMPLE WE DO NOT DO ANY TEST CONNECTION OR OPEN CONNECTION. WE BASICALLY TRY TO EXECUTE A QUERY AND SEE IF WE CAN GET THEM — GENERALLY IT SHOULD HAPPEN LESS THAN A SECOND BECAUSE YOU ARE FULLY INTBECAUSE YOU ARE FULLY INTERACTING ON THE UINTERACTING ON THE U I TO DO SOMETHING, TO GET THE DATA AND SHOW IN THE UI THIS USES MSHOW IN THE UI THIS USES MASH-UP CONTAINERS AND YOU DO IT AUTOMATICALLY, TO IF YOU HAVE A CORE, YOU WILL DO 40 CONTAINERS FOR YOU AND 40 QUERY CAN HAPPEN AT THIS POINT . SO IN THE OLDER VERSIONS ONLY SUPPORT 20, OR IF YOU HAVE A LOWER CORE MISSION IT WILL BE 20 CONTAINERS THAT WILL BE AVAILABLE AND ANYTHING EIGHT PLUS WILL BE 40, AND OFF — IT COULD BE 80 CON TAIRNS. AND WE ALSO HAVE A WORKING SET MEMORY WISE. WE USE 64. GENERALLY DON’T USE THAT MUCH MEMORY AND USE A SMALL AMOUNT OF DAY BASED ON YOUR PARTICULAR CONTINUE OR SOMETHING. SO DOESN’T NEED THAT MUCH OF A MEMORY RESTRICTION. SO USING 64 MB OF MEMORY. AND THIS CONFIGURATION USING THE SAME CONFIGURE VALUE. CONTAINER. AND TWO DIFFERENT SETTINGS WHERE YOU CAN SET WHAT IS THE — WHAT IS YOUR CONTAINER VALUE SHOULD BE. HOW MANY CONTAINERS YOU WANT TO RUN AND WHAT MEMORY YOU NEED. YOU CAN — IF YOU WERE TRYING TO OUT A LARGE — SORRY, HIGH FREQUENCY OF FILES BECAUSE OF MEMORY YOU CAN USE. IF IT NEEDS MORE THAN THAT, YOU CAN SEE A HIGH PAGE USAGE, SO TRY INCREASING THE MEMORY. COULD RELEASE A USAGE IMMEDIATE SLOW AND SLOW QUERY IS BASICALLY TIED TO MAKING YOUR DATA SOURCES SLOW OR BASICALLY SATURATED YOU DON’T ARE ENOUGH CONTAINERS TO PROCESS A WEARY . WE ARE AOR ASSUMING 40 CONCURRENT QUERY COMESING IN. THAT’S ALL WE CAN HANDLE BUT HAVE HUNDREDS OF USERS COMING IN,

YOU ASK SHOULD WE INCREASE THE NUMBER OF CONTAINERS ON A MISSION. AND THE CPU MAKE A HIGHER NUMBER OR ADD ONE MORE GATEWAY THAT CAN HANDLE THAT LOAD . THERE IS ALSO — THESE ARE DESIGNED TO RUN IN A VERY SHORT WINDOW SO THEY GENERALLY DON’T RUN MORE THAN TWO MINUTES. IF THEY RUN MORE THAN THAT THEY WILL AUTOMATICALLY TIME OUT AND FAIL. THERE ARE STRICT TIMEOUTS ON THESE STUFF . SO LOGIC CAPS AND FLOW, USE SIMILAR KIND OF SETTINGS. FOLLOWS THE SAME PATTERN BUT WE HAVE OUR OTHER SET OF CONTAINER SETTINGS FOR THEM. YOU CAN USE THESE SETTING TO CONFIGURE. CONFIGURE IT FOR POWER APPS AND LOGIC APPS FOR THE NUMBER OF CONTAINERS IN THE WORKING SET . ALL THE SET THAT IS ARE AVAILABLE THAT WE JUST TALKED WE HAVE — YOU IF YOU ARE ABLE TO DO MATCH -UP TO — TO. >> WHAT ACTUALLY USES BASE ON CPU. >> IF YOU WANT TO USE THE CPU. IF YOU WANT — YOU CAN GET IT TO TRUE AND USE THE BELOW VALUE BELOW DATA AS WELL . >> SO HOW MANY OF ARE YOU G>> SO HOW MANY OF ARE YOU GATEWAY ADMINS HERE? PERFECT SO I AM SURE A LOT OF YOU WILL HAVE ACTUALLY HAD THESE QUESTIONS IN MIND. I KNOW NAVEI KNOW NAVE E STOLE SOME OF MINE. WHICH GATEWAY IS THE BUSIEST? WHAT IS RUNNING ON MY GATEWAY THE QUESTION IS, WHY IS MY GATEWAY SHOW. THESE ARE QUESTIONS WE HAVE BEEN HEARING AND DOWN, REVOKE, TODAY TO GET ANSWER TO THOSE AND THOSE ARE CUMBER SOME AND YOU ALWAYS GET TO THE RIGHT ANSWER ALWAYS. IT IS ALWAYS TO DO THAT. WHAT WE HAVE DONE IS USER FEATURE CALLED GATEWAY USAGE AND PERFORMANCE MONITORING IN PUBLIC PURSUE NOW. TO WHAT YOU HAVE DONE THERE IS WE HAVE INTRODUCED A FEW CONFIGURATIONS THAT WILL ENABLE LOG FOR EDGE LOG FOR EDGE COUGS AND SYSTEM COUNTERS. AND ALSO PROVIDING AN OUT OF THE BOX TEMPLATES THAT YOU CAN CONNECT TO THESE AND VISUALIZE THIS DAY. SO JUST GOING THROUGH — JUST QUICKLY . THE EXECUTION LOGS. THERE ARE TWO QUERY EXECUTION LOG S WE PUT IN THE DISK OFF THE GATEWAY ONCE THE SETTING IS ENABLED THE FIRST ONE LOGS EVERY QUERY THAT GOES THROUGH THE GATEWAY FROM PROVIDE FROM PROVIDING INFORMATION HOW LONG THE QUERY TOOK TO EXECUTE. DATA PROCESSING HOW CAN DID THAT TAKE DID IT SUCCEED, FAIL AND WHY DID IT FAIL. ALL OF THIS INFORMATION GETS LOGGED IN THE FIRST. AND THE SECOND ONE IS MORE OF A AGGREGATION FOR THIS SPECIFIC TIME AND THAT WAY YOU ARE ABLE TO VISUALIZE THAT AND AGGREGATION AROUND THE SAME TIME FRAME FOR THE COUNTERS LIKE MEMORY AND CPU. YOU CAN PUT THESE SIDE BY SIDE AND SEE IS MY GATEWAY COSTING IT TO SPIKE OR MEMORY TO SPIKE AGAIN. SO A FEW OF THE CON FIG FIGURE RATIONS AREN’T — CONFIGURATIONS AREN’T ACTUALLY MENTIONED. AND THESE CONFIGURATIONS ALLOW THE ACTUAL LOGGING WE SAW ON THE PREVIOUS SCREEN AND POINT NUMBER TWO GIVES A BUNCH OF CONFIGURATIONS THAT HELP CONTROL THIS WHOLE PROCESS A LITTLE BETTER USING THESE CONFIGURATION WHERE IS I SHOULD PUT THESE FILES, ON A NETWORK PATCH FOR A GATEWAY MACHINE OR SHOULD IT BE — LIKE HOW MANY FILES SHOULD I RETAIN AND WHAT SHOULD BE THE SIZE OF THESE FILES AND THE — LIKE TALKING ABOUT FOR AGGREGATION THEY ARE SET BY THE LAST TWO CONFIGURATIONS AND THE DEFAULT IS FIVE MINUTES BUT YOU CAN GO AND CHANGE IT ALWAYS SO LET ME ACTUALLY SWITCH BACK TO THE TEMPLATE WE PROVIDE OUT OF THE BOX. SO HERE IS THE TEMPLATE WE PROVIDE OUT OF THE BOX, AND ONCE YOU OPEN IT , IT COMES UP WHICH IS THE DEFAULT PATH. WE ACTUALLY STORE THE LOCKED FILES INTO, AND, OF COURSE, WE HAVE CHANGED IT TO ANOTHER FILE AS MOST OF US WILL DO, AND SO I AM JUST CHANGING THIS PART AND LOADING THIS INFORMATION SO IT SHOULD TAKE A COUPLE OF SECONDS

TO LOAD. YES. SO WE DO HAVE THESE VISUALIZATIONS AVAILABLE IN THE TEMPLATE, BUT, OF COURSE, YOU CAN CUSTOMIZE IT FURTHER BASED ON NEEDS AND THE SPECIFICS OF WHAT YOU ARE TRYING TO RESOLVE. YOU CAN CUSTOMIZE THIS TEMPLATE AS REQUIRED. THE FIRST ONE HERE ACTUALLY SHOWS INFORMATION MORE BASED ON A DATA SOURCE. SO HERE IF IT LOOKS LIKE THERE ARE SIX DATA SOURCES. AND FOR A UNIT OF TIME WE ARE TRACKING FOR EACH OF THESE DATA SOURCES THE COUNTERS WE ARE ACTUALLY TRACKING. THIS COULD BE THE AVERAGE DATA PROCESSING TIME THE AVERAGE CREDIT EXECUTION TIME, ET CETERA, AND LOOKING AT ALL OF THIS, YOU AT LEAST GET AN IDEA OF WHICH DATA SOURCE IS CONSUMING A LOT OF YOUR SYSTEM RESOURCES. AND THEN THE NEXT ONE GIVES YOU MORE INFORMATION BY CREDIT TMORE INFORMATION BY CREDIT TYPE. WE HAVE HEARD A LOT TO THE DIRECT QUERY AND THE POWER BI. AND WE AT LEAST GET AN IDEA TO LOOK AT. LOOKS SIDE BY SIDE ON DIRECT QUERY VEER US IS POWER BI. DIRECT QUERY AND LOGIC APPS , PROJECT APPS WILL GO INTO DIRECT QUERY AS WELL. INFORMATION ABOUT SYSTEM COUNTERS WHICH WE HAD AND THIS SPECIFICALLY COMPARES TO CPU AND MEMORY COUNTERS FOR GATEWAY MASH UP AND THE SYSTEM DOESN’TERS HERE. THE FOURTH ONE GOES INTO DETAILS WITH THE DETAIL QUERY LOGGING I WAS REFERENCELOGGING I WAS REFERENCING TOO. YOU SEE GRAPHS THAT ACTUALLY TALK ABOUT HOW MANY OF OUR QUERIES FAILED. AND WHAT IS THE AVERAGE EXECUTION BASED ON DATA SOURCE THE DATA PROCESSING TIME AND ALSO BY QUERY TYPE. THERE IS A LOT OF DATA HERE DEPENDING ON THE TYPE OF PROBLEM YOU CAN SOLVE CREATE A CUSTOM VISUAL. FOR INSTANCE, IF I JUST WANTED TO LOOK UP THE NUMBER OF QUERIES WHICH ARE COMING UP, CRICKET QUERY VERSUS REFRESHED FOR INSTANCE. IF I JUST HAD THAT AND I DID A QUERY TYPE HERE AND ALSO THE REQUEST . LET ME PULL THAT IN HERE IT SAYS ABOUT 128 QUERY THAT’S DIRECT QUERY AND THE OTHER 35 OUT OF FRESH QUESTIONERS THAT HAVE DONE THROUGH THE THROUGH THEWAY. JUST TO SEE HOW THIS NUMBER CHANGES, I AM GOING TO CLICK ON A FEW DIRECT QUERY REPORTS THAT I HAVE HERE SO — — WHAT I HAVE HERE. I AM GOING TO CLICK ON. JUST TO GENERATE SOME TRAFFIC TO SEE HOW THE NUMBERS CHANGE, AND THE SQL SERVER HERE. I HAVE DONE A BUNCH OF REPORTS NOW. BASED ON THIS, THE NUMBERS SHALL CHANGE THE NUMBER IS 12THE NUMBER IS 128 AND LET’S JUST REFRESH . 135. SO THE NUMBER CHANGED TO 135. SO YOU CAN SEE THAT OF THE QUERIES ARE GETTING LOGGED ON THE LOGS AND YOU ARE ACTUALLY ABLE TO VISUALIZE THE DATA PRETTY QUICKLY WHEN THE DATA QUERIES RUN THROUGH. FOR POWER APPS, THAT IS PART OF THE DIRECT QUERY PART AS WELL. IF I WANTED TO ACTUALLY RUN A POWERAPPS HERE, AND THIS SPECIFIC POWERAPP ACTUALLY CONNECTS TO THE GATEWAY , LOADS UP A DATA TABLE FROM A SPECIFIC TABLE BACK TO AN ON-TIME SOTABLE BACK TO AN ON-TIME SOURCE. ONCE I DO THAT. THE DATA GOT ROAD ED. — GOT LOADED AND NOW AT 135 SO LET ME JUST REFRESH IT AND THIS ACTUALLY NUMBERED 136 SO WE HAD ONE EXECUTION OFF OF POWERAPP DIRECT QUERY AS WELL. AND THAT GETS COUNTED AS WELL. AGAIN WE HAD QUESTIONS ABOUT WHY CAN’T WE SEE IT BY APPLICATION THAT IS SOMETHING WE ARE WORKING ON TO SHOW HOW MANY QUERIES CAME FROM POWER APPS AND POWER BI. ARE THERE FOLKS THAT ACTUALLY SHARE GATEWAYS BETWEEN APPLICATIONS? YOU DO USE THE SAME GATEWAY S FOR POWER BI, POWER APPS HERE? OR — OKAY SO YOU WOULD GET AN IDEA. WE ARE WORKING ON THAT AND GET SPECIFIC VIEW S TO IDENTIFY SO SWITCHING BACK TO THE SLIDES . PERFECT AND DO SEND US FEEDBACK ONCE YOU TRY THIS FEATURE OF THE TEMPLATE AND ANY PROBLEMS WITH LOG IN. IT IS AVAILABLE — IF YOU LOOK AT OUR BLOGS. THE MONTHLY BLOGS, THAT SHOULD

CONTAIN THE LINK TO THE TEMPLATE SO NEXT, WE MOVE ON TO NEW FEATURES THAT WE ARE WORKING ON. AND JUST SO THAT — ARE WE GOOD ON TIME? JUST A RECAP ON WHAT WE DID IN THE LAST YEAR. SO WE WORKED ON A BUNCH OF CONNECTIVITY FEATURE S SINGLE SIGN ONS AND SUPPORTED BY EXAMPLE AND A FEW OTHER DATA SOURCES. IN THE MANAGEMENT AREA, WE JUST DEMOED THE ADMINISTRATION AND MADE THAT AVAILABLE FOR SERVICE ADMINS. FOR PERFORMANCE AND DIAGNOSTIC. WE INTRODUCED LOAD BALANCING THAT DISTRIBUTES TRAFFIC ACROSS ALL THE GATEWAYS, WITHIN THE GATEWAY CLUSTER AND NAVEEN MENTIONED WHICH PORTS THE GATEWAY DOES NOT HAVE ACCESS TOO. AND TROUBLE SHOOT ON THAT DESIGNATION. AND IMPROVING DIAGNOSE SIX BREAKING DOWN THE LOG FILES INTO THREE DIFFERENT LOG FILES CREATED NET WORK AND WE TARGET A SPECIFIC GROUP DEPENDING ON WHAT YOU ARE TRYING TO DO. FINALLY THE GATEWAY USAGE AND PERMS. AND, OF COURSE, WE ARE GOING TO BE REFING THAT SOLUTION MAKING IT BETTER AS GO. IN THE CURRENT YEAR, WE ARE FOCUSING ON FOUR MAJOR AREAS BASED ON A LOT FEEDBANG WE HAVE RECEIVED AND WE ARE INCLUDING THE MANAGEMENT EXPERIENCE FOR GMANAGEMENT EXPERIENCE FOR GATEWAY ADMIN, SERVICE ADMIN AND TENANT A G+ MIN. WE WILL TALK ABOUT IT IN THE NEXT SLIDE. MONITORING DIAGNOSTICS AND HELPING GATEWAY ADMIN FIND PERFORMANCE FOR THE GATEWAYS FINALLY WORKING ON A FEW NEW CAPABILITIES LET’S JUST JUMP INTO THE DETAILS WHAT WE ARE WORKING ON FROM A CONNECTIVITY ENHANCEMENT PERSPECTIVE. THE FIRST ONE I WILL WANT TO CALL OUT IS IN POWER BI. TODAY YOU CAN ONLY CREATE ONE DATA SOURCE DEFINITION FOR A SPECIFIC SAY DATA SYSTEM. AND THIS HAS BEEN, OF COURSE, A PROBLEM FOR WRULT PELL EXEPROBLEM FOR WRULT PELL EXERCISES. SO WE HAVE BEEN MOVING THAT BLOCKER AND EARLY NEXT WE CAN WE WOULD REMOVE THAT BLOCKER WHERE YOU WILL BE ABLE TO CREATE MULTIPLE DATA SOURCE MISSIONS WITH DIFFERENT EACH WITH THE SAME DAY SYSTEM. THE SECOND ONE IS FOR DATA FTHE SECOND ONE IS FOR DATA FLOWS SO TODAY IN POWER BI DATA FL SO TODAY IN POWER BI DATA FLOWS, ONLY GATEWAY ADMINS ALTER DAY FLOWS WE ARE GOING TO ALLOW USERS AS LONG — TO GATEWAY ADMINS AND LET THEM WITH DATA FLOW. POWERAPPS AND FLOW , TO MAKE IT AVAILABLE IN NONDEFAULT, YOU HAVE TO GO THROUGH A CUSTOMER SUPPORT PROCESS WHICH IS, OF COURSE, TEDIOUS AND CUMBERSOME. BY THE END OF THE YEAR WE PLAN TO MOVE THAT BLOCKER AND USE GATEWAY S. FINALLY IN THE MANAGEMENT AND GATE — GOVERNANCE AREA. WE ARE WORKING ON A NEW MANAGEMENT EXPERIENCE FOR GATEWAY ADMINS AND OF COURSE HAVE USED MANAGED YOU GATEWAY IN POWER BI AND POWERAPPS HAVE GIVEN US FEEDBACK ON SEARCH CAPABILITIES AND MADE THAT EXPERIENCE A LITTLE EASYEXPERIENCE A LITTLE EASIER AND WE ALSO PLAN TO ADD POWER BI DATA SOURCES IN THERE TO STOP AND SEARCH AS WELL. AND ALSO INCLUDE ALL THE MANAGEMENT CAPABILITIES YOU SAW FOR TENANT ADMINS AND FOR GATEWAY AD MIS AS WELL AND FOR THE GATEWAYS THEY MANAGED. THE MONITORING ENHANCEMENT. WE ARE WORKING ON SOME OF THE FEEDBACK . LOAD BALANCING IMPROVEMENTS. TODAY AS WE MENTIONED WE CREATED THE GATEWAY RANDOMLY WE SELECT THE GATEWAY RANDOMLY AND IMPLEMENT THE NEXT PROCESS TO THAT GATEWAY. WE WANT TO CHANGE THAT AND MAKE IT A LITTLE MORE INTELLIGENT TO BE ABLE TO LOOK IN THE GATBE ABLE TO LOOK IN THE GATEWAYS, MEMORY, CPU AND NGATEWAYS, MEMORY, CPU AND NETWORK AND THEN BE ABLE TO SELECT THE BEST GATEWAY TO EXECUTE A SPECIFIC PROCESS. NEXT ONE IS BASED ON SOME FEEDBACK, WE UNDERSTAND THAT INSTALLING GATEWAYS AND REGISTERING IT., OF COURSE, TIME CONSUMING AND DOING IT ON MULTIPLE MACHINES , MULTIPLE EVALUATIONS. SO WE NEED TO WORK ON MAKING THAT EASYTHAT EASIER AND BRING IN A COMMAND THAT WILL HELP WITH A LOT IN TERMS OF INSTALLATION

AND ALONG WITH ALL THE MANAGEMENT EXPERIENCES WE SPOKE ABOUT, WE ALWAYS HAVE BEEN ASKED ABOUT A LOT OF AUTOMATION OPTIONS FOR THESE MANAGEMENT EXPERIENCES, SO WE ARE WORKING ON BRINGING — BRINGING CORRESPONDING APIs AVAILABLE TO MONITORING THESE CAPABILITIES SWAPAS WELL. THE LAST THREE HERE ARE FOR MAINLY SUPPORTED REASONS TODAY FOLKS COULD BE USING ALL THE VERSION — OLDER VERSIONS OF GATEWAY AND RUN INTO ISSUE SO AS WE PLAN TO NOTIFY USERS A NEW EDITION AVAILABLE WERE DO UPGRADE AND ONCE YOU UPGRADE YOU WILL SEE ALL OF WHAT WE HAVE DONE. AND DATA MESSAGES WORKING ON MAKING THEM CLEAN AND CONCISE AND FINALLY WE ARE ALSO REALIZING THE GATEWAY DOCUMENTATION SOS IT EASY FOR TO YOU FIND WHAT YOU ARE LOOKING FOR. THANK YOU ALL. THESE ARE ALL ON THE SEGMENTS. THIS IS THE END. YOU CAN MAKE IT TO THESE SESSIONS , YOU CAN LOOK THEM ONLINE AND DOWN LOADING THEM. THANK YOU ALL FOR JOININGS SESSION. THANKS