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)?

Friday, 10 November 2017

Power BI Advance Interview Questions

1 . How we can embed power bi report into our application without using per user license?
 or
1 . How we can bring power bi report into our custom website or application without power bi user license?
2. what is the maximum size of power bi file we can upload to powerbi.com?
3. Difference between Power BI Service, Azure Power BI Embeded  and Power BI Report Server?
4. What is RLS (Row Level Security) and how we can apply it?



Saturday, 29 April 2017

Error Connecting Power BI to Azure SQL

Azure SQL is the best data source for Power BI reports.
But it is very irritating if you can unable to connect it and find some unknown error.
So to fix it follow below-mentioned steps:

Step 1: Clear the stored credential inside the Power BI.
Open Power BI > File> Options and Setting >Data Source Setting > select data source (azure SQL)  >  Clear permission > Clear all permission> close


Step 2Loging again to azure sql 
Get data> SQL database> Provide AzureSQL server(like:abcd.database.windows.net) > provide option database>



>select database for credentials>user name > password and click ok



All Done!

Now you will not get error make sure your SQL azure server looks like this abcd.database.windows.net  and provide optional DB

Tuesday, 5 July 2016

PowerBI Desktop Query Editior Tips – Listing all functions of M Code

Open a Blank query and in formula bar write = #shared and hit enter to list all M code function used in power query, click on function name for more detail about M code function.
Steps: Open PowerBI Desktop –  Edit Query – From Other Source – Blank Query – Formula bar – write = #shared  – hit enter