Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

PowerBI with dbatools & dbachecks

  • 1.  PowerBI with dbatools & dbachecks

    Posted 29 days ago
    Dear PowerBI communitie,

    I'm just starting and it's been great to get these very useful and practical reports.
     
    With the powershell tools dbatools & dbachecks I'm having a small issue, my PowerBI always opens in the default report and not with the data of the new JSON created (C:\Windows\Temp\dbachecks\dbachecks_1_Default__Backup.json)
     
    Check the example:
    Invoke-DbcCheck -SqlInstance 'SRVSQL1\LAB01,8701' -SuspectPage, LastBackup Tags -Show Summary -PassThru | Update-DbcPowerBiDataSource
    Start-DbcPowerBi
     
    Do I need to change something in PowerBI to open the report with the new data?

    Thanks

    Paulo



    ------------------------------
    Paulo Pires
    SQL Server DBA
    ------------------------------