Jenny,
HS doesn’t integrate with power BI and I’m not that good that I can use API’s, so a direct export is what I’ve been doing since I’m using it… export in .CSV , replace the old file and then refresh the data from the BI… not necessary the most automated, but worked perfectly until this little issue…
Mike