Feeds:
Posts
Comments

Archive for October, 2018


Recently i was working with Time Sheet Reports and one of the request was to incorporate calendar exceptions in order to avoid sending emails for holidays and hence started working on getting calendar exceptions in Power BI report, once i got the calendar exceptions it was easy to incorporate it as filter in all the reports

The intent of this post is to show how to bring in calendar exceptions in Power BI, once in the usages are numerous and any Power BI report developer can easily incorporate it in various ways

Step 1.  Launch your Power BI .pbix file

Step 2.  Navigate to Data in Left bar >> Edit Queries

1POLCalExcep

Step 3. New Source  >> OData

2POLCalExcep

Step 4. Add New Odata URL as https://Your.servername.com/sites/pwa/_api/ProjectServer/Calendars

3POLCalExcep

Notice i am not going to oData instead using REST API

6POLCalExcep

Once added >> you should see the Calendars as above

Step 5. Load the Query in connection Model

Step 6. Once Created i renamed the Query1 dataset to “AllCalendarException”

Step 7. Expand the “BaseCalendarException” Tables

7POLCalExcep

Step 8. Once Expanded you would notice all the exceptions available in your dataset for your use

8POLCalExcep

 

Read Full Post »