dataset does not update after updating local file(parquet)

[dudeeee]

I am using local file path as a data source for the power bi dashboard. A parquet file is created by spark in overwrite mode and I am renaming the .parquet file being generated to a same name just so every time I do not have to change the data source path.
But there is no change in the table or dashboard after updating the parquet file.
I have also tried  deleting the folder and then overwriting the parquet file but still no changes.
Is there any way I can reflect the changes in dashboard from recently updated parquet file without changing the path in data source settings every time?

[Greg_Deckler]

@dudeeee So is this import mode or ? If import mode, do you have a data gateway and scheduled refresh? In import mode just updating the parquet file isn't going to modify the dataset unless a refresh occurs.

[dudeeee]

@Greg_Deckler This is a import mode. I am importing parquet file from my local storage.I have also set up a data gateway and scheduled refresh(every 1 hour).
I have tried refreshing manually, still no any changes are seen.

[Greg_Deckler]

@dudeeee That's super weird. Double-check that the query for the parquet file is not set to "Do not refresh". Right-click the query in Power Query Editor and check. If that isn't the case, maybe try renaming the file and do a refresh. Verify that it fails miserably. You could then maybe try putting an empty file in and try refresh, verify that no data is in the table. Etc.

[dudeeee]

@Greg_Deckler  renaming the file fixed the issue but after several update the same issue repeats and I have to rename the file again to make it work.
Is there any workaround to this?

[Greg_Deckler]

@dudeeee That's really, really bizarre. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".