I would like to talk about a feature of Excel that was made available for the web in December last year. I hope that this feature becomes available for the desktop version as soon as possible and we can work faster in dynamic actions. But until then, we can use the drop-down lists in Excel, just like search boxes on websites or selectable dropdowns. Since this will be like bringing the web experience to the desktop, it will be cute feature that is pleasing for the eye.
MAKE YOUR DATA UNIQUE EFFORTLESSLY
With this feature, even if the data you will have in your data validation list is duplicate data in the field when you select, you will get to make them unique and create your. You will not need to use any extra dynamic array formulas (UNIQUE).
Let’s see how it works with an example.
Let’s say that we have a sales table like the one below, and we would like to have a drop-down list in cell J1 and a list of unique values in the Product Name (Ürün Ad)field. This new feature allows us to both obtain a list of unique Product Names and to select a desired data by making a search in that list.
.Row-level security (RLS) with Power BI is used to ensure that the report users we have determined see the data they see on the report screen with the conditions and restrictions we have created. It is necessary to assign roles after creating these restrictions in Power BI Desktop. For example, in the data we have in Power BI, we can say that these people should see the people whose country is Turkey, and those people should see the people whose country is Germany. Users in a workspace in the Power BI service can access datasets in that workspace. Us creating an RLS for a report will not restrict this access in any way.
Now that we have given some basic information, let’s dive into the details and try it out together!
.
.
.
.
.
.
CREATING AND DEFINING ROLES IN POWER BI DESKTOP
First thing first, let’s open our Power BI report and create a report that will have the users we have determined see the data whose city is Berlin.
We will use the Manage Roles option in the Modeling tab.
.
We will use the Create button to create a new role.
Once we use the Create button, it is time to select the table and field we will be filtering. Here, I will use the City field in the DimGeography table.
.
Now we can restrict the ones whose city is Berlin.
After creating our role, we will use the View As option in the Modeling tab to see how our role looks.
We can see all the roles we have created in this screen. Let’s select Berlin and see how this role looks.
We see that all the report Data consists of the city of Berlin.
.
.Now, we will assign users to the roles we have created. Let’s go to the security settings through the dataset that has our report in Power BI web.
Here, we can write the e-mail address of the relative user into the role we have created and that is called Berlin.
Now we know how to restrict our report data to the users we want with Row Level Security!
Don’t forget to take a look at our blog.
See you later, have a great day!
You can easily and interactively add your Power BI reports to SharePoint only using the Power BI report section of SharePoint Online. When using the “Add to SharePoint Online” option, the attached report complies with all project permissions and data security through row-level security (RLS), so you can easily create a secure internal portal.
Now ,with the last update released by the Power BI team, the action bar of Power BI reports are also included in SharePoint. Let’s see and analyze it together!
WHAT IS SHAREPOINT?
The SharePoint application is a data storage system developed by Microsoft. The system prevents data loss by enabling companies to copy their documents to cloud records. Microsoft Sharepoint makes data transfer between programs easier by collecting all documents prepared by Microsoft under a single roof. The SharePoint application supports the integration and transfer of data between all applications (such as OneDrive for Business and Microsoft Office). Also, its licensing is the same as the Microsoft Office application.
WHAT DOES SHAREPOINT DO?
You can use SharePoint to speed up document conversion in your workflow. Documents created and saved in Microsoft systems can be easily managed through SharePoint. The SharePoint application is used to make document management and data management easier by providing all data flows between Microsoft applications, document management, information transfer between systems, search options between archives, and various Excel services. When any change is made to the saved document, the data owner gets informed. SharePoint enables documents and information to be controlled with high-level security measures. It also enables the documents to be used together and to be easily accessed in all studies.
ADDING A POWER BI REPORT TO THE SHAREPOINT ONLINE PAGE
1. Go to Pages -> New -> Site Page to create a new site page in Sharepoint Online.
2. Click the button shown with (+) and choose the Microsoft Power BI add-in.
3. Select the Microsoft Power BI add-in.
4. Use the “Add Report” button to add our report to the SharePoint Online service.
5. On the right of the screen, we need to give the link address of the Power BI report that we want to add. Now, go to the Power BI Web service and copy the link address of the report we want to add. Today, I will use a sample report offered by the Power BI team.
6. Open the report on the Power BI Web service and copy the link address.
7. Paste the link address of the report into the Power BI report link box on the right. When you complete the process, you will see that the report you wanted to use is already on SharePoint Online. You can click ‘Publish’ to embed the report in SharePoint Online.
Now your report is on the SharePoint Online Service.
THE ACTION BAR OF THE POWER BI REPORTS IS NOW ON SHAREPOINT ONLINE!
Power BI has now included the action bar of the Power BI reports that we add to the SharePoint Online section with its brand new update. We can now use many features such as export, share, bookmarks that we have made in the report in the Power BI web service.
Microsoft has been releasing .NET 6 improvements and SDKs one after another for a long time. We have been following these imrpovements closely in PEAKUP’s Velocity, Analytics and Data products for a long time. We take into account the performance-enhancing features in the latest SDKs and give a lot of importance to migrating projects to the latest version of .NET 6, . After the each Preview SDKthat has been released recently, we started to experience some glitches and outages in the DevOps pipeline. Today I’m going to tell you how we came across this little DevOps outage and how to fix it.
While developing our applications with .NET 6, we get them to work by hosting them in Azure Web Application. The expectation we have here is for the related SDK to be setup and be ready on the Web Application side after each SDK gets released, just like the SDK Container packages that are immediately reflected in the Microsoft Container Registry services.
However, the migrations of the Azure teams in the Microsoft 6.0.100-preview.7.21379.14 and 6.0.1-RC packages are quite surprising! Because, although a behavior that we specifically specified to use the latest version of 6 during the Build phase that we have built in DevOps Pipeline does not cause any errors in the Build and Release Pipeline, let us tell you that a very surprising problem awaits you once it is deployed to the application!
There is no RC package of .NET 6 in Azure Web Application! When you look at the DOTNET SDK list on Kudu SCM, you can see that the RC package is missing and the application tries to run for minutes without sending any Exceptions.
In order to solve this problem, it will be enough to specify the latest SDK version in the Azure Web Application specifically in the Pipeline!
You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻 Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of September.
September 2021
September 24, 2021 , Version 2110 (Build 14517.20000)
Word
Notable fixes
We fixed an issue where changes failed to sync and progress was lost in both the synced file and the locally backed up file.
We fixed an issue where Word would become slow to respond while using a high CPU percentage.
We fixed an issue where AutoCorrect was not working in Modern Comments.
Excel
Notable fixes
We fixed an issue where the error ERROR_DISK_FULL would appear before maintenance would begin.
We fixed an issue where Excel’s enclosed numeric characters showed as question marks.
Project
Notable fix
We fixed an issue where the beforetaskchange event would fire twice and included incorrect information when the predecessors field changed.
Outlook
Notable fixes
We fixed an issue where the sensitivity tab was disabled in the frame-control window for some users.
We fixed an issue where search did not include items from an online archive mailbox.
Office Suite
Notable fix
We fixed an issue where a user can’t open an .xls/.ppt/.doc file in a folder that was synced from a SharePoint folder with read permission.
September 17, 2021 , Version 2110 (Build 14509.20000)
Word, Excel, PowerPoint
Apply default sensitivity labels when modifying existing files
Up until now, default sensitivity labels, configured by your administrator, were automatically applied when a file was created. Now, labels are applied whenever a document, worksheet, or presentation is either created or modified. Note that you can select a different label if one better matches the sensitivity of a given file.
Word
Notable fixes
We fixed an issue that negatively impacted the typing speed in a document when an animated GIF is playing.
We fixed an issue that caused the Save indicator to stop responding.
Excel
Notable fix
We fixed an issue that caused an insufficient memory warning to appear when copying and pasting content.
PowerPoint
Notable fix
We fixed an issue where ink would not be displayed when a PowerPoint slide was pasted in another program.
Outlook
Notable fix
We fixed an issue that negatively impacted the typing speed in a document when an animated GIF is playing.
Project
Notable fix
We fixed an issue that caused the Visual Basic Applications (VBA) OrganizerMoveItem method that is used to move custom field information from one project to another to not work properly when the Name parameter is omitted.
September 10, 2021 , Version 2110 (Build 14503.20002)
Outlook
Use your voice to send email and @mention people
In our increasingly busy world, dictating your emails in Outlook has become a very popular way to improve your efficiency. We’ve now made this feature even more powerful by adding specific voice commands, enabling you to add people to an email, mention (@name) someone in a message, and send the mail—all using only your voice. To use this feature, click the Dictate button on the Message tab for an email. Then dictate your message and try out a voice command, such as “add [name] to email” or “at mention [name],” and observe the results.
We fixed an issue where double-clicking to save an untrusted attachment would fail to save to network locations.
We fixed an issue where messages created via Send To do not get default sensitivity labels.
Word, Excel, PowerPoint
Data Loss Prevention policy tips
Additional sensitive information types configured as part of OneDrive and SharePoint data loss prevention (DLP) policies can now be detected by the app to show a policy tip. This update also brings accuracy improvements and globalization support.
We fixed an issue where automatic sensitivity labeling was not working for a few GCC-H tenants.
PowerPoint
Notable fix
We fixed an issue where using auto-save saved the file in an unexpected location; requests to save to a shared location were saved locally without notification.
Project
Notable fix
We fixed an issue where, if the decimal separator isn’t a period, enterprise resources can’t be saved when an enterprise number custom field is updated.
Office Suite
Notable fix
We fixed an issue where the ampersand character was incorrectly shown as an underline in the data types card.
September 3, 2021 , Version 2109 (Build 14430.20030)
Office Suite
Notable fix
We fixed an issue where, during the uploading of a file, the application stopped responding and the document was not syncing.
Access
Notable fix
We fixed an issue where special characters were included in error messages.
Excel
Notable fixes
We fixed a rendering issue in worksheets with Freeze Panes enabled for certain scrolling scenarios.
We fixed an issue where localized characters appeared lower than English characters in the sheet tabs.
We fixed an issue where the Find/Replace dialog only saved history for Find and not Replace (the dialog was not saving the history of what was replaced when Replace occurred).
Outlook
Notable fixes
We fixed an issue where Read Aloud neural voice regression stopped responding.
We fixed an issue that caused Room Finder to fail to load.
We fixed an issue that caused reminders to intermittently display late and show the wrong time in the dialog.
PowerPoint
Notable fix
We fixed an issue where the slide size can change during print preview.
Project
Notable fix
We fixed an issue where, when programmatically adding new tasks to a project, the tasks may not be inserted at the correct location if the new task’s summary task is collapsed.
Word
Notable fixes
We fixed an issue where Read Aloud neural voice regression stopped responding.
We fixed an issue related to crashes when calling DCompositionCreateDevice.
We fixed an issue where typing Hiragana with the Japanese input method editor (IME), with the At Mention people picker open, caused the IME to stop working.
We compiled all the new features and fixes in September in Office insider. Hope to see you in our other articles, bye bye. 🙋🏻♂️You can share this article with your friends and family to help them get information about Office insider updates released in the month of September. 👍🏻
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
Note: Some features listed below are not included in Excel LTSC 2021 for commercial customers. Each of those features is noted if it does not apply to Excel LTSC 2021 for commercial customers.
Co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other’s changes quickly — in a matter of seconds.
Note: Co-authoring is not available in Excel LTSC 2021.
Better collaboration with modern comments
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
Note: Modern comments is not available in Excel LTSC 2021.
MODERN COMMENT
Know who’s in your workbook
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021.
WHO’S?
Visual refresh
Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.
Note: Visual refresh is not available in Excel LTSC 2021.
NEW STYLE
Look left, look right… XLOOKUP is here!
Row by row, find anything you need in a table or range with XLOOKUP.
Return exact matches by default—there’s no need to specify.
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
Write one formula and return an array of values. Expedite calculations and insights with six
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
Note: The Accessibility ribbon is not available in Excel LTSC 2021.
ACCESSIBILITY
Increase the reach of your content
Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.
ACCESSIBILITY
Performance improvements
Experience improved performance, stability, and speed across Excel.
Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
SUMIF, COUNTIF, AVERAGEIF
Unhide many sheets at the same time
No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
We’re constantly adding more rich media content to the Office Premium Creative Content collection that helps you express yourself, such as a curated library of stock images, icons, and more.
At the top of your Microsoft Office apps on Windows, you’ll find the new Microsoft Search box. This powerful tool helps you quickly find what you’re looking for, such as text, commands, help, and more.
Have You Tried the Pen and Laser Pointer Features of PowerPoint?
When you run a presentation you prepared in PowerPoint in the display mode, you can mark the slides with a pen and write anywhere on the slide. For example, if there is a graphic on the screen, you can mark some parts of it with a pen or write notes while talking about it. In addition, if you do not have a laser pointer device that you can use to draw attention to the important parts during the presentation, you can do this with the Laser Pointer feature that PowerPoint offers.
But, how do we do all this? Let’s take one step at a time and see how it is all done.
1) While the presentation is in the display mode, click right anywhere on the presentation.
2) In the menu that opens, hover over the Pointer Options with the mouse.
3) You will see that the sub-options that will open include the following options.
Laser Pointer
: When you select this option, the mouse icon will turn into a laser pointer icon and you will be able to use the mouse like a laser pointer.
Pen: When you select this option, the mouse icon will turn into a pen, and you will be able to use the mouse like a pen. It will be enough to press the E key on the keyboard to delete the drawings you have made and the texts you have written with the pen.
Highlighter: When you select this option, the mouse icon will still act as a pen. But unlike the first pen option, this option works like a highlighter. You can color and highlight any text on the slide with this pen. The images and text behind the drawings made with the highlighter continue to appear. The only difference is for them to be also highlighted with a color.
Ink Color: You can use the color palette here to change the color of the pen and highlighter.
You cannot change the laser pointer color here. If you also want to change the color of the laser pointer, you can use the Laser Pointer Color option in the Slide Show menu >> Set up Slide Show.
.
You can see some applied examples in the picture down below. The red tick marks in the picture are made with the pen, and the colors on the Velocity and Nova texts are done with the highlighter. You can also see the laser pointer icon on the Velocity image.
Using the report page you have created in Power BI Desktop as a base, you can create visually rich report tooltips that will be shown while hovering on them. When you create a report page that will be used as tooltips, your exclusive tooltips can contain the visuals, tables, and all the other element collections you have created on the report page.
Shall we try this together now? Let’s go!
CREATING THE TOOLTIP PAGE
First, let’s create a new page. Click on the (+) sign that is on the right to create a new page. I created a new page with the name of Tooltip.
In order to set the new page we have created as the Tooltip page, select the size page as tooltip from the tab that you can find on the right. Here we can also select the normal page size, but keep in mind that the tooltips are located on the report canvas so it is important to keep them as short as possible.
You can name the tooltip page you have created in a way that indicates your goal. It is enough to select the Page Information card in the Style section and write the name you want into the Name field.
Now, let’s design the tooltip page the way we want. I will be designing a tooltip with the size of a normal page.
.
.
CONFIGURING THE TOOLTIP PAGE
After creating a tooltip report page, the page will be saved as a tooltip for Power BI Desktop. It is necessary to set the correct visual on it. First, we need to open the tooltip slider on the page information card in order to turn the page into a tooltip.
Any visual element that supports report tooltips now has a tooltip card in the style section. In order to set a tooltip, select the visual you want. And then go to the “Style” section of “Visualization” and expand the “Tooltip” card. After activating the tooltip slider, select the Tooltip page you have created as the report page.
Do you use a stock report and are you in constant need of renewing the report and keeping up with it in order to not go stock out? Do you want to receive a notification immediately when one of the IOT devices you follow with Power BI reports get too hot? Then it is safe to say that data alert is your jam!
Data alerts is a feature exclusive to the cards on the Power BI dashboards. The values are checked for being over or below a certain level and if the limit is exceeded, then the person who created the data alert gets notified by Power BI regarding the situation.
Now, let’s take a look at how we can create one.
1- Pin the card to the dashboard
First thing first, we need to pin the card on the relevant report to the dashboard. As you know, we can make this card be shown on the dashboard we want by clicking the pin icon on the upper right of the cards.
2 – Click “Manage Alerts”
Once we pin the card on our report to the dashboard, we will go to the relevant dashboard and click the ellipsis icon on the upper right of our card. Here, we choose the “Manage alerts” option.
3- Determine the Conditions for Data Alert
Now, we enter the information regarding the data alerts in the window that pops up on the right of the page. The title of the alert, our condition, if it will be over or below a certain value and that will this value be… You need to enter this value manually. Then, we will choose the frequency of this alert. And since we want to get an e-mail about the subject, we leave the mail option checked. Then, we “Save and Close”. This way, we get to complete the action.
From now on, once all the data is updated an evaluation with the comparison to the determined value will be executed. And we will receive a notification when it is necessary. Here is an example of one of the e-mails:
Depending on the urgency of the situation, it is also possible to design different flows for when the e-mail arrives. We will talk about this in our other articles. You can take a look at the other articles here.
Hi there dear readers! Today, we will talk about Microsoft’s Power Automate (formerly called Flow). Power Automate is a member of Microsoft’s Power Platform family, and allows you to automate your business processes and design them with as little code as possible. It integrates with nearly 300 connectors and handles your work automatically without the need to visit multiple sites or run multiple programs. To begin with, I recommend reading this article and then looking at the templates on Power Automate’s site. These are ready-made templates that you can get started with right away. Here I leave a few of them for you to review:
One of the best parts of Power Automate is that you can perform a variety of business processes in the simplest level possible, even without having the tiniest idea of how to code. Of course, every now and then you will need formulas here as well when appropriate, And for that kind of situations, Power Automate has its own formulas. Many of these formulas, referred to as “Expressions”, are similar to those of Excel.
FUNDAMENTAL COMPONENTS
Flows have 2 main components:
Trigger
Action
The main question when it comes to the trigger title would be “What will be required to happen for this flow to run?”
The titles like:
When an e-mail is received,
At 10 o’clock every day,
When a new task is created,
When a new line is added to the Sharepoint list,
When a button (Power Automate button, Power Apps button, Power BI button) is pushed,
etc. are all triggers. A flow doesn’t work without a trigger.
The main question when it comes to the action title would be “Which actions will be executed once this flow starts running?”
Here, we will select the actions we want to execute and connect them one after the other.
Send an e-mail.
Create a task.
Send a message on Teams.
Add a new record to the Sharepoint list.
Create a new file on Sharepoint.
etc. are all actions.
As a matter of fact, most of our business processes depend on various conditions and approvals. For example, you will save the files to a folder, but your administrator must approve these files first. Here the process gets a little more complicated and you have to apply various conditions to the processes as well. Since these situations are quite normal, Power Automate also has a solution for this situation: Flows can be designed to create special reactions to the results of certain conditions by selecting conditions as an action and working according to these conditions.
Everything goes step-by-step in the Power Automate flow. Thus, one of the main points to know here is that when you add an action, you can use the outputs of the actions or triggers from the previous steps. In the Dynamic Content area, Power Automate already shows you what and which titles you can use.
Below you can see an image of a conditional process.
The steps here are as follows:
We have created a survey, and we want this flow to be triggered when a new answer comes in.
We get the details of the answer that caused the trigger.
In the survey, we’ve got the question of: “Did you like our event?”. We will execute 2 different actions depending on the answer to this question. For this very reason, we add a condition.
We choose the title to which we will apply the condition: “Did you like our event?”. We want it to check if the answer here is equal to 5. 5 is the highest value.
If it is equal to 5, then we send an e-mail to the sender saying “Thanks”.
You can click here to check out our other articles about Power Automate. And if you ever have a question, feel free to let us know. See you in other articles.
Skip to content
There is no RC package of .NET 6 in Azure Web Application! When you look at the DOTNET SDK list on Kudu SCM, you can see that the RC package is missing and the application tries to run for minutes without sending any Exceptions.
