MSBI Tutor

Dynamic Data Masking Dynamic data masking feature that Microsoft implemented in SQL Server 2016 version. Dynamic data masking (DDM) limits sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to specify how much sensitive data to reveal with minimal impact on the application layer. DDM can be configured on designated database fields to hide sensitive data in the result sets of queries. With DDM the data in the database is not changed. DDM is easy to use with existing applications, since masking rules are applied in the query results. Many applications can mask sensitive data without modifying existing queries. A central data masking policy acts directly on sensitive fields in the database. Designate privileged users or roles that do have access to the sensitive data. DDM...

We’re excited to announce that dynamic per recipient subscriptions are now available in Preview for Power BI reports! Similar to  dynamic subscriptions for paginated reports , you can now distribute a personalized copy of a Power BI report to each recipient of an email subscription. How it works What you’ll need to get started Setting up a dynamic per recipient subscription Things to keep in mind We want to hear your feedback How it works Imagine you have a report that includes sales data for your entire team. You want to schedule an email subscription that sends out a PDF copy of this report to each salesperson on a weekly basis, with the report filtered to only show their sales results. This can now be done by connecting to a semantic model (previously  Power BI dataset ) that defines the mapping between recipients and respective filter values. When it’s time to send out the report, the latest data available in your semantic model will determine which employees should receiv...