On-premise Folder source and Json parsing doesn't refresh

[joanavb]

Hi,

I'm having some troubles refreshing a source of Folder type.

I get all files from folder. Then, I'm tring to parse a column in my table to JSON like that:

= Table.TransformColumns(#"Expanded Custom",{{"Column1", Json.Document}})

Everything works fine on PowerBI Desktop, however when I publish it to PowerBI online I keep getting the following error:

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

I start cutting my steps until I figure out this error only starts happening after I had the step above.

It seems like It's assumming my json document it's an online souce, which is not the case.

Do you have any solution for this?