Team SQL Circuit – Page 19

SSRS – How to dispaly data from Large Dataset without performance issue

We can enable report caching or Report snapshot if it fits in the requirement. There will be little data latency…

Go to the Measure property and change the aggregate function from SUM to AVG.

We can use the below expression to check whether dataset is returning data or not : =IIF(CountRows(“YourDataset”) > 0,“Data is…

1) Open the Power BI Designer 2) Go to Home è Excel Source or click on Get data è select…

1) Open Power BI Designer 2) Go to Homeè click on Enter Data 3) It will…

Question: SSRS Report subscription Error – “Credential used to run the report are not stored” Answer: For any automated process…

Question: SSRS – How to Use Native Dot-Matrix Printer Fonts in Report Answer: If you want to print your report…

Question: SSRS Parameter is showing duplicate values in the drop down. Answer: We can remove duplicate records by using TSQL…

Question: Aggregation values are not changing for the hierarchical dimensions Answer: This issue normally comes when there is a…

o User can publish content from your Power BI desktop into Power BI workspaces, which is a collection …

⦁ With Row-level security (RLS), We get the ability to publish a single report to multiple users but expose the…

• Web Front End – Power BI uses Azure Active Directory (AAD) to authenticate users who sign in to the…