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?
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
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( > 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  and provide optional DB