Latest blogs
- How to connect Power BI Dataflows to ExcelPower BI dataflows (PBI dataflows) is a powerful data prep tool for you to transform data and reuse them in other places downstream. At the same time, while Excel is very popular among business users, there is still, at the time of writing this post, no out-of-the-box connector to import PBI dataflows to Excel. This … Continue reading How to connect Power BI Dataflows to Excel
- The Excel Connectors in Power BILike it or not, Excel is one of the most popular data sources to build Power BI reports. Surprisingly, except for when you want to connect to an Excel file that is located on your local laptop or a shared network drive, there is no easy way for users to connect to an Excel file … Continue reading The Excel Connectors in Power BI
- Power BI dataflows to store historical dataPower BI dataflows is a nice capability of Power BI. It’s actually not a new Microsoft product. If you use Excel and Power BI long enough, there is a big chance that you’ve already used Power Query at least once. And basically, to keep things simple, it’s just Power Query, but you have to edit … Continue reading Power BI dataflows to store historical data
Data Azure 