Hi,

We have an online platform for our clients that currently stores data they input in Cosmos, in JSON format, including some nested JSONs.

For these clients, we also provide a variety of Power BI reports based on this Cosmos data. To retrieve and sometimes transform the data from Cosmos, we use Synapse T-SQL queries to create views from the Cosmos data, that Power BI can then link to.

All Synapse queries use the following to flatten the Cosmos data into a suitable format for Power BI:

– OPENROWSET – to access the data in a specific Cosmos container

– CROSS APPLY/OUTER APPLY – to access data stored in nested JSONs

– WHERE clause to reduce the amount of data stored in the final view that is accessed by Power BI

However, as a result, we encountering an issue with the amount of data processed each time a report is refreshed.

It appears that despite the WHERE clause, the OPENROWSET retrieves all of the data from the container before filtering the rows. For example, if the Cosmos container stores 16,000 rows which if queried would require 3GB of data to be processed by the query, even if we add a WHERE clause that reduces the final amount of rows to 1,000, 3GB of data are still processed by the query each time it is run.

Consequently, we are encountering scenarios where a Power BI report containing less than 100 rows of data are still processing massive amounts of data in the Synapse queries, incurring high costs. 

As we have multiple queries running multiple times per day, we are facing escalating costs, e.g. 

3GB per query x 15 queries x 5 refreshes per day = 225 GB data processed per day, when it should be significantly lower. This example is also conservative as it is based on test data rather than live, and it is after we have reduced the number of daily refreshes for our clients to reduce the costs.

As data is added to the container each month, the amount processed and the cost is only increasing.

Furthermore, this has led to situations where we have exceeded our Synapse capacity, causing the Power BI reports to be unable to refresh at all, preventing clients to be able to review their data.

Does anyone have any suggestions as to how we can limit the data being returned in the OPENROWSET clause so it does not process the whole Cosmos container’s worth of data when a query is run?

​Hi, We have an online platform for our clients that currently stores data they input in Cosmos, in JSON format, including some nested JSONs. For these clients, we also provide a variety of Power BI reports based on this Cosmos data. To retrieve and sometimes transform the data from Cosmos, we use Synapse T-SQL queries to create views from the Cosmos data, that Power BI can then link to. All Synapse queries use the following to flatten the Cosmos data into a suitable format for Power BI:- OPENROWSET – to access the data in a specific Cosmos container- CROSS APPLY/OUTER APPLY – to access data stored in nested JSONs- WHERE clause to reduce the amount of data stored in the final view that is accessed by Power BI However, as a result, we encountering an issue with the amount of data processed each time a report is refreshed. It appears that despite the WHERE clause, the OPENROWSET retrieves all of the data from the container before filtering the rows. For example, if the Cosmos container stores 16,000 rows which if queried would require 3GB of data to be processed by the query, even if we add a WHERE clause that reduces the final amount of rows to 1,000, 3GB of data are still processed by the query each time it is run. Consequently, we are encountering scenarios where a Power BI report containing less than 100 rows of data are still processing massive amounts of data in the Synapse queries, incurring high costs. As we have multiple queries running multiple times per day, we are facing escalating costs, e.g. 3GB per query x 15 queries x 5 refreshes per day = 225 GB data processed per day, when it should be significantly lower. This example is also conservative as it is based on test data rather than live, and it is after we have reduced the number of daily refreshes for our clients to reduce the costs. As data is added to the container each month, the amount processed and the cost is only increasing.Furthermore, this has led to situations where we have exceeded our Synapse capacity, causing the Power BI reports to be unable to refresh at all, preventing clients to be able to review their data. Does anyone have any suggestions as to how we can limit the data being returned in the OPENROWSET clause so it does not process the whole Cosmos container’s worth of data when a query is run?  Read More

​

Hello, I have an email account (Exchange online) that has several forwardings applied to it through a transport rule and when the email arrives in the mailbox, the original sender’s data does not appear in the header. This causes the antiphishing filters not to be applied. For example, if that account receives an email from Gmail, after applying the forwarding rules, the Gmail data does not appear in the header. I have read that this can be solved by configuring the Enhanced Filtering for Connectors in Microsoft Defender. The problem i have is that this option is applied to the inbound connectors and my email account does not go through any inbound connector. Does any to know if there is a solution to be able to keep the data of the original email in the header?

