.NET GENES

Hello Gents, Here's how to setup a Power BI On-Premises Data Gateway to a On-Premises data source like Microsoft SQL Server or any other databases in Power BI Service so that you don't have to move your datasources elsewhere. The idea of a gateway is to keep your reports in the Power BI Service up to date of it's content through Schedule refresh or live connectivity. This is important so that stakeholders and top management can access the reports anytime through the app or website with updated information. So to setup a Power BI Data Gateway in your machine, just follow the steps provided below to accomplish the task at hand. I. Download Data Gateway For The Reports 1. Download datagateway from Microsoft Powerbi website: Connect to on-premises data sources with a Power BI gateway 2. Sign-in with your personal or domain account. 3. Choose on-premises data gateway (recommended) 4. Choose register a new gateway on this computer if fresh install. 5. Fill out on-premise

Good Evening All! While I was creating a Power BI report last year,I was tasked to make a report restrict information for a given set of users in our organization. After googling for a few minutes or so, most of the results were pointing me to Row-Level Security. One of the few points mentioned by Microsoft's RLS documentation is that members of a workspace defined in the Power BI service have access to the datasets. In which case are the admins of the workspace. In this report project we have to restrict data through domain account emails. So to start setting up RLS, I need to tweak some settings for both Power BI Desktop and Power BI Service. I. Power BI Desktop 1. In my sample report, click on Modelling menu then choose Manage Roles. 2. Add New Role called Supervisor Information then click Create. 3. Select Supervisor Information Dataset that contains email or information that will be used to Filter data based on a current role. In this case, I chose the Supervisor Informati