Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Last Refreshed Date with Synapse CUBE as Data Source

 My data source is Synapse CUBE, and I am trying to add last Refreshed Date to my report/dashbord. However, since I am using a CUBE, the advanced query editor is not available. The only choice available is to use a measure. Is there a away to create the last refreshed date without using the advanced query editor? Please share..

Need Help

3 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous

     

    You can create a calculated table with DAX Table = {NOW()} and display this datetime value in your report to show the last refreshed time. A calculated table is only evaluated when it's created or the data is refreshed. When you publish the report to Power BI Service, it will show UTC time there. So if your time is not UTC time, try adding/subtracting the offset hours like {NOW() + 6/24}. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Once connected to the Cube, only new and quick measures are available. See below my screen shot. The solution provided wouldn't work in this scenario. Is it possible to solve it by using either the new or quick measure? Keep in mind that blank query and advanced editor are not available either.

      Thanks,

       

       

      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous 

         

        What data source is it and which data connector do you use to connect to it?

        Which connection mode do you use to connect to this data source? 

         

        From your description and screenshot, it looks like you are using Live Connection mode to connect to this data source. If so, it will always query data from the data source directly. We can think it is using live data so there is no need to add a "Last Refreshed Date" to the report. A "Last Refreshed Date" is usually added when we use Import mode and refresh data manually or automatically. 

         

        Best Regards,

        Jing