Thanks.

​Hello, I have an email account (Exchange online) that has several forwardings applied to it through a transport rule and when the email arrives in the mailbox, the original sender’s data does not appear in the header. This causes the antiphishing filters not to be applied. For example, if that account receives an email from Gmail, after applying the forwarding rules, the Gmail data does not appear in the header. I have read that this can be solved by configuring the Enhanced Filtering for Connectors in Microsoft Defender. The problem i have is that this option is applied to the inbound connectors and my email account does not go through any inbound connector. Does any to know if there is a solution to be able to keep the data of the original email in the header?Thanks.  Read More

​

Today’s guest post is from Lauren McCann from Figma Education

————————————————————————————

It’s back-to-school season, and we’re thrilled to announce our partnership with Figma to bring their professional-grade design and collaboration tools to Microsoft 365 schools! Administrators and school leaders can apply here to get started.

In today’s fast-paced world, skills like collaboration, creativity, and problem solving are more essential than ever. That’s why we’re offering free access to Figma and FigJam enterprise tiers for all K-12 educators and students within Microsoft schools. Figma and FigJam are design and collaboration software used by professional designers, engineers, and makers of all kinds. They can support students in building together—in a fun, interactive space that simultaneously prepares them for future career opportunities.

5 Creative Ways to Engage Students with FigJam

FigJam, Figma’s digital whiteboard tool, is a versatile tool for collaboration that can bring a fresh dynamic to classrooms. Its intuitive design, flexibility, and joyous features make it perfect for a wide range of activities across subjects. Teachers and students have access to sticky notes, stamps, pen tools, diagramming tools, stamps, and interactive multimedia to make learning fun, engaging, and collaborative.

Here are five creative ways teachers can use FigJam to engage students and foster learning:

Community building ‘Get to Know Me’ Activities

At the start of the school year or when forming new groups, use FigJam for to help students get to know one another. By using FigJam’s sticky notes or drawing tools, students can easily share their hobbies, favorite books, or fun facts in a more interactive way. This sets a positive classroom culture and helps create a sense of community right from the beginning.

Try out these templates:

All About Me activity
Let Me Introduce Myself Activity
Classmate Scavenger Hunt
Shoe Rack Icebreaker Activity

ELA/History Activities

For English Language Arts or History, FigJam is a great tool for dynamic graphic organizers, brainstorming, connecting ideas and themes, planning, and organizing thoughts. Students can collaboratively map out plotlines of novels, create character analysis boards, or even build timelines of historical events. Teachers can assign group projects where students organize key ideas from a text or debate historical perspectives, all while using FigJam’s collaborative features to capture their ideas in real time.

Try out these templates:

Dynamic Vocabulary List
Book Recap Activity
Classroom Debate Protocol
Student-led Book Review Cards
Story Arc Pre-Writing Planner
Book Chat Activity

Science and Math Activities

In STEM subjects, FigJam can be used for problem-solving, modeling, and visualizing complex concepts. For math, students can break down word problems by annotating them, using digital manipulatives, drawing diagrams, or collaborating on equations. In science, FigJam can be used for creating concept maps on topics like ecosystems or the periodic table. Teachers can also incorporate visual tools like flowcharts to show processes such as photosynthesis or the steps of a scientific experiment.

Try out these templates:

Base Ten Blocks
Scientic Method Flowchart
Virtual Lab Notebook
Math Card Game
Telling Time Activity

Classroom Connection and Brain Break Activities

Beyond academics, FigJam is perfect for fostering class spirit and creating bonding experiences. Teachers can organize quick games, icebreakers, or fun brainstorming sessions where students can contribute silly answers, vote on class nicknames, or design a collaborative mural. Activities like “Two Truths and a Lie” or classwide Pictionary are simple to set up and encourage participation, all while making learning fun.

Try out these templates:

