Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Problem with automatic refresh - data source not supporting refresh

Hi, Wondering if someone could help me out on a problem with refreshing an uploaded report.   Error message: Unable to refresh the model (modelid=xxxx) because it references an unsupported data so...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi,

Thx for reply. I am hoping to be able to avoid doing this to fix my report as I need to rename a lot of fields and the fields have user friendly names (more or less). If it is so that your solution will fix it, then I feel that this is a bug.

I have filed the incident and have just recently received notification that the PowerBI team are now looking at my incident.

 

I will let you know if/when this is resolved.

 

 

menris's avatar
menris
Regular Visitor
10 years ago

Hi, 

Did this work for you ? I get the same issue. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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:

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9427188-odata-data-refresh-including-custom-power-query

     

    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.

     

    • alexchseng's avatar
      alexchseng
      Regular Visitor
      10 years ago

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hi,

        I think that any string concatintation in building source url will cause the refresh to fail.