Wednesday, 10 January 2018

Tips: Power BI Report Designing

- design your own color theme
- design report according to eye movement: left to right and top to bottom
- follow the text size and type through report
- use numbers card in your report 

Wednesday, 3 January 2018

Optimizing performance of Power BI report

while bringing data to power bi desktop file

-avoid/ do not bring colums which are not required for reporting
-prefer calculated measure over calculated column
-hide columns and measures which are required for modeling but not for reporting like id columns

Tuesday, 2 January 2018

Power BI Intermediate Interview Questions

1. What is difference between live mode, direct query and import mode in power bi?
2. Why we need Power BI gateway?
3. What is active and inactive relationship between two tables.
4. Describe table relationship cardinality of reports.
5. How we can have many to many relationship in powerbi
6. Define realtionship cross filter direction (single and both)?