WE ARE IN THE IT 500 LIST ONCE AGAIN!

The results of the “Top 500 IT Companies Survey”, the only comprehensive survey in the field of IT in Turkey, have been announced.

The results of “Turkey’s Top 500 IT Companies Research”, which is highly anticipated by the IT world and includes companies that develop the technologies of the sector and produce solutions, have been announced. Organized for the 23rd time this year with the “Our Motto is Sustainability!” motto , the IT 500 Survey has come to the forefront as the most effective marketplace for both entrepreneurs and investors.

As PEAKUP, we are once again pleased to be included in the IT 500 list, which lists Turkey’s most valuable brands in the field of IT, just like we are every year.

WE HAVE SET OUR LNCH 23 TARGETS

As PEAKUP, we  started the new year all ready and we determined our strategies and targets at the LNCH event we had in the Sapanca NG Hotel.

On the first day of LNCH 23′, we set our targets and evaluated the whole year. PEAKUP members relieved the tiredness of the day in the pool and enjoyed the Disco at the end of the night.

On the second day, Ali İhsan Varol was the guest of our contest and then we gave our prizes. With two full days of LNCH 23, everyone started the year all ready for what is about to come.

Microsoft Teams Phone System: Voice Services and Telecommunications Connection

Before diving into the technical details about Microsoft Teams Phone System: Voice Services and Telecommunications Connection, I highly recommend you to read my article “Business Leader of Modern Communications: Microsoft Teams Phone.”

Teams allows users to communicate from mobile devices, computers, desk phones, or any IP phone compatible with the Teams application, as if they had a sim card. Microsoft has been creating products for cloud services that will work in harmony with modern business life for many years.

Once they have realized that the Teams platform meets all their collaboration needs, SMEs and large-scale businesses started to use Teams as the platform to carry out the voice service of their telephone, voice provider or existing operators. Teams Phone System is hosted on Microsoft’s secure cloud. And this means that you can get a reliable service and an excellent sound quality by Microsoft.

Increase Employee Productivity with In-Platform Calls!

Having a good communication is the keystone of any productive team. And Teams is designed to let your employees do exactly that. Features like online meetings, instant messaging, and screen sharing further encourage interaction. Everything gets taken care of and done within Teams. When you think about all the time you save with these, you create an efficient and digital work environment that has fewer distractions.

Flexibility – Keep Having Your Calls With Your Existing Phone Number From Anywhere In The World With No Additional Charges!

With Teams, your employees working remotely can access your company’s phone system instantly. This means you don’t need to find any workarounds for remote or hybrid work environments. Connect your existing phone system or newly installed Teams Phone services to the Microsoft Worldwide network and harness the power of the Microsoft cloud wherever your business goes.

“With your +905416996… phone number assigned to Turkey, you can continue to make calls and use all voice features without paying any additional costs while you are abroad for a business trip or when you are anywhere in the world. Regardless of the area code, you can transfer all your phone numbers to Teams with PEAKUP TECHNOLOGY’s Teams Audio Solutions today! This means that all branches of your company around the world can receive the same quality of service.”

Quality of Service – Maximum Sound Quality and End-to-End Security!

Teams uses Microsoft’s Azure cloud technology to transmit data. Given that Azure is an ultra-fast network all over the globe, you get to have connections with maximum stability. Audio gets to be transmitted as requested and both parties can communicate clearly as if they were in the same room. During an end-to-end encrypted call, Teams preserves its features like audio, video and screen sharing.

Affordable Prices and Low Costs!

Teams Phone System has opened a new door in telecommunications by providing a very affordable cloud service when compared to the costs of telephone bills and hardware telephone switchboard needs.

Relieve the Workload of your Information Technologies Team!

Increase the control and working efficiency of your IT employees at the maximum level with many end-to-end configuration features, including detailed reports, calls, collaborations, and messaging -and you can access them all within Teams Management Center.

Phone System Service Features and More!

You will not be giving up on anything by switching from the on-premises phone system to Microsoft Teams. In fact, you get to have more features that a landline system does not have. Click here to see the details.

Join Your Teams Meetings by Just Calling Without Needing Internet Connection with the Audio Conference Feature!

The Audio Conference feature allows you to participate in meetings by calling directly without the need for an internet connection. Set a phone number for Audio Conferencing and keep attending your meetings anywhere and everywhere -even if you have limited internet connection!

Use Teams as a PBX or combine your existing PBX into Teams Phone System with the Need of Extra Hardware!

With Teams Phone System, you can now move your existing PBX (physically located business phone server/switchboard in companies) to Microsoft’s Cloud World or enjoy making phone calls directly over the cloud without needing any hardware.

You can get in touch with PEAKUP Technologies here to meet the complete voice services solution in the cloud and make a smooth transition to the Teams Phone System! We accompany you in your digital transformation journey with our Microsoft 365 and Teams certified experts.

