How to use Cross Report in Power BI?

How to use Cross Report in Power BI?

In this article, we will see step-by-step how to implement cross-report drill-through functionality. Cross Report Drill Through can be very useful when we want to reduce the size of each dataset which is extremely useful when there is a data size limitation based on license. Pre-Requisite for Cross Report functionality in Power BI While implementing…

How to connect EQuIS with Power BI?

How to connect EQuIS with Power BI?

Earth Soft`s EQuIS is a environmental data management solution which is used by large number of companies and government/private agencies around the world to store and manage environmental chemistry, biology, geology, hydrology, limnology, air related data.  Now, in the recent May 2021 Microsoft Power BI update, EQuIS connector has been provided in Power BI so…

What are Indexes in SQL Database? What is the advantage and disadvantage of Indexes?

What are Indexes in SQL Database? What is the advantage and disadvantage of Indexes?

Indexes are schema objects in a SQL database that can boost query performance while executing queries with a filter condition using where clause.

Indexes are used to retrieve data from databases very fast. An Index is a quick lookup table that is used to find a record that user search very frequently. An index helps to speed up select queries and where clauses, but it slows down data input, with the update and the insert statements.