Jun 07 2018 07:38 AM
We are excited to announce a new feature that will make it very easy to start visualizing data in Excel tables and CSV files using Power BI. When you go to your OneDrive for Business, or any SharePoint document library, you will be able to select an Excel file that contains tables, or a CSV file, and click on "Open in Power BI" in the command bar.
Clicking this command will open a new tab in your browser and take you to Power BI. A Power BI dataset will be automatically created based on your Excel or CSV file and you can start creating a report to visualize your data. Note that this requires that your data is formatted as tables in Excel.
The dataset created in Power BI will be automatically refreshed when you make changes to the original Excel or CSV file. This means you can continue to make changes to the file in OneDrive or SharePoint, and any associated dataset, reports and dashboards will be automatically updated with the latest data. Refresh happens every hour, but if you want to see changes right away you can start a refresh in Power BI by clicking the ellipses beside the dataset, then clicking the refresh now icon.
The dataset will be added to your group's workspace if the SharePoint site you started from has a group association (like a modern team site). Otherwise, it will be added to your personal workspace. Any user can create a report based on an Excel or CSV file in Power BI for free, but to share the report with others you will need a Power BI Pro license. If the user creating the dataset already has a Power BI Pro license, they will be able to take full advantage of it.
If you are a first time Power BI user, you may find this page helpful for an introduction.
We will be gradually rolling this feature out to customers over the coming weeks and months, and as always listen to your feedback. We will make updates to this post as the feature rollout expands through our release process.
Jun 12 2018 01:34 AM
Jul 02 2018 08:08 AM
This feature is available for some of our customers now who already use Power BI. We will start rolling it out generally over the coming weeks and months!
Jul 10 2018 08:21 AM
Hi,
Are those customers (tenants) preferred that already use Power BI today? Would love to test this feature..
best regards,
Wolfgang
Jul 10 2018 03:01 PM
Jul 16 2018 03:20 PM
Hi Richard, I'm a PM from the Power BI team. Would like to learn more about the issue you faced. Can you please explain the scenario in detail? - Thanks, Soumya
Nov 05 2018 09:40 AM
Can we get the promised update on the roll out progress of this, please?
Nov 05 2018 10:31 AM
Yes, that's 5 months from the announcement and nothing happened.
Feb 12 2019 03:58 PM
Just wondering if there is a definitive timeline for this - keenly waiting for it to roll out :)
Feb 13 2019 09:40 AM