Forum Discussion

Kumardin9093's avatar
Kumardin9093
New Member
9 months ago
Solved

refresh all power bi reports

Daily and Monthly Jobs run from ADF Synapse,Are those jobs failing or not?Are all the total reports refreshing in the workspace in Power BI?I need a separate report on these in Power BI

 

 

Thanks,

Kumar

  • Hi Kumardin9093 

    Thank you for contacting the Microsoft Fabric community forum.
     

    To track your daily and monthly activities in Azure Data Factory or Synapse, as well as monitor the status of Power BI refreshes, it’s important to use a thorough approach. With Azure Data Factory or Synapse, you can monitor pipeline executions using REST API and Log Analytics, allowing you to see whether each job has succeeded, failed, or been cancelled. This information can then be imported into Power BI.

     

    For Power BI, it is key to note that while reports do not refresh, datasets (also called semantic models) do refresh as lbendlin noted earlier. So, to check if every dataset in your workspace is successfully refreshed, you will need to use the Power BI REST API- Get Refresh History as mentioned by GeraldGEmerick .

     

    In addition to that , if you want to create a complete monitoring solution, combine the pipeline run details from ADF or Synapse with the dataset refresh history from Power BI, then load and summarize this data in Power BI for reporting. This will give you a clear overview of both ETL pipeline results and dataset refresh status, so you can confirm successful data loads.

    For more details, please refer to Microsoft’s official documentation onProgrammatically monitor an Azure Data Factory  and Monitor Azure Data Factory - Azure Data Factory | Microsoft Learn
     

    I hope this information is helpful. If you have any further questions, please let us know. we can assist you further.

     

    Regards,

    Microsoft Fabric Community Support Team.

5 Replies

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      Reports do not refresh. Semantic models refresh.

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support

    Hi Kumardin9093 

    Thank you for contacting the Microsoft Fabric community forum.
     

    To track your daily and monthly activities in Azure Data Factory or Synapse, as well as monitor the status of Power BI refreshes, it’s important to use a thorough approach. With Azure Data Factory or Synapse, you can monitor pipeline executions using REST API and Log Analytics, allowing you to see whether each job has succeeded, failed, or been cancelled. This information can then be imported into Power BI.

     

    For Power BI, it is key to note that while reports do not refresh, datasets (also called semantic models) do refresh as lbendlin noted earlier. So, to check if every dataset in your workspace is successfully refreshed, you will need to use the Power BI REST API- Get Refresh History as mentioned by GeraldGEmerick .

     

    In addition to that , if you want to create a complete monitoring solution, combine the pipeline run details from ADF or Synapse with the dataset refresh history from Power BI, then load and summarize this data in Power BI for reporting. This will give you a clear overview of both ETL pipeline results and dataset refresh status, so you can confirm successful data loads.

    For more details, please refer to Microsoft’s official documentation onProgrammatically monitor an Azure Data Factory  and Monitor Azure Data Factory - Azure Data Factory | Microsoft Learn
     

    I hope this information is helpful. If you have any further questions, please let us know. we can assist you further.

     

    Regards,

    Microsoft Fabric Community Support Team.

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support

    Hi Kumardin9093 

    I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

    Thank You.

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support

    Hi Kumardin9093 

    We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

     

    Thank You.