Create Your Own Croc Charms
Friendship Bracelet Builder
Around the World Review Game
Choice Board Template
Pass the Doodle
Play a Game of Battleship

Check for Understanding Activities

FigJam’s collaborative board allows teachers to perform informal assessments in real-time. Use it for “exit tickets” where students post one thing they learned, or use the space for quick quizzes and polls to gauge understanding. This approach encourages participation and provides immediate feedback on student comprehension, helping teachers identify areas that need further clarification.

Try out these templates:

Bumper Sticker Exit Ticket
Text Me Your Takeaway Exit Ticket
Tweet Me Your Takeaway Exit Ticket
Inverted Pyramind Exit Ticket
Exit Ticket Bundle
Assignment Self Reflection

By incorporating FigJam into everyday classroom activities, teachers can make learning more interactive, engaging, collaborative, and fun for students across all subjects. Whether it’s for academic purposes or simply to build classroom community, FigJam’s versatile features provide endless possibilities for creative engagement.

5 Creative Figma Design Activities for Students

Figma is a powerful design tool that’s not only great for professional work but also for classroom activities that build both creative and technical skills. Teams across industries use Figma to create user interfaces and user experiences for websites, apps, and digital products. Figma provides tools to create wireframes, prototypes, and high-fidelity designs.

Here are five fun ways to use Figma to engage students while helping them develop future-ready skills and design literacy.

**Student Trading Cards**

Kick off the first week of class with an activity that combines getting to know your classmates with learning Figma basics. Have students create digital trading cards that mimic a social media-style profile. Using Figma’s Auto Layout and components, students can design profiles that showcase their interests, hobbies, and fun facts. By working in the same file, students get a sneak peek into each other’s design processes and styles. You can even set up a gallery to review each other’s work at the end!

Figma skill level: Beginner

Key Figma features: Auto Layout, Multiplayer Editing

Duplicate the file

Make a Heart

This activity is perfect for building confidence with Figma’s tools. Ask students to create a heart using the pen tool, layout grid, and various properties, then challenge them to customize it. It’s a quick way to introduce key Figma features that will come in handy for future design projects.

For a fun twist, students can animate the heart using Figma’s Smart Animate feature to make it pulse. This activity not only helps students get comfortable with design tools but also introduces them to animation and motion design basics.

Figma skill level: Beginner

Key Figma features: Pen Tool, Properties Panel, Layout Grid

Duplicate the file

Figma Tangrams

Using the classic tangram puzzle, students can explore form, geometry, and creativity in Figma. After a brief lesson on the history of tangrams, have students arrange the seven traditional pieces into recognizable animals or other shapes.

Encourage them to experiment by creating abstract designs as well. For an extra challenge, students can design their own reusable tangram sets by researching other tangram puzzles, pushing their creativity and research skills.

Figma skill level: Beginner

Key Figma features: Components, how to rotate and align

Duplicate the file

Loading Animations

This activity taps into a familiar experience: waiting for a page to load. Ask students to reflect on their favorite (and least favorite) loading animations and then design their own. This exercise gets them thinking about how to visually represent waiting or processing within an interactive app. It’s a great introduction to more conceptual and technical work in interaction design.

Whether it’s a simple spinning icon or a more elaborate animation, students can get creative and dive into the user experience aspect of design.

Figma skill level: Intermediate

Key Figma features: Prototyping, Smart Animate

Duplicate the file

Mobile Magazine Prototype

For this lesson, students create a simple mobile layout for a magazine, combining layout and prototyping to design an interactive experience. After laying out the gallery of magazine content, they can prototype navigation to simulate how users would flip through the pages.

Figma skill level: Intermediate

Key Figma features: Layout Grids, Prototyping

Duplicate the file

These activities let students jump into the role of UX designer and realtor. Each project not only teaches students key design skills in Figma but also spark creativity and collaboration. Whether it’s creating custom trading cards or designing interactive prototypes, students will walk away with practical skills and a deeper understanding of the design process.

Lauren McCann

Head of Figma Education

​Microsoft Tech Community – Latest Blogs –Read More 

