Power BI Exchange

Expand all | Collapse all

Report Publish date

  • 1.  Report Publish date

    Posted 11 days ago
    Edited by Harshit Doshi 11 days ago
    Hi All,
    Is there any way to find the publish date for the report and user who published it?
    I understand this can be done by Audit log in PBI however, not every user will have an access to log and it is difficult for other users to understand when was this report last published.


    Any suggestions?
    Thanks,
    HD


  • 2.  RE: Report Publish date

    Posted 8 days ago

    Hi,

    As you mentioned, it's probably best way to check the auditing logs for report/dashboard in settings via Admin Portal. Important, you need to be a Global Admin, within O365 or Azure AD, or at least have been assigned to the Power BI service administrator role.

    Alternatively, you can use the Usage metrics functionality of Power BI service. Usage metrics captures usage information from all users, regardless of the license they're assigned (of course, Power BI Pro is a need!).

    In order to see the Usage metrics, please follow the steps:

    1. Log in to the Power BI service
    2. Navigate to the workspace your dashboards/report is located
    3. Look for the Usage metrics icon and click on it (below)

    Above screen shoots come from the Microsoft Power BI documentation, where you can find more details: Usage metrics for dashboards and reports - Power BI

    Hope it helps,

    JB



    ------------------------------
    Jakub Barzyk
    Sr. Business Intelligence Consultant
    Webstep
    90843092
    ------------------------------



  • 3.  RE: Report Publish date

    Posted 5 days ago
    Thanks everyone for the response.
    @Jakub Barzyk : Usage metrics is no longer an option with the new workspace. I understand it is in preview atm however, it is not always the easy way to see publish date by generating usage metrics.

    @Ben Oastler : Yes that is the way for Admin to look at the date, however, I am more concerned for the users using my report.

    @Tuhin Tapadar: at the moment, I don't have any solution but certainly I will update the post if I get any

    @Wade Wachs : That's the good way to get the date however if we have more than 10 reports in a single workspace, it is difficult to open each one of them and see the date.

    My requirement is more like windows explorer where you can see all the files and last date when it was updated. When you have a shared workspace and multiple people update single report, that's when you want to see when was the last update to the report was done.

    Also, the end user gets the confidence say for ex: the report is updated recently after their feedback or changes to the report are done recently hence the number looks different.

    I am also looking for last publisher name or person who edited the report online and saved it.

    Hope this makes sense.

    Thanks,
    Harshit


    ​​

    ------------------------------
    Harshit Doshi
    Sr BI developer

    ------------------------------



  • 4.  RE: Report Publish date

    Posted 5 days ago
    Hi Harshit,

    I think there is a workaround of your issues but it needs Power Shell scripting. E.g. if you keep all your pbix files in a particular directory then a power shell script can get the information regarding those file like created/modified by, created/ modified date etc and the same script can write those information on file (Excel etc) kept in One Drive.

    Finally, create another Power BI report which will access the same file as a source. Now you get a report that has information regarding your pbix files but unfortunately, you won't get the information regarding the publishing date/time in the power bi service.


    Regards,

    ------------------------------
    Tuhin Tapadar
    Data Analyst
    Dublin
    894164048
    ------------------------------



  • 5.  RE: Report Publish date

    Posted 7 days ago
    Hi Harshit,

    You might be able to use PowerShell to query the PowerBI service. I'm not sure if the publish date is there, but I imagine it should be.

    Announcing APIs and PowerShell Cmdlets for Power BI Administrators | Microsoft Power BI Blog | Microsoft Power BI
    Microsoft remove preview
    Announcing APIs and PowerShell Cmdlets for Power BI Administrators | Microsoft Power BI Blog | Microsoft Power BI
    Power BI enables organizations to adopt a data-driven culture where every person can get value from data. Front and center are business users creating reports and dashboards, sharing insights, making...
    View this on Microsoft >





    ------------------------------
    Ben Oastler
    Practise Director - North America
    Bizdata
    +1 (646) 934 6286
    ------------------------------



  • 6.  RE: Report Publish date

    Posted 7 days ago
    Hi Harshit,

    I do not think with the 'Usage Metrics' you can find the report publisher and publishing date. Furthermore, You can't run usage metrics on a dashboard or report unless you own the content or have permissions to edit.


    So I do not find any option for the individual users to get the information regarding report publisher and publishing date.


    If you come across any solution please let me know.

    Regards,


    ------------------------------
    Tuhin Tapadar
    Data Analyst
    Dublin
    894164048
    ------------------------------



  • 7.  RE: Report Publish date

    Posted 7 days ago
    I'm curious to understand the context of your question.

    Original Publisher and original publish date are both static bits of information. Could you answer this question by having your report publishes add a text box to the first page of every report with their name and date of original publish?

    This is a very low-tech solution, but if traceability is your main goal, it might work.

    -Wade-

    ------------------------------
    Wade Wachs
    Agile Coach
    LiquidWeb
    Holt MI
    ------------------------------



  • 8.  RE: Report Publish date

    Posted 5 days ago
    Thanks everyone for the response.
    @Jakub Barzyk : Usage metrics is no longer an option with the new workspace. I understand it is in preview atm however, it is not always the easy way to see publish date by generating usage metrics.

    @Ben Oastler : Yes that is the way for Admin to look at the date, however, I am more concerned for the users using my report.

    @Tuhin Tapadar: at the moment, I don't have any solution but certainly I will update the post if I get any

    @Wade Wachs : That's the good way to get the date however if we have more than 10 reports in a single workspace, it is difficult to open each one of them and see the date.

    My requirement is more like windows explorer where you can see all the files and last date when it was updated. When you have a shared workspace and multiple people update single report, that's when you want to see when was the last update to the report was done.

    Also, the end user gets the confidence say for ex: the report is updated recently after their feedback or changes to the report are done recently hence the number looks different.

    I am also looking for last publisher name or person who edited the report online and saved it.

    Hope this makes sense.

    Thanks,
    Harshit


    ​​

    ------------------------------
    Harshit Doshi
    Sr BI developer

    ------------------------------

    ------------------------------
    Harshit Doshi
    Sr BI developer
    +61469571157
    ------------------------------



  • 9.  RE: Report Publish date

    Posted 4 days ago
    To get this data to be available to everyone, you could possibly import Audit Log data into a Power BI report that you can then share with others.

    I'm not sure the best way to get the Audit Log data into Power BI though. Is there a better option than scripting Audit Log exports to a folder and then importing that folder into Power BI?

    ------------------------------
    Alexis Olson
    DFW, Texas
    ------------------------------



  • 10.  RE: Report Publish date

    Posted 4 days ago
    Hey,

    I would set up an ETL process to extract the publish date using PowerShell, and push that into your data warehouse. I can assist with this if you need a hand.

    cheers
    Ben

    ------------------------------
    Ben Oastler
    Practise Director - North America
    Bizdata
    +1 (917) 724 1666
    ------------------------------



  • 11.  RE: Report Publish date

    Posted 4 days ago
    Thanks guys for the help here.

    @Ben Oastler : thanks for offering your assistance. I don't think I will have enough capacity to start this at the moment. However, will let you know if required.

    One thing I personally think is, we should have this kind of option available by default in power bi service, like reporting services or like SharePoint where you can see the date, time and the person who updated it. I think this feature will come when MS think about doing a version control in Power BI services. (Finger crossed)



    ------------------------------
    Harshit Doshi
    Sr BI developer

    ------------------------------



  • 12.  RE: Report Publish date

    Posted 3 days ago
    You should make that suggestion here: Power BI Ideas: Hot (14269 ideas) - Microsoft Power BI

    Next time I speak to the engineering team, I'll mention it as well.

    ------------------------------
    Ben Oastler
    Practise Director - North America
    Bizdata
    +1 (917) 724 1666
    ------------------------------



  • 13.  RE: Report Publish date

    Posted yesterday
    I am not sure if I have understood your issue correctly. My response is based on my understanding of the issue. Excuse if I have misunderstood it.

    If you have scheduled refresh in power BI service for these data sets, can't you create a Dashboard with a relevant tile from each of your 10 reports and check the box 'Display Last Refresh Time' for each tile? This way, for the end user, he can view this dashboard to see in one place when each of the datasets were last refreshed.

    ------------------------------
    Gopa Kumar S

    ------------------------------