Initial SQL in PowerBi to load invalidate metadata

[Anonymous]

Hello, 

In Tableau I have always had the option to run an Initial SQL statement when using Cloudera Impala DB. Im facing some refresh issues with tables and need to perform the Invalidate Medtadata function in PowerBi so I can load my data. Has anyone ever been able to perform this function in PowerBi?

I have tried performing the function in advance options in change source but unfortunately that didnt work. 

Thank you, Craig. 

[amitchandak]

@Anonymous , Check this one from Guyinacube- https://www.youtube.com/watch?v=s_5Jk8_fHjA

[Anonymous]

Hi @amitchandak, unfortunately that didnt work. Do you know of any other workaround? Thanks.