You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
I've tried replacing Workbook B with Powerquery but it won't refresh in the browser for some reason, I get an error message which, having done a bit of googling, suggests that it isn't supported yet.
A can't load to C as most people accessing C don't have permission to access A. B is a subset of A with sensitive stuff stripped out and a few lookups.
aggi
@Chalfie
Can you make a data flow in the power bi verse and feed it to the spreadsheet?