Teams Phone Audio Services requires the following Microsoft Licenses:

  • E1 or E3 or E5 license.
  • Users with E1 or E3 licenses must also purchase the Phone System add-on. (It comes free with the E5. For your E5 License users, it’s almost free to switch to Teams Phone!)

For pricing of licenses, you can get in touch with PEAKUP Technologies here!

To use Teams Phone Audio Services, you can choose from the following services:

  • Direct Routing via PEAKUP TECHNOLOGY —–> Go to article (coming soon)
  • Operator Connect via PEAKUP TECHNOLOGY —–> Go to article (coming soon)
  • Calling Plan (Not Available in Turkey) —–> Go to article (coming soon)

To expand your phone calls from inside your company to the world outside, aka PSTN (Worldwide telephone network), you need to connect to a PBX (Business phone server/switchboard physically located in companies) or SBC (special devices that control, protect and regulate the flow of voice, video and messaging over IP). Microsoft Teams Phone offers Voice Services with the 3 separate services above.

Even if you have a physical business phone server, i.e. PBX, or even if you do not have any physical equipment, you can connect to the Teams cloud directly from the cloud or your company phone server through the Teams Phone System with the most suitable of the 3 services above.

Frequently Asked Questions About Teams Phone Audio Services

Can you keep using your desk phones with Teams Phone Audio Services?

Yes – Click here to see Teams certified desk phones.

Are there any differences for Mac users using Microsoft Teams Audio Services?

No, Mac users have the same experience as Windows users.

Is it a one-time cost to buy a Teams certified desk phone? Or are there constant additional fees?

Adding a desk phone to Microsoft Teams Voice is a one-time cost, and it’s a hardware cost. PEAKUP TECHNOLOGIES sells certified desk phones for Teams. Click here for our product list where you can benefit from our discounted prices.

Can you move your existing phone number to Microsoft Teams Voice?

Yes, you can move your existing phone numbers to Microsoft Teams with no additional costs.

Does Teams Phone Audio Services have an SLA?

Yes, click here for detailed information.

Are calls safe and HIPAA compliant with Teams Phone Voice Services?

All services are end-to-end encrypted and protected by Microsoft assurance. Click here to review HIPAA compliance.

What happens to your work phone number when you switch to Teams Phone Voice Services?

When your company switches to Teams Voice Services, your current business phone number becomes your Teams phone number directly. You will not need to take any further action.

Can Teams transcribe what the person who left you a voice message said?

Yes, Teams provides a voicemail transcript automatically for every voicemail you receive. The accuracy in this transcription process largely depends on the caller’s pronunciation and sound quality. (Currently unable to transcribe in Turkish, but a great opportunity for the future!)

Can you assign Teams Voice Service via PEAKUP for your new users?

Yes – Microsoft Teams is scalable to business needs, licenses can be purchased at any time.

You can reach PEAKUP Technologies here to meet a complete Teams Voice Services Solution in the cloud and make a smooth transition to Teams Phone System! We accompany you in your digital transformation journey with our Microsoft 365 and Teams certified experts.

 

PEAKUP PROVIDES ADVANTAGES WHILE MIGRATING TO CLOUD TECHNOLOGIES

With their Microsoft Platforms, PEAKUP provides advantages for companies while migrating to the cloud technologies

PEAKUP serves their customers with business intelligence solutions and their products that reach to the end users. And they are enhancing their global service field using Microsoft platforms.

PEAKUP helps companies migrate to the cloud technologies with the Microsoft Office 365, Azure, Teams and Power Apps platforms and develops corporate applications in business intelligence reports. PEAKUP also develops their own products on Microsoft platforms and exports them to the Middle Eastern, American, and European countries.

PEAKUP, that has many customers both in Turkey and globally, apart from giving consultancy services about Microsoft technologies, also works on extending the usage of the Microsoft Teams application.

PEAKUP Technologies CEO Ahmet Toprakçı pointed to the fact that Microsoft Teams has started to be used more especially during the pandemic and said: “Now the employees are working remotely. It is not a must for our developers to live in Istanbul, they can live anywhere in the world. And in such dynamics, companies need to reflect their work environment to the employees working remotely, and here we can talk about the importance of Microsoft Teams.” Toprakçı stated that they improve the services they provide for the companies with Microsoft platforms and that as a result of this they provide significant advantages to the companies.

Searchable Data Validation List in Excel for the Web

SEARCHABLE DATA VALIDATION LIST

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.

 

Example

ROW LEVEL SECURITY WITH POWER BI

.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!

 

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!

 

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’de duyarlılık etiketlerini gösteren ekran görüntüsü.

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 moreOutlook'taki sesle dikte özelliğinin (@bahsetme) ekran görüntüsü.

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

 

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.

tooltips

Now, let’s design the tooltip page the way we want. I will be designing a tooltip with the size of a normal page.

tooltips

.

.

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.

tooltips

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.

tooltips

.

See you again, have a nice day!

.