Forum Discussion
david_obrien1
3 years agoNew Member
Refresh published report in service
Hi all, I have a report created in Power BI Desktop that loads a few JSON files from a private github repo. That all works well. However, I'd love to somehow have this report refresh automatica...
ImkeF
Community Champion
3 years agoHi david_obrien1 ,
there is a workaround that might work for you:
(1) Workaround - Power BI - Web content refresh - Data Gateway | LinkedIn
david_obrien1
3 years agoNew Member
That doesn't seem to help.
Here's the query I'm already using.
let
json = Json.Document(Web.Contents("https://raw.githubusercontent.com/davidobrien1985/repoName/file.json")),
#"Converted to Table" = Table.FromRecords({json}),
#"Expanded history" = Table.ExpandListColumn(#"Converted to Table", "history"),
#"Expanded history1" = Table.ExpandRecordColumn(#"Expanded history", "history", {"numberOfRoles", "numberOfOperations", "date"}, {"history.numberOfRoles", "history.numberOfOperations", "history.date"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded history1",{{"numberOfRoles", Int64.Type}, {"numberOfOperations", Int64.Type}, {"history.numberOfRoles", Int64.Type}, {"history.numberOfOperations", Int64.Type}, {"history.date", type date}})
in
#"Changed Type"
The repo that hosts the json file is private, but it's on the internet. The query works. The only thing it doesn't want to do is automatically refresh (on a schedule).