Forum Discussion

poweruser4's avatar
poweruser4
New Member
2 years ago
Solved

PowerBI Desktop Connection to Excel - Refresh Not Working

I made a PowerBI report that connects to an Excel file on my local computer where I am making the report, but when I select 'Refresh' nothing happens. I get no errors and despite my data in Excel bei...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    poweruser4  Then not all the data is being captured, it's being filtered out, or the source location isn't correct. Those are the only logical explanations. Can you share the .pbix with redacted information?

poweruser4's avatar
poweruser4
New Member
2 years ago

Anonymous  No, when I go to the table view I don't see the refreshed data included there. My report is not big at all. No more than 4,000 rows of data. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

poweruser4  Then not all the data is being captured, it's being filtered out, or the source location isn't correct. Those are the only logical explanations. Can you share the .pbix with redacted information?

  • poweruser4's avatar
    poweruser4
    New Member
    2 years ago

    Anonymous I made a redacted version but I do not see an option to upload a file. How do you suggest I share this with you?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      poweruser4  I sent you a PM where you can send it, or you can share a link here to the .pbix on OneDrive etc. Make sure to link to the redacted source data too.