Query Folding on Folder Source - JSON files

Anonymous · ‎11-10-2022

Hi PBI Devs!

Is it possible for me to set incremental refresh on Local folder source containg JSON files without the native query enabled?
I can manually publish using desktop but refresh fails in PBI service.

Note: This is the refresh error:

Thanks!

ImkeF · ‎11-10-2022

Hi @Anonymous ,
this doesn't work out of the box.
You can either go via datamarts: How to use Incremental Refresh on ANY data source! – PBI Guy (pbi-guy.com)
or just dataflows: Incremental Refresh For Cloud Data Sources in Power BI Service (Pro) | Excel Inside (excel-inside.pro)

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Query Folding on Folder Source - JSON files

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024