Help with API refresh on Power BI Service

Anonymous — Sat, 10 Oct 2020 02:53:08 GMT

Hi All,

I've been given a Power BI file with an API connector that calls a JSON file. The problem is when I upload the file to Power BI Service it won't let me refresh. I get this error:

How can I update the code to make sure it refreshes on Power BI service?

Thanks in advance!

Here's the code for the data source:

And the code in a text format:

let BaseUrl = "URL", Token = "TOKEN", GetJson = (Url) => let Options = [Headers=[ #"Authorization" = "Bearer " & Token ]], RawData = Web.Contents(Url, Options), Json = Json.Document(RawData) in Json, GetPage = (Index) => let Url = BaseUrl & "&page=" & Text.From(Index), Json = GetJson(Url), Value = Json in Value, PageCount = 20, PageIndices = { 1 .. PageCount }, Pages = List.Transform(PageIndices, each GetPage(_)), Entities = List.Union(Pages), #"Converted to Table" = Table.FromList(Entities, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

Re: Help with API refresh on Power BI Service

lbendlin — Sat, 10 Oct 2020 18:07:54 GMT

Your base URL may be too detailed. Follow this guidance to make it more generic

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

topic Help with API refresh on Power BI Service in Developer

Help with API refresh on Power BI Service

Re: Help with API refresh on Power BI Service