SQL Server database dashboard

Louis 1 Reputation point
2022-08-12T20:26:51.167+00:00

Hey there,

I just started a new job and I am new to SQL server studio. My boss wants me to create a dashboard for our job procedures and stored procedures. A lot of what we do is pull information from SQL into tableau and Power BI dashboards. One of his requests is that he wants to see failed executionID's and whether or not they were requests going into tableau or power bi. I have been going through the msdb and other databases trying to figure this out. My question is is this possible? And if so what tables/ databases should I be looking in to pull this information? All help is greatly appreciated, thank you.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,797 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points
    2022-08-17T02:16:32.437+00:00

    Hi @Louis
    You need to go to the Power BI Community to ask this issue for more help: Power BI Community.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments