Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mrvamsidhar
Helper I
Helper I

Microsoft Azure Consumption Insights with Power BI Issues

Hello All, I recently installed latest Power-BI desktop version on a frsh Windows 10 Machine. It seems Azure Enterprise connector doent exists any more as it has been depricated. I am having lot of PBIX files which reads consumption data from Azure Enterprise connector. Now that, it doesn;t exists any more I need to use new Microsoft Azure Consumption Insights connector. I am having lot of issues and seems loading data is way too slow. I posied all my issues here but no one responded yet. https://docs.microsoft.com/en-us/power-bi/desktop-connect-azure-consumption-insights. Below is code I used.

 

let 

 enrollmentNumber = "100", 

 optionalParameters = [ numberOfMonth = 6, dataType="DetailCharges" ], 

 data = MicrosoftAzureConsumptionInsights.Contents(enrollmentNumber, optionalParameters)

 in 

 data

 

1. It took 3 hours to load 2 Months of data. Any wrong in my calling?

2. So every time starting new month, do I need to update numberOfMonth value?

3. What are the other alternative connectors for for this? or How can i install old connector back?

 

 

 

4 REPLIES 4
v-shex-msft
Community Support
Community Support

HI @mrvamsidhar,

 

Since this connector is still in beta, current I also not found any methods to increase the processing performance.

Maybe you can try to send a feedback to azure team at below link:

New Power BI Connector for Azure Enterprise users

 

BTW, if connector not suitable for your requirement, you can also try to use odata connector with api to get data:

Announcing General Availability of Consumption and Charge APIs for Enterprise Azure customers

 

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thanks for you reply .Any chance that Microsoft Azure Enterprise connector can be included back? I see it is removed in December desktop version?

Hi @mrvamsidhar,

 

>>Any chance that Microsoft Azure Enterprise connector can be included back?

Since current power bi has the specific connector for these datasource, so I think the old connector will be removed soon.


You can still use previous version to use old connector, but I don't think it will be suitable.(if it has been removed at power bi desktop, service side will also update and remove the support)

 

Regard,

XIaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
mrvamsidhar
Helper I
Helper I

I reverted back to older version of power-bi desktop. It looks Microsoft Azure enterprise connector is removed from December desktop version.Unfortunately I cant use latest versions of BootStrapper. Any help on these highly appreciated.

 

1. How can i use Microsoft Azure enterprise connector in Dec desktop version?

2. How to use this Microsoft Azure Consumption Insights connector for the data which is more than 2 months..?

3. Using Microsoft Azure Consumption Insights Data is loading very slow. ( My enrollemnt has data since April. It ran for 4 hours and loaded only 2 months)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.