Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Can't schedule a refresh for Web data matching a function with a list of parameters

Hello,

 

Recently started using Power BI and while getting into some more advanced M stuff I'm failing to schedule a refresh from the cloud with the error message:

 

You cannot schedule refresh for this dataset because it gets data from sources that currently don't support refresh. Learn Moreabout data sources that currently support refresh.

 

What I did was:

1) Get a table from a web source using Power BI designer (an html page)

2) Tidied up the columns

3) Turn a part of the url into a parameter thus creating a function to get the data I need.

4) Create a blank query that then generates a list of those url parts (hardcoded)

5) Turned the list into a table

6) Added a custom column that retrieved data for the parameter using the function.

7) Expanded all the necessary columns.

8) Created a report using the designer (the refresh works there)

9) Uploaded via Get Data and the schedule fails.

 

What could be the problem? Does it not understand that I'm essentially using a web source?

 

Any help would be appreciated.

5 Replies