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 rep...
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. 

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.