search

microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
282 stars 90 forks source link

PowerBI Report stays blank #996

Closed guidovanbrakel closed 15 hours ago

guidovanbrakel commented 3 days ago

I have some issues with the PowerBI report from AzureOptimization, I have connected it to the Azure SQL Database which is created by the AzureOptimization. image

Is there any detailed documentation how to fix this?

helderpinto commented 2 days ago

Hi, @guidovanbrakel! Thanks for reporting this issue.

As a start, please check the FAQ, particularly the "Why are my Recommendations workbook and Power BI report still empty after deploying AOE?" question.

Can you also check whether the Recommendations workbook is also empty?

guidovanbrakel commented 2 days ago

I have tried but still no data. I waited two days

guidovanbrakel commented 2 days ago

And @helderpinto the recommendations report is not empty

helderpinto commented 2 days ago

@guidovanbrakel, if the Recommendations workbook is not empty, this means that everything should be fine upstream, and the only problem might be with the Ingest-RecommendationsToSQLServer runbook in the AOE Azure automation account. Can you please check what was the result/output of its latest job?

guidovanbrakel commented 2 days ago

@helderpinto the Ingest-RecommedationsToSqlServer has a status completed. image

In PowerBI it keeps connecting to your own Azure SQL Database, and I can't get rid of it image

guidovanbrakel commented 2 days ago

@helderpinto I got it working finally I was able to delete your data source

helderpinto commented 1 day ago

Yes, you need to change the data source and refresh the report, as documented here. Let me know if anything else is needed and if we can close this issue.

guidovanbrakel commented 21 hours ago

@helderpinto I got it working finally I was able to delete your data source.

Now all tabs are loading but the Cost Page. Do I have to connect the Azure Cost Management Connector in PowerBI for that?

helderpinto commented 16 hours ago

No, the Azure Cost Management Connector isn't needed. You should see in the Power BI Cost page the same cost recommendations you are able to see in the Recommendations workbook. Is there any difference between the amount of recommendations in Power BI and in the workbook?

guidovanbrakel commented 16 hours ago

No, the Azure Cost Management Connector isn't needed. You should see in the Power BI Cost page the same cost recommendations you are able to see in the Recommendations workbook. Is there any difference between the amount of recommendations in Power BI and in the workbook?

At the moment there are no cost recommendations, also not in advisor

helderpinto commented 15 hours ago

This is an expected behavior, then. Your environment seems to be currently cost optimized, as far as both Azure Advisor and AOE can observe. If you installed recently AOE, allow it a couple weeks, because some recommendations are surfaced after enough historical data has been collected.

I am closing this issue as resolved.