Microsoft Power BI Interview Questions- Real Interview Questions

POWER BI + SQL INTERVIEW QUESTIONS

Table of Contents

Here, I have mentioned some of the real Interview Questions asked related to Power BI and SQL.

Power Query is the ETL component in Power BI where you can do a mashup of data coming from various sources and also do the transformation of data.

Answer – Create a bridge table having a primary key column from both tables and removing the duplicate. To make a unique column in each table by combining the columns and then connecting the table.

select  *
from(select version, product_oer_lvl_0_ID, mtd, dense_rank() over ( partition by version  order by mtd desc ) as ranki
from
(select version, product_oer_lvl_0_ID, sum(mtd_net_amount) as mtd
from
AA_RPTG.OER_SUM Partition (OER_SUM_P_FORECAST_FACT)
group by
version, product_oer_lvl_0_ID
))where ranki<=3

Categories
QUICK REPORT IN POWER BI SERVICE
Power BI Desktop
Kaushlendra Mishra

How to create a report quickly in Power BI Service?

Do you want to create a quick report in Power BI? The latest Power BI version has made it possible to create a quick report using data from the web and existing published datasets in Power BI Service. So, now you do need to download the Power BI Desktop software into your PC and directly make a report using the Power BI service.

Read More »

Leave a Comment

Your email address will not be published. Required fields are marked *