MSBI Tutor

Open Power BI desktop and click on use sample data Click on Load Sample Data Click on check box beside financials data sheet. Click on load-to-load data to data model. Drag and drop table to canvas. Drag and drop required columns to table. Right click on any one of column in build tab and select conditional formatting as shown in bellow. Select conditional formatting as background color. Change format style as rules. Create rules as you required. Click on Ok. Font Color: Select conditional formatting as Font color. Change format style as rules. Create rules as you required. Click on OK. Data Bars: Select conditional formatting as Font color. Click on OK. Icons: Select conditional formatting as Icons. Select field as shown in bellow. Click on OK.

Migrate SSRS reports to Power BI Manually 1.     Open the report server portal that contains the reports you want to migrate. http://localhost/Reports 2.     Download each report definition, saving the .rdl files locally. 3.     Open  the latest version  of Power BI Report Builder and connect to the Power BI service using your Azure AD credentials.   4.     Open each report in Power BI Report Builder, and then:   5.     Verify all data sources and datasets are embedded in the report definition, and that they're  supported data sources . 6.     Preview the report to ensure it renders correctly. 7.     Select  Publish , then select  Power BI service .   8.     Select the workspace where you want to save the report.   9.     Verify that the report saves. If certain feat...

SQL Server Row Level Security Row-level security (RLS) is a feature added as of SQL Server 2016. Instead of encrypting or decrypting a database’s table data, it restricts and filters a table’s row-level data in accordance with security policies defined by the user. This enables the database engine to limit the number of exposed data rows. This is a simple and powerful SQL Server security control that is transparent to both clients and user applications. Permissions Creating, altering, or dropping security policies requires the ALTER ANY SECURITY POLICY permission. Creating or dropping a security policy requires ALTER permission on the schema. Additionally, the following permissions are required for each predicate that is added: ·          SELECT and REFERENCES permissions on the function being used as a predicate. ·          REFERENCES permission on the target table being bound to the policy...