Category: Microsoft
Category Archives: Microsoft
Duplicate rows in order without VBA
I need to duplicate rows (without VBA), based on a cell value (column C in the example below). I found the formula below and it works in duplicating the rows, but I need the rows in the original order, not as per the actual results below:
Formula:
=SORT(CHOOSEROWS(B3:C7, TOCOL(IFS(C3:C7>=SEQUENCE(, MAX(C3:C7),,1), SEQUENCE(ROWS(B3:B7))), 2)))
Rows to duplicate:
Actual Results:
Expected results:
I need to duplicate rows (without VBA), based on a cell value (column C in the example below). I found the formula below and it works in duplicating the rows, but I need the rows in the original order, not as per the actual results below: Formula:=SORT(CHOOSEROWS(B3:C7, TOCOL(IFS(C3:C7>=SEQUENCE(, MAX(C3:C7),,1), SEQUENCE(ROWS(B3:B7))), 2))) Rows to duplicate: Actual Results: Expected results: Read More
Bing App (iOS) – news feed only displays old articles
Both when restarting the app and when refreshing, only the same news articles that are several weeks old are displayed in the feed.
When the app is reinstalled, however, new, up-to-date articles appear in the news feed on the start page. After closing and reopening the app a few times, the problem occurs again: Only outdated articles are displayed.
Both when restarting the app and when refreshing, only the same news articles that are several weeks old are displayed in the feed. When the app is reinstalled, however, new, up-to-date articles appear in the news feed on the start page. After closing and reopening the app a few times, the problem occurs again: Only outdated articles are displayed. Read More
Allow requests for On-demand services toggling off on its own
Hi folks,
I’m using Virtual appointments for the ‘meet now’ on-demand option. I’ve noticed that this is automatically toggling off after a few minutes.
Is there a reason for this happening would anyone know?
Thanks,
Hi folks, I’m using Virtual appointments for the ‘meet now’ on-demand option. I’ve noticed that this is automatically toggling off after a few minutes. Is there a reason for this happening would anyone know? Thanks, Read More
Please Post And Pages Are Not Indexing In Bing
Dear Bing Microsoft Team My Post And Pages Are Not Indexing In Bing.
https://daimond-ern.com/15-best-refer-and-earn-apps-in-india-for-2024/
Dear Bing Microsoft Team My Post And Pages Are Not Indexing In Bing. https://daimond-ern.com/15-best-refer-and-earn-apps-in-india-for-2024/ Read More
Looking back on FY24: from Copilots empowering human achievement to leading AI Transformation
A year ago in July, Microsoft coined the term AI Transformation. It is almost hard to imagine at that time Copilots were not generally available and Azure OpenAI Service had only been available for six months. As Satya Nadella, our Chairman and CEO, stated in last quarter’s earnings: 60% of the Fortune 500 have adopted Copilots and 65% use Azure OpenAI Service. Today, Copilots define how AI is empowering human achievement.
Together with our customers and partners, we have established how AI Transformation enriches employee experiences, reinvents customer engagement, reshapes business processes and bends the curve on pragmatic innovation. Our approach to put a Copilot on every desk for every role, identify AI design patterns and build a strong cybersecurity foundation is helping organizations harness AI responsibly, securely and with purpose.
As I looked back on the year, I enjoyed reviewing hundreds of customer and partner examples from around the world that demonstrated how AI Transformation delivered tangible business outcomes and value for their organizations. I am pleased to highlight 20 of those stories that I found to be the most inspirational and illustrative of what we can achieve together.
Audi is taking in-car voice control to the next level by integrating ChatGPT into its MIB 3 infotainment system using Microsoft Azure OpenAI Service, making driving safer and more enjoyable. With this update, Audi’s voice assistant will become even more intuitive, handling complex questions and offering a truly conversational experience for drivers and passengers using natural language. Starting this month, nearly two million Audi models made since 2021 are being upgraded with this generative AI-powered experience, allowing drivers to more easily control infotainment, navigation and air-conditioning systems, as well as ask general knowledge questions.
To help address Taiwan’s chronic shortage of health care workers, Chi Mei Medical Center developed AI copilots built with Microsoft Azure OpenAI Service to help overworked staff lighten their workloads while ensuring patient safety. With copilots implemented throughout its operations and at multiple patient touchpoints, medical center staff are seeing impressive results. Doctors now spend 15 minutes instead of an hour writing medical reports, and nurses can document patient information in under 5 minutes per patient instead of 10 to 20 minutes. Pharmacists are now able to double the number of patients they see per day — from 15 to 30 — by leveraging a copilot for comprehensive clinical summaries across multiple databases. By bending the curve on innovation and deploying these copilots, staff have more time to focus on patient care and outcomes, while reducing burnout and stress.
Coles, a leading Australian supermarket chain, is transforming the retail experience by leveraging AI to deepen its relationships with shoppers and improve efficiency in its stores. Coles has deployed AI models that predict the flow of 20,000 stock keeping units to 850 stores with remarkable accuracy. They are now generating 1.6 billion predictions daily, ensuring every shopper finds exactly what they are looking for when they need it. Using an AI model, Coles is also reinventing customer engagement by identifying customer patterns to provide its more than 4 million loyalty club customers with bespoke product recommendations weekly. The company is also utilizing Microsoft Azure Stack HCI and NVIDIA’s A16 GPUs to streamline checkout processes, enhance queue monitoring and elevate customer satisfaction by significantly reducing wait times.
In its quest to transform aquaculture in Indonesia, eFishery harnessed the power of Microsoft Azure OpenAI Service to create Mas Ahya, a generative AI assistant available through a mobile application. Mas Ahya equips farmers with aquaculture expertise right at their fingertips, enabling them to monitor water quality, estimate market prices and manage feeding schedules effectively. It also offers real-time insights and recommendations to maintain ideal pond conditions for more precise feeding — shortening the time from fry to market size fish from four to three-and-a-half months. By utilizing this AI assistant for queries on a range of topics — from plankton levels to remedies for diseases or bacteria affecting their stock — farmers have seen shrimp survival rates soar from 60% to 90%, further boosting their shrimp export capacity.
EY is using Copilot for Microsoft 365 to help clients adopt an AI-powered approach to tackle their unique tax, finance and operational challenges; boost efficiency; and get more value from their data. Reconciling and combining large amounts of data faster and more accurately is a game changer for Finance and Tax, driving a differentiated experience and opportunity to deliver these capabilities through EY’s core platforms and solutions. The ability to apply Copilot to vast swaths of data to develop insights helps drive smarter decision-making across the business. For example, EY professionals are seeing productivity gains of up to 14 hours per week using an AI digital assistant to automate routine tasks, freeing up time for more strategic work. The initial rollout of Copilot was so positive that EY is now scaling it to 150,000 of its employees and helping clients drive their own transformations using EY’s Customer Zero copilot accelerators.
Global design, engineering and environmental services leader GHD is leveraging Copilot for Microsoft 365 to enrich the employee experience and transform its operations to help tackle some of the world’s most complex design and engineering challenges for its clients. GHD employees can now respond to client requests more quickly by using Copilot, reducing the time spent reviewing new requests for proposals from hours to just 15 minutes. More broadly, a recent survey of Copilot users at GHD revealed that 41% are saving time in their workday, with 29% saving more than 30 minutes and 12% saving more than an hour. Additionally, 75% of users feel more efficient and 45% find their work more rewarding when using Copilot.
Hanover Research faced the challenge of efficiently processing vast amounts of data to deliver timely insights to its clients. To tackle this, the custom market research and analytics provider partnered with Neudesic to create the Hanover Intelligent Virtual Engine (HIVE), a customized AI-powered research tool using Azure OpenAI Service that eliminates the need for analysts to manually comb through its vast repository of documents. HIVE helps analysts identify insights up to 10 times faster and creates more opportunities to provide clients with information that would otherwise be buried in data and unavailable. By leveraging Azure AI capabilities to reshape business processes, Hanover has significantly boosted its research efficiency, enabling it to provide more accurate and timely data-driven insights to its clients.
Lumen Technologies was among the first companies to invest broadly in Copilot, making Copilot for Microsoft 365 available last August. Since then, the company has expanded its use of Microsoft Copilot across its organization to empower its people by simplifying workflows and inspiring a forward-thinking mindset. Today, Copilot for Sales is saving its 3,000-plus sellers an average of four hours a week, equating to $50 million annually. Sellers can now spend more time with customers, improve their work-life balance and fundamentally change the way they work.
As an integrated risk assessment firm operating globally, Moody’s Corporation has harnessed the power of AI through Azure OpenAI Service, Microsoft Fabric and Microsoft Teams to significantly enhance productivity and insights. Through our co-innovation efforts, we built an internal tool — Moody’s Copilot — that enables employees to quickly synthesize vast amounts of research and data, and 94% of users reported increased productivity. Additionally, the launch of Moody’s Research Assistant allows customers to generate new insights from extensive credit research, data and analytics, potentially saving users over 25% of their time on typical financial analyst tasks.
OCBC bank is empowering its global workforce with generative AI-powered solutions to boost productivity and enhance customer engagement. Built upon Azure OpenAI, the bank developed a digital assistant for use within a secure and controlled Microsoft Teams environment to help employees in their daily work across customer service, research, product management and marketing roles. Since using the tool, employees have reduced time spent on tasks such as writing, research, translation and ideation by approximately 50%, with 72% of team members reporting significant improvements in their day-to-day productivity and more time to focus on customers.
As one of the largest combined natural gas and electric companies in the U.S., Pacific Gas & Electric Company (PG&E) had an ambitious goal to reshape its business processes by automating low-value tasks and rededicating employees to focus on high-value work. By implementing Microsoft Power Platform solutions, its Digital Creators and citizen developers created new business solutions, saving nearly 527,000 hours and generating approximately $75 million in savings annually. Using Microsoft Copilot Studio, the company also built a digital assistant that fulfills 25% to 40% of help desk demands, significantly optimizing agent workloads and providing sizeable labor savings and service-level improvements — saving teams 840 hours and the company more than $1.1 million per year.
As a leading insurance and reinsurance company in Peru — and one of the largest in Latin America — Pacífico Seguros partnered with TC1 Labs and leveraged Microsoft AI, Microsoft 365 and Azure AI solutions to reshape business processes, improve data management and enhance customer interactions. Pacífico Seguros reported a 40% increase in operational efficiency and a 30% reduction in response times to customer inquiries. It also implemented Microsoft Copilot for Security with a Zero Trust approach, drastically boosting responses to cyber threats and delivering ongoing protection of critical systems and data. This AI Transformation has improved service quality and enhanced security across its business.
Paysafe, a leader in specialized payments, supports 260 payment types in more than 40 currencies and enables seamless transactions for businesses and consumers worldwide. By leveraging Copilot for Microsoft 365 the company has transformed its operations to ensure secure and efficient processing across different payment methods. Paysafe uses Copilot to address the challenges of a diverse and multilingual global workforce, using it to translate everything into various languages — document policies, standard operating procedures and meetings — to save both time and money. Compared to preparing documentation from scratch or searching for information manually, Paysafe’s IT team saves between 10% and 50% of their time with Copilot.
Fintech company Saphyre creates real-time client account reconciliation and management solutions for institutional parties involved in financial trading. The company is using Microsoft Azure to provide intelligent, cloud-based solutions that automate and streamline complex financial trading workflows and modernize time-consuming processes efficiently and securely. Using Azure AI, Saphyre built a solution that helped clients reduce manual paperwork by 75%. It is also sharing data more securely using Microsoft security products so clients can be ready to trade three to five times faster compared to manual onboarding. This results in increased revenue opportunities for clients by completing trades more quickly and at better prices.
Softchoice has partnered with Microsoft to help companies drive efficiencies, reinvent customer engagement and address cybersecurity threats. By implementing Copilot for Microsoft 365, Softchoice has achieved significant productivity gains, reducing time spent summarizing technical meetings by 97%, creating internal training modules by 70% and developing customer-facing technical content by 62% to 67%. With Microsoft Copilot for Security built into daily dashboards, the company’s analysts are saving 20% to 30% of their time summarizing pertinent information needed to execute tasks. Analysts can more quickly determine if failed sign-ins are routine or accidental, saving 20-30 minutes each morning and freeing up time to focus on those that require more in-depth analysis. Security incidents can now be audited faster, reducing the time and resources needed to manually review by 50% and improving efficiency by 30% to 40%.
TomTom, a global leader in mapping and navigation technology, faced the challenge of a fragmented development process with too much time spent navigating multiple tools. By centralizing on the GitHub platform and integrating GitHub Copilot into its development processes, TomTom has streamlined workflows to deliver products to customers more quickly than ever. Additionally, 85% of developers report feeling more productive and 70% feel they can focus on more satisfying work by reducing cognitive workloads and enhancing collaboration among development teams.
Australia’s Torrens University set a goal to transform its digital learning environment to deliver a superior online student experience. It developed MyLearn — a modern online platform built with Azure OpenAI Service — to provide a consistent and convenient learning environment for students anytime, anywhere. By leveraging generative AI, the university has standardized and improved course curriculums, saving an impressive 20,000 hours and $2.4 million Australian dollars in time and resources. This AI-driven approach not only streamlined its digital learning environment but also set the stage for future savings and agile curriculum updates, creating a more engaging and efficient educational experience for students.
Unilever, a global leader in consumer products across over 190 countries, is working with Microsoft to revolutionize scientific discovery and positively impact the 3.4 billion people it serves daily. With Copilot and the advanced simulation capabilities of Azure Quantum Elements, Unilever can query scientific information using natural language, performing thousands of computational simulations in the time it would take to run tens of laboratory experiments. This technological leap, combined with its vast repository of proprietary data and a century of expertise in personal and household care, enables Unilever’s scientists to lead the industry in developing the next generation of eco-friendly household and personal products through sustainable product development.
As a leading provider of workplace benefits and services, Unum Group set out to enrich the employee experience by modernizing the manual and time-consuming process of retrieving policy information for inquiries from its client support center. With Azure OpenAI Service, the company developed an application that searches 1.3 terabytes of data with 95% accuracy, cutting response times to four to five seconds and significantly improving efficiency and customer satisfaction. The AI-generated results address 75% of contract-related questions, freeing up employee time for personalized solutions and interactions with clients. Employees trust the tool and feel it has improved their jobs, and now more than 90% of support center employees are using it.
Visma develops and tests software for over 1.8 million customers across Europe and Latin America through its 188 individual companies. Facing high inflation and tight labor markets, it turned to Microsoft AI technologies such as Azure OpenAI Service, Semantic Kernel and Azure AI Search to securely boost efficiency and customer satisfaction across its companies — each with their own customers and domain. Visma developers are using GitHub Copilot to streamline development processes, automate workflows and enhance collaboration. As a result, it has reported up to 50% reduction in development times. GitHub Copilot has also helped Visma developers unleash their creativity and bend the curve on innovation; the company has seen a marked increase in innovation since adopting the solution, even among those who have been working on the same code for 30 years.
Our mission has never been clearer: to empower every person and every organization on the planet to achieve more. We remain committed to democratizing intelligence and unlocking AI opportunities industry by industry in the year ahead by bringing Copilot to life on every device and across every role. We are focused on our co-innovation efforts to identify AI design patterns that will enable our customers and partners to build out their AI innovation environments. We are committed to helping you fortify your cybersecurity foundation by prioritizing security above all else — securing our products by design, by default and within our own operations as part of our Secure Future Initiative. As we continue leading in AI Transformation, we remain rooted in the fact we are at our best when we serve others, and I look forward to what we will accomplish together in the year ahead as your trusted cloud and AI partner.
The post Looking back on FY24: from Copilots empowering human achievement to leading AI Transformation appeared first on The Official Microsoft Blog.
A year ago in July, Microsoft coined the term AI Transformation. It is almost hard to imagine at that time Copilots were not generally available and Azure OpenAI Service had only been available for six months. As Satya Nadella, our Chairman and CEO, stated in last quarter’s earnings: 60% of the Fortune 500 have adopted…
The post Looking back on FY24: from Copilots empowering human achievement to leading AI Transformation appeared first on The Official Microsoft Blog.Read More
Cannot enable this option in Teams on RDS Server
Hello
Please i need your help on this issue.
I have a Customer that cannot enable this option in teams on RDS server “Register the New Teams as the chat app for Microsoft 365”.
Hello Please i need your help on this issue. I have a Customer that cannot enable this option in teams on RDS server “Register the New Teams as the chat app for Microsoft 365”. Read More
Company reporting on Praise
HI,
I’ve been tasked with evaluating Viva to potentially displace a few products we currently use. One of those is TinyPulse. I can see that Viva Pulse absolutely replaces the survey function, but we have a particular requirement of the Praise function that I can’t find.
Once a month we do a ‘spin the wheel’ of everyone who has sent praise, and another of everyone who receives praise. If your name is picked then you get a small prize – wine, beer or chocolate, or an Amazon voucher if none of that appeals. To do that, the leadership need to know who has sent and who has received praise. They don’t necessarily need to know what the praise was (although that would be nice). Is there any way to do this with Viva Insights Praise?
HI, I’ve been tasked with evaluating Viva to potentially displace a few products we currently use. One of those is TinyPulse. I can see that Viva Pulse absolutely replaces the survey function, but we have a particular requirement of the Praise function that I can’t find. Once a month we do a ‘spin the wheel’ of everyone who has sent praise, and another of everyone who receives praise. If your name is picked then you get a small prize – wine, beer or chocolate, or an Amazon voucher if none of that appeals. To do that, the leadership need to know who has sent and who has received praise. They don’t necessarily need to know what the praise was (although that would be nice). Is there any way to do this with Viva Insights Praise? Read More
Randomly 401 errors accessing AZ Devops artifacts
Hello!
We are experiencing random 401 errors during maven download artifacts.
The token is valid. It happens randomly. We’re not sure whether there is something wrong on Azure Devops. Is anybody experiencing the same issue?
Thanks!
Hello!We are experiencing random 401 errors during maven download artifacts.The token is valid. It happens randomly. We’re not sure whether there is something wrong on Azure Devops. Is anybody experiencing the same issue?Thanks! Read More
Total in filtered list
since a few days the totals at the bottom of my list don’t show any more when I use a filter; does any one now the reason and above the cure to this malfunction? many anticipated thx
since a few days the totals at the bottom of my list don’t show any more when I use a filter; does any one now the reason and above the cure to this malfunction? many anticipated thx Read More
“The data area passed to a system call is too small” in MS teams
Hello 🙂
I wanted to ask if someone of you had as well the same issue when you start MS Teams: “The data area passed to a system call is too small”.
The Microsoft Store has been blocked.
Thanks in advance for your help.
Best regards!
Hello 🙂 I wanted to ask if someone of you had as well the same issue when you start MS Teams: “The data area passed to a system call is too small”.The Microsoft Store has been blocked. Thanks in advance for your help. Best regards! Read More
Windows Update Problem
Hello, can someone help me or explain why is my laptop does this when i clicked windows update? (it kept loading and loading but still blank like this). i am currently using Windows Version 1909. Thanks in advance, please let me know anything to resolve this problem.
Hello, can someone help me or explain why is my laptop does this when i clicked windows update? (it kept loading and loading but still blank like this). i am currently using Windows Version 1909. Thanks in advance, please let me know anything to resolve this problem. Read More
New on Microsoft AppSource: July 8-17, 2024
We continue to expand the Microsoft AppSource ecosystem. For this volume, 258 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
1000minds Agribusiness: 1000minds decision-making and conjoint analysis software helps businesses, government agencies, and non-profit organizations identify desirable traits for breeding plants and animals in the agriculture industry. Experts from various fields can collaborate to improve the usefulness of cultivated species.
AKQUINET 365 Advanced VAT Determination: The complexity of VAT regulations can lead to incorrect bookings, requiring time-consuming corrections. AKQUINET’s app helps define the correct VAT key based on your business context. It minimizes errors and saves time by utilizing a VAT decision tree to define the correct VAT key for each sale or shipping transaction. This application is available only in German.
AML Transaction Monitoring and Sanction Screening for Banks and FinTech: ThetaRay’s AI-powered solution helps financial institutions detect anomalies in unlimited data sets to pinpoint suspected cases of money laundering with virtually no false positives. It identifies unknown malicious events, uncovers previously unknown typologies, and detects third-and-fourth-party risk more effectively.
DocFusion Platform: Enterprise DocGen: Trusted by major financial institutions and enterprises globally, the DocFusion platform offers intelligent document automation with features such as automated document generation, integration capabilities, compliance and governance controls. Its customizable workflows and simplified template management increase productivity, save costs, and improve customer experience.
tensai GenAI-based Knowledge Ecosystem: Hexaware’s tensai GenAI Knowledge Base System, powered by Azure OpenAI’s GPT-4, offers dynamic knowledge management, enhanced security, streamlined information retrieval, and continuous quality assurance. It reduces search times, lowers operational costs, and future-proofs knowledge management systems.
Finout Enterprise: Finout is a holistic FinOps cost management solution that helps companies of all sizes manage, reduce, and optimize costs. It provides complete visibility and context of cloud costs, with features such as MegaBill for observability, Virtual Tag for accurate cost allocation, CostGuard for waste reduction, Cost Governance Suite for advanced business context, and Custom Dashboards for democratizing FinOps.
FORAMIND: Enrich you training resources and develop effective learning techniques with this AI-powered tool for creating mind maps, a technique for visualizing and organizing information. It offers ready-made as well as custom templates and the user-friendly interface allows you to easily edit the maps.
FS Pro for Word: FS Pro for Word is an AI-enabled add-on for Microsoft Word that allows you to standardize and structure your information, making it easy to manage, share, and reuse. It can be used to create clear policies, user guides, proposals, meeting notes, reports, and more.
H2 Digital for Hydrogen Market Development: This H2 digital platform helps businesses and policymakers navigate the complexities of the hydrogen market. It offers market analysis, networking tools, digital asset management, and project support for managing hydrogen projects from concept to operation.
Hewani: Hewani’s platform enables tracking of transactions and capturing of qualitative information for traceability, monitoring and evaluation purposes in the food and agriculture industries. This flexible and scalable solution includes mobile apps, web portals, and data analytics and empowers merchants to seamlessly manage their supplier purchases and customer sales within a single ecosystem.
INSAN Human Resource Management System: Streamline all your HR tasks with INSAN’s cloud-based HR management system. This comprehensive suite includes modules for payroll, personnel, time and attendance, employee and manager self-service, task management, time sheets, expenses management, and more. It enhances accessibility to HR-related data via web and mobile platforms, optimizing operations for a rapid return on investment.
Invoice Generator: This invoice generator app requires the desktop version of Microsoft 365 and uses Excel to easily generate invoices, quotations, and purchase orders. It includes 400+ free professional templates, customer management, streamlined workflow, purchase order power, flexible formatting, professional touch, and payment tracking.
Multilingual, Conversational AI Chatbot: This multilingual and omnichannel chatbot can be built using a no-coding dashboard. It integrates with internal tools for streamlined operations, expanding global reach and boosting efficiency. Engage customers with AI-powered conversations across websites, social media, and apps.
NobleManufacturing: Noble.AI’s platform can be used to analyze datasets of known chemical properties and predict the likelihood of ingredient compatibility and stability to accelerate sustainable design and redesigns using “green chemistry” in the formulation of your R&D and innovation process. Reduce costs, and improve product performance, sustainability, and reliability with NobleManufacturing.
Non-Ribbon Chord Diagram: The Non-Ribbon Chord Diagram by VisioChart is a powerful tool for visualizing complex relationships within a dataset. Its circular layout, color coding, and interactive features make it an invaluable asset for any data analyst looking to present data in a clear and impactful way. It utilizes Microsoft Power BI to represent complex relationships in an intuitive and visually appealing manner.
One by ClariLog: One by ClariLog is a cloud-based solution for managing IT assets and user support. It offers network inventory, asset and software management, technician and user portals, multichannel ticketing, customizable notifications and dashboards. This service is available only in French.
PandaDoc for Dynamics 365 Business Central: PandaDoc eSignature add-on for Microsoft Dynamics 365 Business Central streamlines the process of sending and tracking documents for signature without leaving the app. It allows for up to two signature recipients, status tracking, and the ability to send signatures from individual or centralized accounts. No need to switch between apps.
Paper Polisher for Outlook: Paper Polisher is an AI-based writing assistant that enhances the efficiency, accuracy, and professionalism of business documents with collegiate vocabulary substitutions, professional grammar conventions, and proper punctuation. It refines content and improves the clarity of writing with a single click.
Reachr: This recruitment and selection platform from R&S uses AI to generate insights to make your hiring process more streamlined and cost-effective. Integrated with Microsoft Power BI, Reachr optimizes operational processes and helps your HR team reduce time spent on recruitment by up to 50 percent. This service is available only in Brazilian Portuguese.
Rubisight: Rubisight is a data visualization software that helps business users and analysts connect to any data source and create impactful visualizations on the fly. It allows decision makers to focus on the most relevant information without losing sight of the bigger picture, and build data monitoring, analysis, and reporting applications without any coding efforts.
Sapiens Cloud Services: Sapiens on Azure offers the benefits of cloud computing and managed services for insurers. Their unified DevOps and security processes provide end-to-end support and enable customers to gain a holistic view with one service manager leveraging a unified desk for all issues while maintaining a 99.5 percent service availability rate.
SAS Premium Learning Subscription: SAS Institute’s global access learning subscription offers a comprehensive program for organizations to train employees in data analytics. With access to hundreds of courses, hands-on practice, and progress reports, managers can track employee development. The subscription includes on-demand courses, certification practice exams, and digital badges.
SCORE (Security and Compliance Overall Risk Evaluation): SCORE is a cybersecurity tool that assesses an organization’s cybersecurity posture through a questionnaire, vulnerability test, and Open Source Intelligence that actively scans the dark web for threat information. SCORE aids compliance with the Digital Operational Resilience Act and assists with prudent lending by banks, risk analysis for insurance companies, and supply chain protection for large corporations.
Senso for Microsoft Teams Chat Monitoring: Senso for Microsoft Teams monitors chats and images for inappropriate content using an AI-based visual threat detection engine. It allows counselors and leadership teams to receive alerts via the app or on Senso’s platform logs. Users can also directly report concerns within Microsoft Teams.
Vennflow SaaS API Handle: Vennflow uses AI to consolidate data sources into a reliable source, solving digital marketing attribution challenges for companies. VennFlow’s AI platform seamlessly integrates with your sales, marketing, and financial applications to boost revenue and minimizes expenditure.
Zei: Simplified Regulatory ESG Compliance: Zei collects, manages, and reports ESG and CSR data used by companies worldwide. It offers pre-defined frameworks and standards, centralizes all models, streamlines data collection, and enhances report reliability. Users can select reporting frameworks, import data, digitize and unify ESG data collection, customize organizational architecture, share data, and build a roadmap.
Zellis HCM AIR: This comprehensive HCM suite is designed for medium to large enterprises in the UK and Ireland. The platform integrates with third-party apps to streamline HR, payroll, benefits, and recognition processes. It automates complex processes and offers AI-powered anomaly detection, data entry, and aims to improve employee engagement, productivity, and retention.
Go further with workshops, proofs of concept, and implementations
Dynamics 365 Business Central Discovery: 4-Hour Workshop: Isystems Group will introduce your business to the transformative capabilities of Microsoft Dynamics 365 Business Central. The workshop includes a discussion of current processes, pain points, and objectives, an overview of the software’s core functionalities, and tailored solution mapping.
Security Service Edge Quickstart: Avanade’s quickstart pilot methodology enables organizations to accelerate their zero-trust journey by exploring the benefits of Microsoft’s identity-centric Security Service Edge solution with rapid adoption and value realization. Key outcomes include understanding the future state of internet access, a roadmap for longer-term deployment, and phase-out of incumbent products.
Copilot for Microsoft 365: Change and Adoption Framework: With a focus on the user perspective, this change and adoption workshop will introduce Copilot for Microsoft 365 to key user groups in your organization so they can support the implementation of Copilot and act as multipliers. The framework aims to synchronize and continuously improve your team’s skillset for optimal change management.
Copilot for Microsoft 365: Implementation and Adoption: Konica Minolta’s implementation service offers customized guidance for licensing, security, and technical preparation. Their experts will offer hands-on guidance customized to your needs, adoption training, and support for efficient management of Copilots’ resources, infrastructure, security, and licenses.
Copilot for Microsoft 365: Inspiration and Readiness Assessment: Utilizing a series a workshops, Konica Minolta will offer a practical step-by-step plan that goes beyond AI hype so you can prepare, implement, and adopt AI tools tailored to your organization’s needs. An overview of Copilot for Microsoft 365, security, legislative framework, and a concrete plan for your business will be provided.
Copilot for Microsoft 365 Quickstart: ivision offers a comprehensive approach to evaluate technical requirements and baseline security strategies for responsible AI and Copilot for Microsoft 365 adoption. The solution provides proven techniques for enhanced productivity and collaboration, integrated AI solutions, and a roadmap for implementation and use case development.
Copilot for Microsoft 365: 3-Day Readiness Workshop: The experts from Professional Advantage will assess your organization’s readiness for Copilot for Microsoft 365, prioritize use cases, and develop a roadmap for implementation. The workshop is recommended for leadership teams, IT executives, and line of business leaders. Tailored Copilot training programs are provided along with ongoing support.
Copilot for Microsoft 365: 4-Month Adoption and Implementation: Perficient’s Copilot for Microsoft 365 Adoption and Implementation engagement offers a secure and successful adoption of Copilot for Microsoft 365, with an emphasis on enhancing productivity and leveraging AI. The engagement includes assessing and planning, preparing, deploying, and driving adoption along with supporting end-users.
Copilot Office Hours: 3-Day Engagement: Copilot for Microsoft 365 is a generative AI tool that integrates with various Microsoft 365 apps. It offers tailored workflows and interactive demonstrations to increase productivity, enhance understanding, improve collaboration, and provide actionable insights. Synergy Technical’s engagement will empower your organization with the full capabilities of Microsoft 365 Copilot.
Copilot Studio: 9-Day Proof of Concept: Inetum will provide support to create a functional proof of concept utilizing Microsoft Power Platform services to help you think, try, and customize virtual assistants or copilots based on natural language processing technology. Learn how you can automate recurring tasks to increase productivity, enhance user experience, and enable continuous innovation.
Copilot Studio: 5-Day Workshop: Inetum’s workshop will help you create and customize virtual assistants or copilots based on natural language processing technology. Utilizing Microsoft Power Platform, the workshop will offer basic templates for various use cases and integrates with other applications and services and can be deployed on mobile apps, websites, and voice assistants.
Credit Review Tool: Protiviti’s custom solution is built on the Microsoft Power Platform and Dataverse and allows clients to manage and aggregate line sheets in a single platform. The Credit Review Tool offers data integration, analysis, and visualization through Power Apps, Power Automate, and Power BI. The client has complete control over the application code and data, and the solution comes with documentation, managed and unmanaged solutions, and guidance on deployment and customization.
Customer Engagement & Insights with Dynamics 365: 12-Week Implementation: Establish unified databases, resolve identities, creates 360-degree customer profiles, and analyze data for valuable insights in this custom implementation by Enterprisecloud. Their experts will assess your current customer data platform and help evaluate if Microsoft Dynamics 365 with built-in AI capabilities and seamless Microsoft 365 integration can elevate and transform your approach to customer engagement.
Dashboard in a Day: 1-Day Workshop: Available in Spanish and English, Derevo’s workshop on Microsoft Power BI will teach attendees how to load and manipulate data from various sources, create interactive reports, and access data from mobile devices. The workshop aims to help individuals understand how to analyze data effectively and efficiently. Attendees will be able to connect with data, define business rules and KPIs, create reports, and share them with their team and business partners.
DNS & Safe Sender Enablement for Microsoft 365 Mail: Configuration and 1-Month Monitoring: Finchloom’s DNS & Safe Sender Enablement for Microsoft 365 Mail enhances domain protection by configuring and optimizing DNS settings, implementing DMARC, SPF, and DKIM protocols, and automating the process through Valimail Enforce. The comprehensive approach includes analysis and fixing of email authentication records, monitoring for authorized senders, and providing guidance to continue monitoring.
Foodics with Dynamics 365: Evincible Solutions will show you how integrating Foodics, a leading point-of-sale and restaurant management solution, with Microsoft Dynamics 365 can enhance operational efficiency and data coherence for F&B businesses. Benefits include unified data management, real-time synchronization, enhanced reporting and analytics, streamlined processes, and improved customer experience. Evincible Solutions offers expert consultation, seamless implementation, training, and support.
Enterprise Contact Center Implementation with Dynamics 365: Netwise will implement the Microsoft Digital Contact Center Platform powered by Dynamics 365 so you can offer round-the-clock support through intelligent chatbots and virtual agents. Engage customers with omnichannel capabilities and features like real-time sentiment analysis, automated routing, and comprehensive analytics. The offer includes detailed planning, mapping business needs, quality assurance and testing, and post-implementation support.
ERP Strategy: 1-Day Workshop: The experts from Fellowmind will review your processes and existing solutions and help choose the right ERP system that best fits your business needs. The workshop will focus on the benefits and capabilities of Microsoft Dynamics 365 Business Central, Dynamics 365 for Finance, and Dynamics 365 Supply Chain Management. An initial project and implementation roadmap as well as an outlook on utilizing connectivity within the Microsoft ecosystem and AI will be provided.
File Migration: 1-Day Workshop: Valto specializes in migrating files to Microsoft SharePoint, OneDrive, and Teams, including from third-party platforms. Their Microsoft 365 File Migration Service streamlines file management, enhances collaboration, and improves data security. This one-day workshop will help you develop a customized migration strategy and execution with minimal disruption to business operations.
Fit for Business Central: 4-Day Workshop: SPOTS provides this workshop for newcomers and those switching to Microsoft Dynamics 365 Business Central. It covers basic information, interfaces, menu structures, and tools like filters. Participants will also learn about Microsoft Copilot and other functions, financial accounting, purchasing, assembly, marketing, sales, and warehouse modules.
McChrystal Group Change Management with Microsoft Copilot: McChrystal Group’s change management program helps organizations achieve their objectives with Microsoft Copilot. The four-phase approach includes evaluation, digital learning, identifying key influencers, and progress monitoring. The program takes 10-14 months and includes dedicated team members, subject matter experts, digital learning for up to 30,000 users, and ambassador cohorts.
Copilot for Microsoft 365: Design Sprint: This design sprint from Meltlake is ideal for organizations starting their Copilot for Microsoft 365 journey. Attendees from IT, HR, and communications will co-create a Copilot adoption strategy, exploring topics such as current state assessment, readiness mapping, and use-case discovery. Deliverables include a prioritized list of potential use cases and an actionable roadmap.
Copilot for Microsoft 365: HSO Foundations Program: Implement an actionable approach to Copilot for Microsoft 365 with HSO’s Foundations Program. The program offers a step-by-step approach to safely and efficiently embrace the full capabilities of Copilot for Microsoft 365. The program includes four levels of engagement, from discovery to implementation, and is tailored to each organization’s specific needs. The program helps identify potential use cases, assess data readiness, and deliver a change and adoption plan.
Copilot for Microsoft 365: 1-Day Immersion Workshop: Intech offers an immersive workshop for business leaders, department heads, IT managers, and end-users to experience the transformative power of Copilot for Microsoft 365. The workshop covers generative AI, prompt engineering, an overview of the Microsoft Copilot ecosystem, and includes hands-on demos and persona-based scenarios for various departments.
Microsoft Copilot Adoption Accelerator: This pilot engagement helps large enterprises design, implement, and evaluate the use of Microsoft Copilot. It includes use case development, Centre of Excellence development, an adoption champions program, Microsoft Purview content search and information protection, and SharePoint restrictions and site allow list. The engagement lasts 4-to-6 weeks and requires participation and commitment from key stakeholders and a minimum of 10 developers.
Microsoft Copilot Value Discovery: This workshop helps organizations identify and develop use-cases for Microsoft Copilot rollout and adoption while ensuring sensitive data is only accessible to authorized users. Copilot is an AI assistant that helps employees be more efficient and creative across the Microsoft 365 suite, assisting with tasks such as automating workflows, editing natural language, and improving code quality. The workshop covers Copilot features, use case development, content search, sensitivity labeling, and SharePoint site restrictions.
Microsoft Fabric Implementation: Unlock the full potential of your data with Folio3’s Microsoft Fabric implementation. Their services include data integration and management, warehousing, real-time analytics, and business intelligence. This implementation will provide customized solutions, migration services, and expertise with over 200+ certified experts. Folio3 utilizes Fabric’s advanced capabilities for scalable data processing, real-time data streaming, advanced analytics and machine learning, and more.
Power BI Commenting and Budgeting: IT-Logix offers Inforiver, an add-in for Microsoft Power BI that allows users to capture, annotate, and save data directly in Power BI. With Inforiver, users can enter data directly in a Power BI report and write it back to a database, add comments to individual data points, reply to comments from other people in the company, define access rights to data, and integrate data enrichment and commenting into existing Power BI reports.
Power BI Data Modeling Tutorial for Controllers: IT-Logix ‘s hands-on tutorial for Microsoft Power BI data modeling for controllers helps you create suitable models, map processes, and compile data professionally. It covers core invoicing processes, customer and location information, budgeting and extended modeling options along with implementing data requirements independently.
Power BI Report: drjve AG’s offer, available only in German, guarantees cost transparency and helps you create visually appealing and in-depth reports using Microsoft Power BI. Learn how you can turn your data into visuals with advanced data-analysis tools, AI capabilities, and a user-friendly report creation interface.
Microsoft Teams AI Bot Customization: 1-Day Workshop: This one-day workshop helps organizations explore and leverage AI capabilities within Microsoft Teams by creating custom AI bots tailored to specific enterprise needs. Participants will gain hands-on experience with Microsoft 365 developer tools and APIs, and receive a conceptual framework for AI bots that address their specific business needs.
Microsoft Teams Phone Pilot: 60-Day Proof of Concept: The Microsoft Teams phone pilot is a remote proof of concept designed to demonstrate the value of the Teams Phone in your environment. It includes aligning stakeholders, configuring and testing Teams Phone with various PSTN connectivity options, and developing next steps for scaling deployment. The pilot ensures seamless integration of calls into workflows, meets business needs with modern calling features, and optimizes IT resources with streamlined setup and management.
XDR Shield: 4-Week Implementation: XDR Shield from Long View provides comprehensive visibility and proactive security for Microsoft Cloud environments, integrating all products within the Microsoft Defender suite. The solution offers threat detection, process automation, advanced analytics, threat hunting and remediation. XDR Shield combines Microsoft Defender XDR and Sentinel with Long View’s Security Operations Center to provide advanced threat intelligence, automation, and expert human oversight.
Contact our partners
Taiwan Accent AI Simulator Voice Generation Service
Adalyser to Azure SQL Connector
Advance Budgeting for Dynamics 365 Finance and Supply Chain Management
Advanced Document Attachments (GB)
AgreeYa’s Microsoft 365 Copilot Readiness Assessment
Alterna Platform for K3 Pebblestone
Analytics 365 Call Analytics: Demo
ASAP (Advanced Semantic AI Platform)
AXM Integrations: 7-Day Assessment
Beey.io AI Transcription Software
BI Pixie – Engagement Metrics for Power BI (Enterprise Version)
BI Pixie – Engagement Metrics for Power BI (Starter Version)
BMC Control-M Delivered by Amdocs Digital Engineering
BMC Digital Service Operations Management (ServiceOps) Delivered by Amdocs Digital Engineering
BMC Helix IT Service Management, Delivered by Amdocs Digital Engineering
BS Unique Certification for Italy
Business Central Consulting: 1-Hour Assessment
ConnectIn Marketing App for Dynamics 365 Finance and Supply Chain Management
Construction Management System
Contract Management for Dynamics 365 Finance and Supply Chain Management
Copilot Studio: Implementation
Dynamics 365 Business Central Pre-Implementation Consulting
Daisycon to Azure SQL Connector
DesireInfoweb Organization Chart
Devart ODBC Driver for ASE(SAP)
Devart ODBC Driver for Firebird
Devart ODBC Driver for PostgreSQL
Devart ODBC Driver for Salesforce
Digikraft TrackIFY – Telephony
Dynamic Retail Expansion Package for Austria and Germany
Easy Currency Exchange Utility
EdgeMethods Industry 4.0 Fabric Connector Platform
edoc archivelink for Dynamics 365 Business Central
ELEKS Microsoft Copilot Readiness Assessment
Elevate Tech Predictive Remote Monitoring and Diagnostics
Employee Onboarding and Offboarding
EverestDX BotX for Automated Multi Cloud Control
Exopen Power BI Financial and CRM Reports
Flip – The Observability Intelligence Platform
GenAI based DataGenie (Content Generation)/Automatic Response Scribe
GenAI based DataGenie (Document Analyzer)
Google Ad Manager to Azure SQL Connector
GST Localisation Pack for Singapore
Healthcare Insurance for Dynamics 365 Finance and Supply Chain Management
Healthcare Modernization with Secure and Complaint AI Deployment
HouseVizit: AI Healthcare Chat
Intelligent Order Management Report
Investment Module for Dynamics 365 Finance and Supply Chain Management
Lubyc For Accounting Management System
Lubyc for Agreement Management
Lubyc for Asset and Inventory Management
Lubyc for Customer Relationship Management
Lubyc for Financial Management System
Lubyc for Human Resource Management
Lubyc for Product Management System
Lubyc for Storage Management System
Lubyc for Talent Acquisition System
Manufacturing Localization for Microsoft Dynamics 365 Business Central
McChrystal Group Copilot Impact & Readiness Assessment
MDS – Data Security Readiness Assessment for Copilot for Microsoft 365
Microsoft 365 and Azure: 2-Week Cloud Readiness Assessment
Microsoft Defender for Office 365 Security: 1-Day Assessment
Microsoft Sustainability Manager: 4-Week Consulting Service
Modern Trade Rebate for Dynamics 365 Finance and Dynamics 365 Supply Chain Management
NashTech Application Engineering Services
Offimac Business Central Project Management
PageSpeed Insights to Azure SQL Connector
Payroll Tax Engine for Dynamics 365 US Payroll
PERA Loyalty Experience Platform
SwiftShift – Gen AI-Driven Salesforce to Dynamics 365 Migration
Popl Lead Sync Add-In for Outlook
PowerON Visual Planner Service
Predict.AI for Tire Pressure Monitoring
Production Cost Simulator for Dynamics 365 Finance and Dynamics 365 Supply Chain Management
RTB House to Azure SQL Connector
Scribe – Corporate Intelligence
Security Risk and Compliance Assessment
Spiral Plot By Office Solution
Stripe to Azure SQL ConnectorWindsor.ai
SymphonyAI – Promotion Optimization
T-Type Balance Sheet and Profit & Loss account
Treasury Management for Dynamics 365 Finance & Dynamics 365 Supply Chain Management
Updatedge – Workforce Availability Management (SaaS)
Verify Traceability and HACCP System
WhatsApp Order Integration for Microsoft Dynamics 365 Business Central
XE and Oanda Exchange Rates FnO
ZATCA Integration with Dynamics 365 Business Central
ZINFI Unified Partner Management Platform
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
Why is Multi-user mode not working in Desktop and How to fix it?
I’m having trouble with QuickBookѕ Desktop multi-user mode. It’s not working, and my team can’t access the company file simultaneously. I’ve tried restarting the software, but the issue persists. How can I fix this?
I’m having trouble with QuickBookѕ Desktop multi-user mode. It’s not working, and my team can’t access the company file simultaneously. I’ve tried restarting the software, but the issue persists. How can I fix this? Read More
Excel cannot be open because the file format or file extension is not valid
Hi All,
There is an Excel.xlsx file in my computer named mindmagiq.xlsx. I accidentally deleted that file and then I recovered it with the help of a recovery file tool.
There was no error in the last modified date
The below error message appears every time I try to open the file.
I even tried to “open and retrieve” but nothing happen
Please find below URL of the excel sheet
” https://docs.google.com/spreadsheets/d/1WyT-Tf0kkZP9O8xX2KCC7kYIbKulettk/edit?usp=sharing&ouid=104272184253534778322&rtpof=true&sd=true”
please see if it can be recovered
Thanks
Hi All, There is an Excel.xlsx file in my computer named mindmagiq.xlsx. I accidentally deleted that file and then I recovered it with the help of a recovery file tool.There was no error in the last modified date The below error message appears every time I try to open the file.I even tried to “open and retrieve” but nothing happen Please find below URL of the excel sheet ” https://docs.google.com/spreadsheets/d/1WyT-Tf0kkZP9O8xX2KCC7kYIbKulettk/edit?usp=sharing&ouid=104272184253534778322&rtpof=true&sd=true” please see if it can be recoveredThanks Read More
Can’t use tho top bar of a list
When trying to sort a SharePoint list or use any of the buttons on the top bar, I can’t get the sub-menu to show up.
I’ve tried to create a new list, but even then I get the same result.
Before that, I used to get an error saying to try again later.
When trying to sort a SharePoint list or use any of the buttons on the top bar, I can’t get the sub-menu to show up.I’ve tried to create a new list, but even then I get the same result.Before that, I used to get an error saying to try again later. Read More
Very grey/dark video quality on my screen when making a video call (Teams for iOS)
Hello,
New issue on my personal Teams when in a video call the video very grey/dark to me on my screen (both my video feed in the corner and the person I’m calling’s video) however the colour quality is fine for the person receiving the call.
I’m using Teams for iOS. So far I have reset my laptop, deleted and reinstalled the Teams app, signed out and back in multiple times and deleted my teams cache but it still isn’t working. It literally changed overnight so don’t know what has happened.
The only way I can describe it, is as if someone has highlighted the screen when I’m in a video call…you know when you highlight a picture on a webpage and the colour goes hazy/grey. I even tried changing the theme from dark to light but in light mode it’s even more prominent.
Any suggestions would be great- thanks!
To add – all other apps, (WhatsApp, FaceTime) the brightness is fine when using the camera so it is isolated just to teams and only happens when my camera is on.
Hello, New issue on my personal Teams when in a video call the video very grey/dark to me on my screen (both my video feed in the corner and the person I’m calling’s video) however the colour quality is fine for the person receiving the call. I’m using Teams for iOS. So far I have reset my laptop, deleted and reinstalled the Teams app, signed out and back in multiple times and deleted my teams cache but it still isn’t working. It literally changed overnight so don’t know what has happened. The only way I can describe it, is as if someone has highlighted the screen when I’m in a video call…you know when you highlight a picture on a webpage and the colour goes hazy/grey. I even tried changing the theme from dark to light but in light mode it’s even more prominent. Any suggestions would be great- thanks! To add – all other apps, (WhatsApp, FaceTime) the brightness is fine when using the camera so it is isolated just to teams and only happens when my camera is on. Read More
How do I boot into Windows 1.01 from MS-DOS 3.30?
Hello! I am trying to boot Windows 1.01 but I don’t have autoexec and i forgot the command.
thanks,
birb
Hello! I am trying to boot Windows 1.01 but I don’t have autoexec and i forgot the command. thanks,birb Read More
Outlook 365 spell check prevents manual editing of errors
When creating a new email in the online version of outlook, spellcheck recently started blocking manual editing of misspelled words. For example, when typing “on”, I accidentally pressed the “p” key and typed “pon”, which corrects to “pun”, “pond” or “pony”. I used to be able to disregard the suggestions and just manually fix the word, but now selecting the word locks you into the popup bubble and typing does nothing. You need to select before or after the misspelled word and arrow key your way into the misspelled letter to correct. Turning off spellcheck entirely eliminates the full functionality and I don’t want that.
When creating a new email in the online version of outlook, spellcheck recently started blocking manual editing of misspelled words. For example, when typing “on”, I accidentally pressed the “p” key and typed “pon”, which corrects to “pun”, “pond” or “pony”. I used to be able to disregard the suggestions and just manually fix the word, but now selecting the word locks you into the popup bubble and typing does nothing. You need to select before or after the misspelled word and arrow key your way into the misspelled letter to correct. Turning off spellcheck entirely eliminates the full functionality and I don’t want that. Read More
Monitoring Microsoft Sentinel Reports with Dashboard Hub & Power BI
In this blog post, I will discuss the efficient monitoring of Microsoft Sentinel workbooks through Dashboard Hub and the creation of customized reports using Power BI.
Microsoft Sentinel provides a variety of pre-built workbooks that are crucial for visualizing data and enhancing operational efficiency. Given the numerous workbooks available in our content hub solution, organizing them into dashboards ensures that stakeholders can easily access data relevant to their specific interests.
At this point, I presume you have determined the workbooks you intend to save and identified which stakeholders require access to specific workbooks for their daily tasks.
Let’s delve into the solution.
You can “Pin” the workbook of your interest in a dashboard. These dashboards can be private or shared.
A private dashboard can be accessed only by you.
A shared dashboard is an Azure resource that is saved to a resource group. Role-based access control will determine who has access to the shared dashboard.
Let’s focus on a shared dashboard in our use case.
As you can see below, you can click on “Pin” and select a shared dashboard where you wish to pin the workbook. In case, the shared dashboard is not available then you can simply click on the “Create new” tab where you can create a new shared dashboard which will be hosted in a resource group.
In my case, I’ve a shared dashboard created already for SecOps monitoring.
To access the shared dashboard, you can browse to Dashboard hub > Shared Dashboard. You can pin several workbooks in a shared dashboard. It would make sense configuring Auto refresh interval as desired; since RBAC control determines who can access this dashboard you can define the permissions accordingly.
With this approach, you don’t need to browse to Microsoft Sentinel > Workbooks > Search for a workbook of your interest and then view the data. You can simply pin the relevant workbooks in your dashboard and view those workbooks directly from Dashboard hub.
Let’s take a look at another use case to create Power BI report from Microsoft Sentinel data.
Power BI report can be created with KQL logic. You can create a Power BI report on data from Microsoft Sentinel and share those reports with people who don’t have access to Microsoft Sentinel. I’m going to create a Power BI report for checking Syslog table data where I would be interested in the ProcessName column.
Prerequisites:
At least read access to a Microsoft Sentinel workspace.
A Power BI account that has read access to your Microsoft Sentinel workspace.
Power BI desktop app.
Detailed steps as follows:
Browse to Microsoft Sentinel > Logs
Write the KQL query as per your requirements and run it; in my case, it’s simple:
Syslog
| summarize count() by ProcessName
Click on Export > Power BI (as an M query).
Copy the content of the file.
Open Power BI desktop and login with user account having minimum read access to Microsoft Sentinel’s workspace.
In the Home section, click on “Blank report”
Click on Get Data > Blank query.
In the Power Query Editor, select Advanced Editor.
Remove the pre-written contents and paste the content from PowerBIQuery.txt file and click on Done.
You might get a prompt to authenticate; click on Edit credentials and sign-in.
Click on Close and Apply.
Now you can create visualization effects like table, pie chart and more from the visualization option. In my case, I’m using table and donut chart to visualize my data.
Click on Publish and select a workspace where you wish to publish the report. In my case, I’ve a custom workspace created for SOC Monitoring where I will publish the report.
After the report is successfully published, you can login to https://powerbi.com/ and select the workspace to find your report. You should be able to access the report.
To grant access to your workspace, select workspace and click on ellipsis symbol > Workspace access and grant access to people or group.
It’s recommended to schedule auto refresh of the report as well.
Browse to the workspace, select the report and click on ellipsis > Settings
Configure refresh schedule
Hope this blog would help you in effectively monitoring your data using Dashboard Hub & Power BI.
Reference Articles
Create new tile for your workbooks: https://learn.microsoft.com/en-us/azure/sentinel/monitor-your-data?tabs=azure-portal#create-new-tiles-for-your-workbooks
Create and share dashboards: Create and share dashboards of Azure Log Analytics data – Azure Monitor | Microsoft Learn
Create a Power BI report from Microsoft Sentinel data: Create a Power BI report from Microsoft Sentinel data | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
