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.

What is Power Automate? – An Overview

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:

POWER AUTOMATE FOR EVERYONE

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:

  1. Trigger
  2. 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:

  1. We have created a survey, and we want this flow to be triggered when a new answer comes in.
  2. We get the details of the answer that caused the trigger.
  3. 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.
  4. 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.
  5. 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.

Good game, well played.

How to Subcrıbe to a Hıdden Page ın Power BI Reports?

 

Hello dear reader! Today we bring you an important study topic that hasn’t been solved for the Power BI users yet. What if we want to subscribe to a hidden page in Power BI reports? What do we do? Actually, there was a poll in the community page for this feature to come and it has been approved, but hasn’t been added to the roadmap yet. With the “Hide Page” feature of Power BI, we can prefer not to show certain pages to some users in the reports uploaded to the portal. These pages usually consist of the detail pages. What is on these detail pages? The detail pages consist of very detailed information -usually charts- that we don’t directly need in the report but that is highly requested by some users.

And at some points, these hidden pages might be pages that have been directed from a navigation screen or it might be a completely unique situation to your company. Long story short, there are some pages and you do not want their name to appear or to be accessed directly by the users while browsing through the report! So what if you want to subscribe users to these pages that you do not want to be accessed directly in the report?

Power BI does not offer this as a default feature, meaning we cannot subscribe users to the hidden page. While researching the details of this, I found out that this is because of the design. After doing a few experiments on how to do this, we figured out how to subscribe to the hidden page in Power BI reports! If you please, let’s see how we can do it now:

1- Upload the said page to the portal without hiding it.

Gizli sayfa görünüyor2-Define the necessary subscriptions to the page.

Gizli sayfaya abonelik3- Click on “Edit Report” and hide the page.

Sayfayı gizleyin

Go back to the review mode and that’s it!

Now, let’s wait for out mail to come at the hour we have defined. Here it is!

mail

It is quite simple to do, but there is a something that you need to pay attention to. Never turn on the subscription feature for the hidden page! When you turn it on, you will see that the report page field will be blank and this subscription will no longer work and you will need to repeat the steps above all over again. If you want to edit the subscription, first make the hidden page visible, then edit the subscription.

We can explain the reason of this situation like this: We had said that the report pages didn’t completely get lost in the back, and that were just not shown in the design on the front. So, actually, the information of the page is kept this way on the subscription page. However, when we turn the subscription back on, the values in this field start to work according to the current situation and explode when you cannot find the page! If you do not do such a thing, you can use this smoothly without any problems.

See you in the next article,

Good game well played!

 

Power Apps and Power Automate 2020 License Updates

Power Platform

We have been waiting for the work flow product we knew as Ms Flow to get the Power title like Power BI and Power Apps for a long time. It recently joined the Power Platform family with the name of Power Automate (Flow) as expected.

Power Apps and Power Automate (Flow) is a team that increases efficiency and speeds up the work right from the beginning. While end users are working on their Power Apps mobile apps, Power Automate quietly sustains the work flow and verification process in the background.

You can click here for the articles about Power Automate.

Can I use Power Platform for free?

If you have any type of Office365 license, yes!

If you have one of the Office365 licenses below, you can use the Power Platform products for free.

2020 Licensing Updates for Power Apps and Power Automate

The increase of Premium connectors and features was foreshadowing the licensing changes that would happen in Flow.

With the Flow joining the Power family, Power Apps & Power Automate came to the top of the agenda.

If you don’t have Office 365

With the licensing method based on layered quote becoming definite, the prices are still valid since December 1, 2019.

You can use Power Apps and Power Automate as Add-on with monthly payment.

Licensing is separated into two ways: based on the number of users or based on the number of applications you will use.

1st Payment Model

To use 2 mobile apps as Company/Person

It is priced as 56 TLs (in Turkey) per user and the costs increase as the application number increases.

 

2nd Payment Model

To use limitless number of mobile apps as Company/Person

