cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joanavb Frequent Visitor
Frequent Visitor

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

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?