1.How to identify Duplicate Rows in a table 2.how to identify a year from rows 3. About Date functions 4. sort the country column in a way that first two rows should be usa,Canada rest of the rows in alphabetical order(how to write in SQL ,and in power Bi) 5.write a query on how many employs are join in each year 6.In power Bi about filters and how many types of filters 7.About Drill through and Drill down filter 8.when we map visualisation 9.about refresh in power Bi (why we use refresh) 10.how to connect data into SQL 11power Query and Power pivot 12.what is power BI Dashboard 13.how we publish report in power Bi 14. what is Stored Procedures 15.what is VIEW 16. INDEXES why we use in sql
Bi Developer Interview Questions
4,384 bi developer interview questions shared by candidates
Adf related and Power Bi related questions.
They asked me how I would handle scheduling dataset refreshes and managing the Power BI Gateway for multiple users.
It is based on the work you have done and showing in the interview.
sql basic, window functions, duplicate find and removing query to write, optimizing the query. in pbi rls, optimization, sum & sumx difference, transformations applied. in 2nd round intro, rls, optimization, project work flow.
Hanno fatto domande tecniche sugli strumenti prese dalle certificazioni microsoft e domande di logica
CMS Migration process , Win AD authentication, SAP BI services, Architecture
PBI: Datesinperiod, Time intelligence Functions, Row level Security. SQL : subquery, CTE, Joins
Can you walk us through a portfolio of prior BI work?
How important is working with stakeholders in order to be successful in building BI products?
Viewing 2181 - 2190 interview questions