It is priced as 224,20 TLs (in Turkey) per user and there are no extra costs.

Take a look at here for details.

 

Take a look at here for the document about licensing.

Page Redirect Actions

The Navigate function is used to switch between screens in PowerApps mobile applications.

How do you switch between pages?

By touching/clicking the items on the screen (with the user trigger)
Or automatically after a certain period of time (with a timer).

Usually the OnSelect property is used for all the actions that wanted to be executed the moment we “click”.

As an example, let’s take a look at how we switch to the next page when we click the next button on the page.

The page redirection action for the next button:

Navigate (target page, transition effect) will be written into the OnSelect property of this item.

You of course don’t have to write the Navigate formula to OnSelect all the time. We mentioned that different items have different properties. In this sense, properties like OnCheck, OnVisible, OnChange are used when necessary as well.

The OnCheck property can be used for a check box if you want it to work “the moment it is marked”.

New Products on Power Platform

Power Virtual Agents

Power Virtual Agents, the system where you can create your own ChatBot!

With Power Virtual Agents, you can create a learning chatbot structure.

A system where you decide the questions and answers. The way it works lets you start the flow with Power Automate and is very prone to be developed.

 

You can create custom workflows with Power Automate within the Power Virtual Agent, or work in an integrated manner with the products and services with the help of hundreds of conductors by creating complex scenarios with Microsoft Bot Framework.

Evaluate Performance
You can track the bot’s performance and always make improvements by using the AI and data-based analysis on the dashboard.

Click here for detailed information.

Manage Items Centrally by Using Properties

You might feel the need to manage the items on the screen from a center while developing a Power Apps application. When the properties of a certain item change, the features like the color, size, place can be managed for the related items on all screens.

There are two existing methods for central management.

  1. Method 1: Managing by using the item properties on the formula bar.
    Since the actions are executed through formulas, it is the most stable method. You can use all the features in the Properties window like color, position and size. This method is one of the first actions you need to execute while you’re developing an app. It can be hard to execute this action on an existing app, but it will help to do it.
  2. Method 2: Components (Experimental)
    Since this method is experimental, it doesn’t work in a stable way. Compared to the formula method, it is way easier to use.

Manage Items Centrally with Formulas

You might have heard in a lot of places that Power Apps works with the Excel logic and the formula structure is similar.

We write =A1+A2  into the formula bar in Excel to sum up two cells. In this action, we use the cell names directly in the formula and thus call and sum up the value in the cell directly. This way, whenever the value in the cell changes; the sum value gets recalculated.

When we want to execute the same action on Power Apps, we can use items like Text Box and Label. For example, we can calculate and display the sum of values entered in 2 Textboxes in a Label.

The Label item on the screen is named as Toplam (Sum), and the TextBoxes are named as Sayı1 (Number1) and Sayı2 (Number2).
We can display the sum value by writing the =number1. Text + Number2.Text into the Text property of Sum.

It means: Get the Text data of the Number1 item   +   Get the Text data of the Number2 item.

Right with the same logic of this examples, the item properties can be used in order for the items to imitate each other.
Actually, we are going to execute the action by assigning the properties of an item to another item.

Action Steps

Add two Label items to the screen.

Label1–> will stay as Label1
Label1–> will be renamed as Item_dependentto_Label1

Label1
Its features like fill color, text and border color are changed and thus, it is customized.

Item_dependentto_Label1

The properties are changed with the formulas below for this Label.

Fill –>  Label1.Fill  (Gets the fill color of Label1)
BorderColor–>  Label1.BorderColor  (Gets the border color of Label1)
Text–>  Label1.Text  (Gets the text of Label1)
Width–>  Label1.Width  (Gets the width of Label1)
Height–>  Label1.Height  (Gets the height of Label1)

Like it was written in the formula, this item is now dependent to Label 1. When the features of Label1 change, the dependent item will change.
You can distribute the dependent item to screens with copy-paste.