Unable to get last 24 months data using Azure cost managment.

[saiprathapdp]

Is there a way that we can connect Power BI and view the Cost Management in Power BI. we want to view the last 24months data  dashboard in Power Bi.

we tried below documentation but it is not working as expected.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

when we are fetching the data for last 24 months it was around 100 gb so the refresh time is taking too much time and when we have publised this dashboard in our Powerbi web app the scheduled refresh is getting failed.

we are usining premium workspace. recently we did manual refresh it affected all other workspaaces this dashboard blocked  11 hours of cpu time.

[Anonymous]

@saiprathapdp 

What do you mean not working as expected. The idea is you can connect the data to power bi desktop then create incremental refresh to refresh only last 24 month data. Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs

However for such large dataset, it is evitablely consume a lot of time. 

Some thing that help you understand large dataset. 
Large datasets in Power BI Premium - Power BI | Microsoft Docs
Solved: Best practices for Power BI and a large database? - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.