Forum Discussion

eyelikedata2's avatar
eyelikedata2
Helper I
9 months ago
Solved

Cannot get PowerBI report to refresh with Log Workspace data

Hello,

 

I have a large amount of data in an Azure Log Analytics Workspace. There is an option to export to Power BI. 

 

Previously, I was able to get the BI service to allow a refresh of the report from 2017 to 2023, provided that MFA did not present a challenge to access the tenant or subscription where the log workspace is located, and no conditional access blocks it from Entra. 

 

Now, when I attempt to do this in 2025, I receive a message stating that it does not allow dynamic data sources. Is anyone else having this issue?

 

See the following URL that is referenced

refresh-data

Need Help
  • eyelikedata2's avatar
    eyelikedata2
    9 months ago

    Update. I created a new query using the SentinelHealth table from the Log Workspace. I had no issues with the refresh, so this may be related to the static datetime table I created in the report when I had several data sources aligned. However, I found that the gateway did not want to make a custom Oauth API call I had created with Mquery to another SaaS service. 

     

    More to come as I check why the report will not use the one query. Chances are, if you are encountering this issue, there is a data source still enabled that the service does not like. 

2 Replies

  • eyelikedata2's avatar
    eyelikedata2
    Helper I
    9 months ago

    Update. I created a new query using the SentinelHealth table from the Log Workspace. I had no issues with the refresh, so this may be related to the static datetime table I created in the report when I had several data sources aligned. However, I found that the gateway did not want to make a custom Oauth API call I had created with Mquery to another SaaS service. 

     

    More to come as I check why the report will not use the one query. Chances are, if you are encountering this issue, there is a data source still enabled that the service does not like. 

    • v-ssriganesh's avatar
      v-ssriganesh
      Community Support
      9 months ago

      Hello eyelikedata2 
      We appreciate your efforts and are pleased to hear that your issue has been resolved.

      Thank you for sharing the update and insights this will certainly help other community members facing similar scenarios to troubleshoot and resolve their issues more efficiently.

      Best Regards,
      Ganesh Singamshetty.