cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hodossy Regular Visitor
Regular Visitor

How to configure autorefresh for web content?

I want to schedule an auto refresh for my report in the PBI Service, which contains web api calls to our corporate JIRA instance, and a pure Power Query M/DAX calendar table. I get the following error:

You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

 However, I was able to add the web data source to my gateway, and it confirmed a live connection. What shall I do in this case?

1 ACCEPTED SOLUTION

Accepted Solutions
hodossy Regular Visitor
Regular Visitor

Re: How to configure autorefresh for web content?

It turned out that it is some known weakness of PBI, that it does not recognize the data source when it is used via a function parameter. See more at

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

or the discussion under:

 

http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-...

 

P.S: Please disregard my other reply, as it is out of topic.

3 REPLIES 3
Community Support Team
Community Support Team

Re: How to configure autorefresh for web content?

HI @hodossy,

 

What are you configuration for this datasource?

Please refer to below link and share more detailed information to help use clearly your issue.

Troubleshooting the on-premises data gateway

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
hodossy Regular Visitor
Regular Visitor

Re: How to configure autorefresh for web content?

Hello

 

As described in the link, I have reinstalled the gateway, so it is up to date now. I have have a postgresql database connection configured in the PBI Service and it is marked Connected. However, when I want to schedule a refresh for a data set, which uses the same data source, it says that

 

You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.

Please note that I have installed the On-premises data gateway as enterprise, not the personal mode.

 

I also have another data table in that set, which is generated by PowerBI with Power Query M and I did not configure any data source for that in the gateway.

 

Br,

Szabolcs

hodossy Regular Visitor
Regular Visitor

Re: How to configure autorefresh for web content?

It turned out that it is some known weakness of PBI, that it does not recognize the data source when it is used via a function parameter. See more at

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

or the discussion under:

 

http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-...

 

P.S: Please disregard my other reply, as it is out of topic.