Power BI – How to convert PBIX file to PBIT file
Overview: PBIX – PBIX is the file format or file structure of Power BI report. It consists of the following:…
Month: June 2021
Power BI – How to add search text box in the slicer
Overview: Adding search box in the slicer is very useful in case when we have a very long list of…
Power BI – How to see tabular data from a chart report
1) Open the chart report in Power BI app or Power Designer 2) Click on … More options è show…
Power BI – How to pull the data from Web
1) Objective The objective of this article is to provide an easiest way of pulling the data from web that…
rsReportServerDatabaseError – Timeout or low disk condition within the database
Error: An error occurred within the report server database. This may be due to a connection failure, timeout or low…
SSRS – How to run SSRS report based on either of the 2 parameters
We need to write dataset query in IF ELSE manner with Parameter. Below is the example: Suppose @QueryType is your input…
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…
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.
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…