Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@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.
@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.
@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.
@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?
@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".
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |