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!
jennratten
Super User
Super UserHello - FYI, scenarios like this are often caused by explicitly naming column names where it may not be necessary. I recommend you delete the #"Changed Types" step that Power Query added automatically and instead, assign the column types later on in the script.