Forum Discussion

dcadwallader's avatar
dcadwallader
Helper I
4 years ago
Solved

Cells 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...
Need Help
  • dcadwallader's avatar
    dcadwallader
    4 years ago

    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!

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, dcadwallader 

 

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

 

It makes it easier to give you a solution.

  1. Sample (dummy dataset) data as text, use the table tool in the editing bar
  2. Expected output from sample data
  3. Explanation in words of how to get from 1. to 2.

 

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.