Forum Discussion
Problem with automatic refresh - data source not supporting refresh
Hi, I have been in extensive contact with support regarding this. The claim it is by design, see last answer below.
I found a post for idea which I voted upon, I do encourage you to vote on it to:
The last answer was:
Hi Thomas,
I have just received information from the product group and they have let me know that using dynamic queries within Power Bi Online which is the cloud, it will not be effective with using dynamic queries and instead will need static queries.
Within the cloud (Power BI Online) there are complexity limits, and with this it is effective to say that when accessing the data it is not able to analyze the parameters because they were too dynamic.
At this moment this is a “By Design” issue which makes it not possible at this moment in time.
Hi Anonymous, do you know if the "By Design" issue applies to parameters within Web.Contents as well?
I am parameterizing my query GetEntry with the following code:
let
Query1 = (ID as number) as table =>
let
Source = Csv.Document(Web.Contents("https://usyd.starrezhousing.com/starrezrest/services/getreport/2269.csv?EntryID=" & Number.ToText(ID)),[Delimiter=",", Columns=17, Encoding=1252, QuoteStyle=QuoteStyle.None]), ...
where GetEntry is used to populate a custom column. I have set up my parameterization as per the exampe given in http://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/.
When trying to refresh in Power BI service, I am also getting the error message "Unsupported data source".
Any ideas? Any assistance would be much appreciated. Thanks.
Hi,
I think that any string concatintation in building source url will cause the refresh to fail.
Hi, thanks for the prompt response. Do you happen to know if we could work around this using the Power BI gateway?