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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tim_Lamb
New Member

Data gateway extension "cannot be added"

Hi,

 

I have built a report using the connector to Microsoft Azure Consumption Insights. I am able to refresh the data manually using Power Bi Desktop, but I am wanting to automate the data refresh. The "Scheduled Refresh" options are greyed out, and reading indicates that a data gateway should be used to enable a refresh, however the data gateway reports the extension cannot be added to the gateway.

 

Any assistance in resolving this (through scheduled refresh, gateway config, or anything else) to enable auto data refresh would be appreciated.

7 REPLIES 7
venal
Memorable Member
Memorable Member

@Tim_Lamb 

Please refer the below comments and link.

 

Business users can easily install these apps from Microsoft AppSource. Once installed, they can access via the web portal or their iOS, Android, or Windows devices. They can easily find and return to your content because it’s all in one place. They get all your updates automatically and you can control how frequently the data refreshes.

 

As per the above comments, hoping that you won't get that option.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

The report publishes as an app without a problem, except that as noted in my original post, "scheduled refresh" is greyed out. This reply unfortunately doesn't address my issue.

v-shex-msft
Community Support
Community Support

Hi @Tim_Lamb ,

According to your description, it seems like you are working with Microsoft Azure Consumption Insights(beta), right?
In my opinion, I'd like to suggest you use Azure Cost Management connector for Power BI to instead, azure consumption insight connector features have been including in it. (I don't think power bi will add gateway datasource support for beta connectors)

Connect to Azure Cost Management in Power BI Desktop 

In addition, you can also use web connector to get data from Azure Consumption Insights rest API. After you publish the report to power bi service side and update data credentials, it can be updated hourly without a gateway. (cloud datasource will update hourly)

Data refresh in Power BI#accessing-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.


@v-shex-msft wrote:

Hi @Tim_Lamb ,

According to your description, it seems like you are working with Microsoft Azure Consumption Insights(beta), right?


Correct.

 

I'd like to suggest you use Azure Cost Management connector... (I don't think power bi will add gateway datasource support for beta connectors)

That's in beta as for me as well.

Additionally, we are an EA user, and although the page linked to states it's available for EA users, using our EA number as the billing ID doesn't result in a connection - Power BI Desktop states "TenantId: Failed to discover tenantsBillingAccountId: Failed to discover tenants". Previous posts https://community.powerbi.com/t5/Desktop/Using-new-Azure-Cost-Management-Connector-issues-with-Accou... indicate that advice from Microsoft advised using the Microsoft Azure Consumption Insights connector.

 

@Tim_Lamb 

Thanks for the quick response.

Hope you query got clarified.

If you have any queries, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

No @venal, nothing is resolved for me at all.

@Tim_Lamb 

Please raise a support ticket to investigate.

Please share all the details in the support ticket, share the support ticket number here for reference.

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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