Power BI Report does not show remaining pages after publishing to workspace in Reading View

 Hi All,

After I publish my Power BI report to workspace, in reading view I could not see the second page or remaining pages. 
To enable this feature

Click on File > Settings 

And then click on Save. Bingo! Issue is fixed

Slicer date addition in Power BI to reflect from minimum date till yesterday's date

 Hi All,

When you have a slicer in your dashboard that gets data from a calendar table saved in SSAS tabular model and then your requirement changes that the slicer should display max date as Yesterday's date

Apply the below DAX formula to your calendar and Bingo, issue is fixed !

=CALENDAR ("1/1/2015",TODAY() - 1)

Unexpected error in Power BI Visuals after migrating to production environment

 Hi All,
I moved my Analysis tabular model cube to production and changed the settings in Power BI. No Visuals were working and all gave me same error Unexpected error. When I clicked on Copy message it told me a lot of DirectQuery features disabled.

I spent time in enabling these features but Alas ..this was not the fix. 

The fix turned out to install the latest cumulative update for the SQL server version installed in production. 

https://support.microsoft.com/en-us/help/2876882/kb2876882-fix-internal-error-an-unexpected-error-occurred-when-you-run

Enjoy deploying!!

Spacing between bar chart columns in Power Bi

 Hi All,

I had a requirement where I have to introduce spaces between bar chart columns. Since this is not a default option present in power BI, I had to apply for workaround. 
The steps in below link helped me achieve it

https://community.powerbi.com/t5/Desktop/Spacing-in-column-chart/m-p/423641#M194839

Enjoy!!

To find the version details of the SSAS Analysis server

 Hi All,
Follow the below steps to find the version details of SSAS Analysis server


 SSMS: connect to your SSAS.

* Right-click Server

* Reports

* Standard Reports

* General

Date functions in DAX

Hi All,

Learnt few date functions in DAX

1 - To obtain Week Num  = =WeekNum(DateColumn, 2)

2 - if you want day to start from Monday and 1 - if you want Sunday

2 - To obtain Month name

=Format(DateColumn,"MMM")

3 - To obtain Day name

=Format(DateColumn,"dddd")

Power BI DAX - RELATIONSHIP IS many to many relationship which is currently not supported

 Hi All,

Error while creating relationship between two tables in SSAS tabular model - RELATIONSHIP IS many to many relationship which is currently not supported.

To resolve this, create a bridge table and then establish One to many and Many to One relationship between the tables.

You may use the below DAX query to create Distinct value

=DISTINCT(D_EXCHANGERATE[CD_FROMCUR])

Enjoy coding!