Forum Discussion
PowerBI Desktop Connection to Excel - Refresh Not Working
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 So after you update the data in Excel and refresh the Power BI desktop report, you can see the updates reflected in the data view of the Power BI desktop report? Are you using a separate date table within your data model? The only limitation I can think of here with the free version is the maximum number of GB, which is 1 or 2 GB. I don't imagine your report is that large, correct?
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.
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?
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?
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.