we are implementing a solution to manage an users group for each country assigned to its helpdesk group.

the idea is:

USA helpdesk group can manage USA users

FR helpdesk group can manage FR users

and so on

we created “USA helpdesk” group (with some member) and “USA users” group with dynamic group.

we need to match HelpDesk role, “USA helpdesk” group and “USA users” group

how can we do it?

​we are implementing a solution to manage an users group for each country assigned to its helpdesk group.the idea is:USA helpdesk group can manage USA usersFR helpdesk group can manage FR usersand so onwe created “USA helpdesk” group (with some member) and “USA users” group with dynamic group.we need to match HelpDesk role, “USA helpdesk” group and “USA users” grouphow can we do it?  Read More

​

Hello Marketplace community,

Trust this message finds you. I tried to create a service offer. Just a quick one. Is that statement correct: “Professional services must be sold using a US, UK, or Canadian seller ID. To understand which market your seller ID is configured in”? 

If not could you please support as I can create a “professional service” as new offer, I do not have the option available actually located in the EU.

Thanks and best 

​Hello Marketplace community, Trust this message finds you. I tried to create a service offer. Just a quick one. Is that statement correct: “Professional services must be sold using a US, UK, or Canadian seller ID. To understand which market your seller ID is configured in”? If not could you please support as I can create a “professional service” as new offer, I do not have the option available actually located in the EU. Thanks and best   Read More

​

Can any one suggest me how should i improve c# advanced topics and sql advanced topics?

​Can any one suggest me how should i improve c# advanced topics and sql advanced topics?   Read More

​

I use Outlook to receive encrypted emails that are protected by a certificate stored on my smartcard. When opening these emails, a Windows Security prompt appears, asking me to enter the PIN for my smartcard to decrypt the message. Once the PIN is entered, I can access the email contents.

I’m looking for a way to automatically trigger the PIN entry dialog via code so that the user is prompted to enter the PIN without manually clicking on the encrypted email. The user will still need to insert their smartcard and manually enter the PIN, but I want the dialog itself to be initiated programmatically.

I would prefer to implement this solution in PowerShell, an Outlook macro (VBA), or Delphi. However, I encountered an issue: when attempting to display the email using MailItem.Display(True), the PIN dialog does not appear. Instead, the following error message is shown: “The name of your digital ID could not be found by the underlying security system.”

Has anyone experienced this or have suggestions on how to automate the process while keeping the PIN entry manual and secure?

Thank you in advance for your help!

​I use Outlook to receive encrypted emails that are protected by a certificate stored on my smartcard. When opening these emails, a Windows Security prompt appears, asking me to enter the PIN for my smartcard to decrypt the message. Once the PIN is entered, I can access the email contents. I’m looking for a way to automatically trigger the PIN entry dialog via code so that the user is prompted to enter the PIN without manually clicking on the encrypted email. The user will still need to insert their smartcard and manually enter the PIN, but I want the dialog itself to be initiated programmatically. I would prefer to implement this solution in PowerShell, an Outlook macro (VBA), or Delphi. However, I encountered an issue: when attempting to display the email using MailItem.Display(True), the PIN dialog does not appear. Instead, the following error message is shown: “The name of your digital ID could not be found by the underlying security system.” Has anyone experienced this or have suggestions on how to automate the process while keeping the PIN entry manual and secure? Thank you in advance for your help!   Read More

​

Symptoms: 

For your master database you might find different configuration such as Backup Storage Redundancy configured to be Local or Geo

As this is not configurable property you might ask why is my database configured with this value. 

Resolution: 

For master database on Azure SQL Database Server, Microsoft is managing this database as part of the server entity. 

as you cannot change the SLO level (which might be system or system2) for the master database there are other properties that cannot be configured from customer end. 

Note that master database is part of the server entity and should not store user data, therefore the only use of master database is to operate the server object. 

Backup redundancy is displayed as this is one of the properties shown for database object, however this is irrelevant for master database.

in any case, Microsoft implement mechanisms to keep this database highly available and secure for your database server. 

​Microsoft Tech Community – Latest Blogs –Read More