Month: October 2021

ADD A POWER BI REPORT TO SHAREPOINT ONLINE

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.

Azure DEVOPS Pipeline Incident in .NET 6 Migrations

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!

.net 6 .net 6 preview Azure DevOps build deploy incident release

OFFICE INSIDER – WHAT HAPPENED IN SEPTEMBER?

NEW FEATURES/FIXES

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.

Learn more

Notable Fixes

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.

Learn more

Excel

Notable fix

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. 👍🏻

file trickster microsoft 365 office insider Office365

USING TOOLTIPS IN POWER BI

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.

tooltips

Now our Tooltips are ready for use.

See you again, have a nice day!

POWERPOINT PEN AND LASER POINTER FEATURES

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.

What’s New In Excel 2021

What Is New In Excel 2021

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.

LEARN MORE or WATCH THE VIDEO

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.

LEARN MORE

Note: Modern comments is not available in Excel LTSC 2021.

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.

People icons, When others are co-authoring, they'll show up here — 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.

Word, Excel, and PowerPoint displayed with visual updates in ribbon and rounded corners to match Windows 11 user interface. — 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.

LEARN MORE or WATCH THE VIDEO

LET function

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.

LEARN MORE or WATCH THE VIDEO

Dynamic arrays

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.

LEARN MORE

XMATCH function

The XMATCH function searches for a specified item in an array or range of cells, and then returns the item’s relative position.

You can also use XMATCH to return a value in an array.

LEARN MORE

Sheet views

Create customized views in an Excel worksheet without disrupting others.

LEARN MORE

Note: Sheet views are not available in Excel LTSC 2021.

The New button in the Sheet Views group — PAGE VIEWS

A new way to reach the Accessibility tools

The Accessibility ribbon puts all the tools you need to create accessible content in one place.

LEARN MORE

Note: The Accessibility ribbon is not available in Excel LTSC 2021.

Shows accessibility excel 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.

Performance improvements

Experience improved performance, stability, and speed across Excel.

Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.

Unhide many sheets at the same time

No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.

LEARN MORE

Unhide many sheets at the same time — VISIBLE

See what’s new in stock media

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.

LEARN MORE or WATCH THE VIDEO

Find what you need with Microsoft Search

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.

LEARN MORE

or WATCH THE VIDEO

Save your changes as they happen

Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.

LEARN MORE OR WATCH THE VIDEO

Support for OpenDocument format (ODF) 1.3

We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.

LEARN MORE

Updated Draw tab

Quickly access and change the color of all your inking tools, all in one place.

Simplify how you work with ink using new Draw tab additions: Point Eraser, Ruler, and Lasso.

LEARN MORE

Get a quick summary of what’s in your workbook

Wondering how big your worksheet or workbook is getting? Excel provides workbook statistics to help you.

LEARN MORE

The Workbook Statistics command on the Excel ribbon — STATISTICS

Pick the perfect color

Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. No need to convert Hex color values into RGB values.

For any property where you can define a color, you can now enter a Hex color value in the Hex box, for example, #0F4C81 or 444.

Try the Sketched style outline

You can give a casual, hand-drawn look to shapes in your workbook with the Sketched style outline.

Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched style.

LEARN MORE

excel 2021 filetrickster microsoft 365 office insider