Forum Discussion
dcadwallader
Helper I
Helper ICells Uploading without Values
Afternoon, I have a Power Bi report linked to an excel file. Upon updating refreshing, all values update and refresh as one would expect them to. Except for a series of columns titled wit...
Took a rather inelegant approach but have a solution in place.
I've simply added the same file as another extract on the file - it uploads the data fine on the second link and I got to keep all the calcs I'd put in the same link.
Probably going to cause me a headache down the road, linking to the same file twice in the same Bi Report but sure, that's future me's problem!
Cheers for the assistance guys!
KNP
Super User
Super UserThere's not enough information.
Can you share the M code for the query that connects to the excel file.
Go to 'Transform data' >> select the query on the left that connects to the Excel file >> go to 'Advanced editor' >> copy and paste that code back here (make sure to change any sensitive detail if there is any).