Forum Discussion
Refresh dashboard based on an excel source
I solved the problem.
Can't find the post that gave me the indication, but the solution is here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/
Rather than use the "Get Data" in PB Desktop, uses the File / Import command.
Thanks Perry.
So far I work locally, without publishing the Power BI Document.
I'd already looked at your link as well as this one:
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-local-drive/
However, I can't get any new data in my dashboard until I manually refresh the Excel file.
Any idea about if it it should work or not locally?
Thanks!
I solved the problem.
Can't find the post that gave me the indication, but the solution is here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/
Rather than use the "Get Data" in PB Desktop, uses the File / Import command.