Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Firends,
I had created Power bi using Web.Contents(). also I implemented paging using Web.Contents() and it's working fine in Power Bi Desktop and Web.
But I am not able set Schedule Refresh on Powerbi Web. Getting following error.
You can't schedule refresh for this dataset because one or more sources currently don't support refresh.
Regrds,
Sandeep
Hi @devssolution,
Please vote the following idea that make functions refreshable when the data source is a parameter of the function.
https://ideas.powerbi.com/forums/265200-power-bi/suggestions/9312540-make-functions-refreshable-when...
Thanks,
Lydia Zhang
Are you using a function for the pagination?
let url="*****/global_fact/_search", GetJson = Web.Contents(url,[Query=[scroll="5m",size="1000"]]), FormatAsJson = Json.Document(GetJson), // Gets token from the Json response pageId= "", hints= FormatAsJson[hits], pageNumber = Int32.From(hints[total]/1000), FnGetOnePage = (url1,pageId,page,param) as record => let query= if page=0 then [Query=[scroll="5m",size="1000"]] else [Query=[scroll="30s",scroll_id=Text.From(pageId)]], Source = Json.Document(Web.Contents(url1,query)), data = try Source[hits] otherwise null, pageId= try Source[_scroll_id] otherwise pageId, next = "*****/_search/scroll", res = [Data=data, Next=next , PageId = pageId,Param=[Query=[scroll_id=pageId,scroll="3"&Text.From(page)&"s"]]] in res, GeneratedList = List.Generate( ()=>[i=0, res = FnGetOnePage(url,"",i,[Query=[scroll="5m",size="1000"]])], each [i]<pageNumber and [res][Data]<>null, each [i=[i]+1, res = FnGetOnePage([res][Next],[res][PageId],i,[Query=[scroll="5m",size="1000"]])], each [res][Data]) in GeneratedList
From my understanding, if you use a function to obtain your data (in your code, it is the FnGetOnePage part), a refresh isn't supported in the service. Maybe this is outdated: http://excelando.co.il/en/power-bi-cant-schedule-refresh-when-source-is-multiple-excel-files/
Maybe some of our experts @ImkeF, @Greg_Deckler, @MattAllington, @Vvelarde can chime in (sorry if I left out any other experts!)
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |