Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Refresh unsupported source Alternatives

There's been a lot of threads about the dreaded "Unable to refresh the model because it references an unsupported data source" error. I have a query that uses a column in a table as a parameter to be ran inside an API call so Power BI service won't let me refresh.

I saw some suggestions to define a Relative Path in the URL but haven't been successful in making it work.

I'm wondering if I went through the Data Gateway if it might bypass the issue? What about if I built the model inside Azure Analysis Services?

Need Help

9 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Without more specific details it might be tough to fully understand if the data source would work with AAS

    Have you tried to connect to the data source via an ODBC connection?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The source is a data source with a web url api. 

      I have to call on it in a way similar to this "www.datasource.com/api/KPI1&KPI2&KPI3/Project=_______"

      I then have a list of project names as a separate source (sharepoint file) and a column is added to that table which runs the column ProjectName against inside that URL.

       

      Because of that query which requires dynamic parameters, when I refresh the data on Desktop, there's no problem. However when I publish and then run a refresh of the data set from the service, I get "Unable to refresh the model (id=10889070) because it references an unsupported data source."

      I know that function isn't possible with Power BI yet so I'm trying to see if running either a Data Gateway or AAS model would solve the issue.

       

      Regarding the ODBC connection, I don't think that applies here given the API call being a web url.

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        Which data source type are you using to connect to the data?
    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, we have learned a lot from it.

       

      Best regards,

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