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_obrien13 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).