Power BI Rest API as a datasource

Hi michaelccdf 

1. Load the Power BI pbix file associated with your view in Power BI Desktop.

2. In the External Data section of the ribbon, choose Edit Queries and Open Advanced Editor.

3. If you have not already modified the query you should see text below with specific table values matching your Analytics view.

    

   let
       Source = VSTS.AnalyticsViews("{OrganizationName}", "{ProjectName}", null),
       #"{tableid}_Table" = Source{[Id="{tableid}",Kind="Table"]}[Data],
   in
       #"{tableid}_Table"

   Modify the query as follows:

   let
       Source = VSTS.AnalyticsViews("account", "project", null),
       #"{tableid}_Table" = Source{[Id="{tableid}",Kind="Table"]}[Data],
       #"Added Refresh Date" = Table.AddColumn(#"{tableid}_Table", "Refresh Date", 
           each DateTimeZone.FixedUtcNow(), type datetimezone)
   in
       #"Added Refresh Date"

    Important

   These examples use UTC. You can adjust the query code based on your specific timezone as described in DateTimeZone function

4. When finish, choose Done.

5. Choose Close & Apply to immediately refresh the dataset.

6. Identify the Refresh Date column under the field.

7. Add the field to a card to see the last refresh date on your reports.