SSRS – How to Use Native Dot-Matrix Printer Fonts in Report
Question: SSRS – How to Use Native Dot-Matrix Printer Fonts in Report Answer: If you want to print your report…
SSRS – Parameter is showing duplicate values in the drop down.
Question: SSRS Parameter is showing duplicate values in the drop down. Answer: We can remove duplicate records by using TSQL…
SSAS – Aggregation values are not changing for the hierarchical dimensions
Question: Aggregation values are not changing for the hierarchical dimensions Answer: This issue normally comes when there is a…
High Level – Power BI Deployment
o User can publish content from your Power BI desktop into Power BI workspaces, which is a collection …
Power BI – Row Level Security(RLS) Model
⦁ With Row-level security (RLS), We get the ability to publish a single report to multiple users but expose the…
Power BI Security Model
• Web Front End – Power BI uses Azure Active Directory (AAD) to authenticate users who sign in to the…
High Level Architecture – Power BI
Data Source : Power BI supports vast range of data sources. For Web Application, Data source can be be SQL…
SSRS – How to implement hovering of data in the report (Mouse Hover Action)
Sometimes, we need to display length text in the report for supporting other attributes e.g. Column 1 is Attribute Name…
SSRS – How to give Name to sheet(s) while exporting report to excel
When we export the SSRS report to excel, SSRS export report with its default sheet name e.g Sheet1, Sheet2. Below…
SSRS Security Model – Role Permission Matrix
Role/Permission Matrix Following is the Role/Permission matrix for an application that uses SSRS reports for their portal. This matrix consists…
T-SQL – How to get the count of occurrence of a keyword in a string
If there is a requirement to check how many times a particular keyword comes in a string then below T-SQL…
Need of Custom Role(s) in SSRS Security Model
1) Predefined Role(s) in SSRS Reporting Services installs with predefined roles that you can use to grant access to report…