Forum Discussion
PowerBI data refresh from script returning #VALUE! error
Hi all, I'm currently trying to build a PA flow that refreshes an Excel sheet I have on SharePoint and refreshes the data from PowerBI connection - using the start of the flow to run an automate s...
Hi jonlake
Playing around a bit more I think Excel online doesn't like the data it's getting from PowerBI, I will give your advice a go though,
I tried entering the table name as an expression which tells me it's invalid, would you mind sharing the full expression you're using for this please.
Regards
Hi DanielPennacchia , my Flow is replacing a spreadsheet with a new one of the same name, which is why without forcing the table name via a variable the Flow would loose it's connection.
Then I can use the table_name variable in a Get items action.
I don't need to use an expression.