Power BI – World Tour (7 cities across the world)

The “Power BI User Group” (PUG) is going to run the “Power BI World Tour” with access to premium Power BI content designed by your local industry experts. Starting in August, the tour will visit seven cities throughout the World. Hurry up and register before 7 August to get discounted rates for this 2 days event. …

Continue reading ‘Power BI – World Tour (7 cities across the world)’ »

“Quick Insights” feature in Power BI

What is it? How does it work? How it can be helpful? Power BI quickly searches different subsets of your dataset while applying a set of sophisticated algorithms to discover potentially-interesting insights. Power BI scans as much of a dataset as possible in an allotted amount of time. You can run Quick Insights against a …

Continue reading ‘“Quick Insights” feature in Power BI’ »

Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)

Hi Guys, I have been waiting for an official certification from Microsoft on Power BI. And finally I saw the exam opened up. 🙂 Even though it is still marked in Beta but you can go-ahead and schedule if you want. Or you can start gearing up with necessary technical knowledge to complete the certification. …

Continue reading ‘Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)’ »

The Story of Precision, Scale, and Length in SQL Server

Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any  other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic  operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related …

Continue reading ‘The Story of Precision, Scale, and Length in SQL Server’ »

MSSQL: Find total records of each Table in given Database

hi guys, i wanted to do a quick post on how you can find total number of records in each table of the database. here is the script you can use: USE <Your Database Name> GO ;WITH CTE_DATABASETABLESIZE (DATABASENAME, SCHEMANAME, TABLENAME, TOTALROWS) AS ( SELECT  DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS FROM  SYSOBJECTS SO  INNER JOIN SYSINDEXES …

Continue reading ‘MSSQL: Find total records of each Table in given Database’ »

User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Hi guys, its seems like this issue have been faced by many prople. i have checked the solutions on web and found that not all answers contains the complete solution. so decided to put 1 complete solution here. in most of the places, you will find answers like… Run IE as Administrator -> Open Report …

Continue reading ‘User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.’ »

E-Book Gallery for Microsoft Technologies

Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press. Rate this post

SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels

Hi guys, Today i would like to show you the little trick for your SSRS graphs. Issue: I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign. What I need: The bar chart should display the “%” …

Continue reading ‘SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels’ »

SSRS Report is asking for Username and Password while executing

Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need …

Continue reading ‘SSRS Report is asking for Username and Password while executing’ »

Quick-Fix: Report parameter with space in SSRS

Hi guys, One of the most common practices and a wise recommendation is to display selected report parameter(s) in report … may be in header or body of SSRS report. It’s a good reference when you export the SSRS report into available formats (Excel, PDF, Word etc.) Because if you don’t include/show selected parameter(s) in …

Continue reading ‘Quick-Fix: Report parameter with space in SSRS’ »