Category: Uncategorized

Optimizing Power BI dashboards or reports involves improving performance, usability, and overall effectiveness. Here are some tips to optimize your…

 Having a date dimension in a data warehouse or database offers several advantages: Ease of Querying: A date dimension provides…

 Both the Star schema and Snowflake schema are popular data warehouse modeling techniques, each with its own advantages and use…

Issue: When we click on Refresh button to refresh the table(s) in Power BI Designer, by default, it will start…

Overview: PBIX – PBIX is the file format or file structure of Power BI report. It consists of the following:…

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

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…