New 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.Can't see people's name when reporting a SharePoint List in a Power BI report
I created a column in my SharePoint List called "Category Manager", and populated with people's names in the company. After creating a Power BI report using this List as data source, I can only see numbers in the Category Manager column, not names. I tried different lists with different report, the numbers corresponding to same person aren't the same. So it looks like the numbers aren't from my company's employee database. What is it then? How do I get the report to show people's name other than a number? Thanks
Using calculated columns in sharepoint list in BI
Hi All, I have a list on sharepoint where i have a start date and an end date, i am using a calculated column to work out how many working days are between the two dates. I then have a hidden column that always has the value 30 in it. The idea is that i multiply the days by 30 to get a total value. This all works. I have 2 issues that i feel are related, one simple and one more complicated (i think). The first: I am wanting to have a total under the "amount to pay" column which holds the days * 30 - there is no option to add a total. Second: I am wanting to use power BI to create some dashboards for this data but there is no option to sum the values that have been created for "total to pay". It seems that this calculated value is not seen as a number that can have maths done to it. My question: How can use a column with a calculated number to get totals and use in power BI to graph?
Issue powerbi getting data from SharePoint Search
For a Client of mine i am trying to create a dashboard of all documents in a sitecollection. it was no problem with odata.feed. but problem with that was that i can not schedule it to refresh. i finally used web.contents. to refresh the data this works but now i have the XML data as it does not want to read the Json of SharePoint i am in a nested table issue. I worked a lot out and came down to this and here is my problem: Table.FromRows(List.Transform(element1, each List.Transform(_, each Record.FieldValues(_{1}){0} ))), the problem is that record.field values only returns 1 column instead of all my columns. does anybody have a solution so it shows all columns? I am new to the Powerbi stuff so have tried a lot but syntax incorrect or did not work :-( hope for some answers. Kr, Paul
Excel File with Data Model in SharePoint Online
I’ve been working to move a lot of my Excel reports to SharePoint from our file shares and have our users interact with them either directly through Excel online. A lot of my reports contain data that reside in the workbook’s data model (PowerPivot). It is my understanding the SharePoint online does support workbooks with a data model, and in fact, everything seems to work as expected in our test tenant. However; the exact same file does not work in production, and I get an error stating “This workbook contains external data connections or BI features that are not supported” when I attempt to filter the pivot table in anyway. The file that I'm testing with is a basic Excel file, that contains no external data connections, and the pivot table’s data source is a table in the data model. Here are some of the things I’ve tried and verified to this point (our test tenant is first-release enabled): Made sure my test tenant collection and production collection matched on enabled site collection features Same thing as above just for the individual site features In the test tenant, I confirmed that it worked with multiple accounts, some with the free Power BI license applied and others without In the production tenant, I tried with both an account that was synced through AAC and one that was created directly in the Office 365 admin interface. Same error message for both accounts. I’ve tried opening the file in Excel online in multiple sites in both test and production. The results are the same throughout, I can filter the pivot table in test but I can’t in production. Is there a SharePoint setting or a feature that needs to be enabled to allow advanced analytic featues such as a PowerPivot data models to function in Excel Online? Thanks.Transfer PowerBI Data to new user
Hey Guys/Gals Searched but could not find this asnwer. What happens when a user no longer works at the company? Can the PowerBI Dashboards/Data be transfed to a different user? Does this require a ticket with Microsoft? Has anyone ever done this or gone through this?
Employee timesheets in Sharepoint list
Dear all, I want to setup a sharepoint list where hundreds of employees will fill in simple events occuring during workday. For example: TaskName (fromDropDown), StartTime, EndTime. I expect there will be 100k rows after one year of filling this list. Can Sharepoint list support such large amount of data? Will I be able to retrieve data from the list using PowerBI? Web search provides links to documentation where some sources note that there is a limit of 5000 rows in SP list, other documentation provides that actual capacity is 30 million rows.
