Power BI

  Power BI Gateway Connection : →  Upgrade your free account  on the Power BI Service from Free to Pro version →  To upgrade, just click on the "Try Pro for Free". Let's see the difference between the free and pro version →  The first difference is that you can create Apps and a new workspace → Next, we will install the gateway. Please note that the gateway can be installed in the free version too, but the schedule refresh can't be set → Goto Datasets, and click on the Gateway connection - Install now Types of gateways There are two different types of gateways, each for a different scenario: On-premises data gateway allows multiple users to connect to multiple on-premises data sources. You can use an on-premises data gateway with all supported services, with a single gateway installation. This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources. On-premises data gateway (personal mode) allows one user to connect to sources,

Power BI  Security Level In Power BI There are 2 levels of security in Power BI Data level/Row-level security: Data is visible based on their login in a report. As per assigned roles only they view data in the report Access Level: The security is applied at the workplace/App level. It means managing security in the workspace by giving edit, view and browse..etc options for a workspace to members     Row Level Security : EX :  → Consider the situation where you need to restrict the data/row level at a country level. Let's see how to implement row-level security. → Creating roles based on the country column  → Next, go to the Modeling tab and click on Manage Roles → Click on Create a role - "Query1" and Select Place on Add Filter →  Create a DAX Calculation  [place] = "US" →  Similarly, create roles for US and INDIA countries. Now, Click on View as in modeling Tab See Data filtering based on row-level security : Assigning members to roles in Power BI Service: Goto

Power BI : Power BI Dashboards  A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it is limited to one page, a well-designed dashboard contains only the most important elements of that story. The visualizations visible on the dashboard are known as tiles. These tiles are pinned to the dashboard from reports. The visualizations on a dashboard come from reports and each report is based on one data set. In fact, one way to look at a dashboard is to consider it as an entry point into the underlying reports and data sets. Selecting a visualization takes you to the report (and data set) which was used to create it. Pin Visuvals to dashboard and create stories : Ask a question on your data in a dashboard : Add Tile to Dashboard :

Power BI Publish reports Into Service In Order signup for Power BI Service, You need a Student or corporate account  Link To Create Power BI Service Account :  https://signup.microsoft.com/signup?sku=a403ebcc-fae0-4ca2-8c8c-7a907fd6c235&email=&ru=https%3A%2F%2Fapp.powerbi.com%3Fpbi_source%3Dweb%26redirectedFromSignup%3D1%26noSignUpCheck%3D1 Now, Open Power BI desktop and build some report Sign in Your Account Once Sign In : Publish the report into your account It asks a workspace to publish Mywoksapce is the default workspace In order to create your own workspace. We need a pro/ Premium service account Once got Published check-in service Service has 3 types of accounts : Free, Pro, and Premium Version Sign Into Service : https://powerbi.microsoft.com/en-us/landing/signin/

Power BI  Connection to DB, Difference Between Direct Query and Import Mode Goto Home → Get data → SQL Server Fill Required Fields : Click on ‘Ok’ Validate Credentials then Load the data : Difference Between Import Mode and direct Query : Import Mode : → copy of data into power bi file(PBIX) → Writing data into a file → when it is published. It doesn't require anything to pull the data into a file and it is extremely fast because it writes in a powerBI file Limits Up to the size of data - Don't Have Premium Account Import option : 1GB Limits Up to the size of data - Have Premium Account Import option : 10GB Direct Mode : Need Connection to data source every time It doesn't write data into a pbix file. Every time it reads data from the server  A little bit slow compared to import mode → when it is published. It requires Gateway Connection  to pull data into the service Dataset Limitation using direct query  1 Million Rows Limited Functionalities in Direct query whereas in im

Power BI   Bookmarks and Buttons Select some columns into a table : Copy Visual and Paste, change it to Bar Chart by selecting any one of the columns and overlap both visuals: Goto View → Enable selection Pane and Bookmark Pane In selection Pane, we Can hide and Display visuals Bookmarks helpful to display state of visualizations : Now, Create a bookmark : → Add Buttons   → Capture Visuvals by hiding required visuals  Now,  → Hide the Table and Off button create bookmark and capture bar chart Hide the bar chart and On Button, create bookmark and capture table Click on Bookmark1 and select the visible button and Enable action in the properties pane Type: Bookmark Bookmark: Bookmark2 Click on Bookmark2 and select the visible button and Enable action in the properties pane Type: Bookmark Bookmark: Bookmark1 Now, Ctrl+click on buttons to Capture Visuals