Forum Discussion
Updating the data in Excel-Other User
I created a PowerBI marketing dataset that I wanted to report on in Excel. I built the connection and the refreshes were working great on my end. I handed this over to our VP of marketing and th...
I then gave him Admin access to the On-premise data gatewayThat is unnecessary, and unrelated to your issue.
What are the error messages he sees?
There is no error message.
When I open the excel file (that has Power Platform PowerBI data), I am able to refresh and see values. When I send the excel file to him and he tries to refresh the data (Queries & Connections->*hitting refresh on the connection name*), his Pivot Tables that just had numeric data in it swtill keep the categorical rows show blank values for the rows.