Refreshing OneDrive-based excel data source in Power BI

Excel is still commonly used to store some static data, which often needs to be analyzed as part of Power BI reports. There some guidelines about how to connect Excel with Power BI web app. But what if we need to have it in Power BI Desktop?

Also, Power BI is a great tool which allow user to mix different data sources in single report. So, our goal is to configure refresh for the workbook created in Power BI Desktop with mixed data sources:  Excel file stored in OneDrive and traditional RDBMS source.

Continue reading