Forum Discussion
Solved
Refresh dashboard based on an excel source
On my local pc, I have: An operational data source (so far, I have try an Access Database, SQL Database and flat files) An Excel workbook connected on this source with Power Query with checking th...
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.
Here is more information on excel data refresh, let me know if need further help.
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-onedrive/