SSAS – How to change SUM function to AVG function in Grand Total
Go to the Measure property and change the aggregate function from SUM to AVG.
Year: 2021
SSRS – How to check whether dataset is returning data or not
We can use the below expression to check whether dataset is returning data or not : =IIF(CountRows(“YourDataset”) > 0,“Data is…
How to create Power BI Report using Excel as Data Source
1) Open the Power BI Designer 2) Go to Home è Excel Source or click on Get data è select…
Power BI – How to generate data if you don’t have source data to create the report.
1) Open Power BI Designer 2) Go to Homeè click on Enter Data 3) It will…
SSRS Report subscription Error – “Credential used to run the report are not stored”
Question: SSRS Report subscription Error – “Credential used to run the report are not stored” Answer: For any automated process…
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…