Forum Widgets
Latest Discussions
Bringing data to life using Power BI
Hi folks, Last weekend in London, I had the pleasure to present a session at SPS Events London "Bringing data to life using Power BI" - hopefully you will find the slides for your benefit! http://www.slideshare.net/techChirag/bringing-your-data-to-life-using-power-bi-sps-london-2016New feature: Create Power BI reports from tables in Excel files and CSV files
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.
refresh excel spreadsheets with on prem data connections
We have created a Sharepoint site on Office 365 however our data is all on prem. I need a way to be able to refresh Oracle and SQL server connections that are embedded into Excel spreadsheets. We already have Powerbi Gateway running as well as some users that have pro licenses. I'm wondering can this all go through the Powerbi gateway or does it require for all users to have a pro license in order to be able to refresh. I also have users that would like to be able to refresh from One Drive. Anyway please let me know your thoughts.
SharePoint Online - Embed Power BI Reports
Hi SPO Team, I have hundreds of power bi reports that I need to embed into the SharePoint online site. In Azure AD, four security groups have been created, so we can maintain the site access. Do I need to create a hundred separate SharePoint pages to include those reports? Also, is it necessary to create four separate SPO Teams sites based on the security groups, or can it be done in a single SPO Teams site, so the O365 users can access those reports? Thanks.
