cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Azure Cost Management connector - scheduled refresh not working

Hi All,

 

I've recently swtiched over from the Azure Consumption Insights connector to the newer Azure Cost Management connector.

 

The data in the new connector looks great, and I can successfully refresh when using Power BI desktop. However I'm getting the following error when publishing on https://app.powerbi.com/:

Azure Cost Management refresh error.jpg

 

 

 

 

 

 

 

 

The query for each of those data sources starts with something like this:

 

 

let
    Source = AzureCostManagement.Tables("Enrollment Number", Text.From(EnrollmentNumber), NumberOfMonths, []),
    usagedetails = Source{[Key="usagedetails"]}[Data],

 

 

 

Any ideas how to get this working?

 

 

 

 

 

10 REPLIES 10
chizuml_ds
Regular Visitor

I'm not able to schedule a refresh for Cost Mgmt either.  See grey-out.

chizuml_ds_0-1652137122921.png

THIS ONLY HAPPENS AFTER PUBLISHING TO THE PREMIUM CAPACITY WORKSPACE.



lbendlin
Super User
Super User

Are all refreshes failing? Meaning when you upload from desktop (after refreshing there) will it show the updated data? Does the REST API refresh call work? Does the onDemand refresh on the service work?

Anonymous
Not applicable

Thanks for the quick reply.

 


@lbendlin wrote:

Are all refreshes failing? Meaning when you upload from desktop (after refreshing there) will it show the updated data? 


Refresh in Desktop works fine. When I publish, the data is still correct as of the last Desktop refresh.

 


@lbendlin wrote:

Does the REST API refresh call work? 


I haven't tried this to be honest. I'm just using the out-of-the-box connector.

 


@lbendlin wrote:

Does the onDemand refresh on the service work?


No it doesn't work, I get the same error:

Data source error Unable to refresh the model (id=3931661) because it references an unsupported data source.

 

 

 

Thanks,
Ben

I guess you have seen the post where someone found out that the connector did not install on the gateway because of proxy conflicts. Not sure if that's related. I don't think you really need a gateway for that connector.

 

I'd think the API refesh will fail too as it uses the service mashup engine too.

Anonymous
Not applicable

Just to clarify - I'm not using a gateway at all.

 

Any ideas how I can get this working?

 

I can try with the REST API I guess. That would be (for example) just using this right?

https://docs.microsoft.com/en-us/rest/api/consumption/usagedetails/list

Hi @Anonymous,

According to your error message, it seems like some of datasource not refreshing properly. (schedule refresh settings required you to configure all the data sources of your report )

Data refresh in Power BI 

Have you merged different types of datasources in your report?  If you merged both online and on-premise data sources, you need to turn on the option to use gateway managed cloud data source:

Merge or append on-premises and cloud data sources 
Regards,

Xiaoxin Sheng

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

Hi @v-shex-msft ,

 

Thanks for the info. I'm not using any on-prem data sources. I'm using online only including:

- Azure Cost Management Power BI connector

- An Azure Cosmos DB

 

I'm not seeing any issue with the Cosmos DB, only the data sources from Azure Cost Management Power BI connector.

Anonymous
Not applicable

Hi @v-shex-msft ,

 

Any idea how we can use the Azure Cost Management Power BI connector and refresh data on https://app.powerbi.com/ ?

 

 

Thanks,

Ben

HI @Anonymous,

Any advanced operation between these data sources? (merge, combine, reference, invoke custom functions..)

It seems like you are using a particular function 'AzureCostManagement.Tables' in your queries which may not available on the power bi service side or mixed with other connectors. (it did not exist in power query access data functions)

16.png

In addition, you can also try to use other connectors to get data from azure cost management. (e.g. web connector with rest API)

Azure Cost Management 

Regards,

Xiaoxin Sheng

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

Hi @v-shex-msft ,

 

I am using Table.NestedJoin in some cases. However the issue occurs in tables without that function too.

 

I'm not using merge, combine, reference or any custom functions in this report.

 

I will try with the Azure Cost Management REST API, however this will increase the complexity of the report.

 

I would have thought using the Microsoft-provided connector should work, and that the connectors functions (such as AzureCostManagement.Tables) would be supported by the Power BI service.

 

Do you know if there are plans to support the connector? Or is there a function I can use other than AzureCostManagement.Tables to get data from the connector?

 

 

 

 

 

 

 

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors