Forum Widgets
Latest Discussions
Excel Services and On-Premises SQL Data
I am looking to have an active data connection from an Excel file in Excel Services on SharePointOnline (O365)that has a data connection to an on-premises SQL database. Need to be able to have data refresh work like it does with SharePoint on-premises. The DMG used for PowerBI doesn't appear to have connections for Excel. I am looking for "out-of-the-box" solution (or close to one). Is this still a supported scenario? It was widely used in on-premises SharePoint system as is currently blocking some key Office 365 adoption. Thanks!
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
A new Tag Filter for a Sites Search shows the Term's Unique Id, not the Term's Text name
Hello, I have done a lot of searching on this issue but not having much luck, hoping that somebody out there can point me in the right direction. I have done the following on a SharePoint site; Navigated to the configure search settings (Microsoft Search) via the site's settings From there I went to "Verticals" and selected "All" Then "Edit" and "Filters" I then selected the filter where the property = tags and saved This property uses the Terms from my doc library column = Managed Metadata and I named the filter as "Knowledge tags" The Issue The filter shows in the Sites Vertical = "All", which is great and as expected However instead of showing the term, it is showing the terms unique identified. I can only see the term when I hover over the Id See image Does anyone know if; 1. This can be changed to display the term text name and not the unique ID - which is a poor user experience and.. 2. If so, how do I fix this? I will be very grateful for any support. Many thanks, CourtneyNew 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.
Basic Analytics Question
Firstly, we'd like to avoid having to pay thousands of dollars per month to get everyone a Power BI licenses as everyone is already licensed with Business Standard, which includes SharePoint, Teams, Yammer etc, so we'd like to use what we have. Does SharePoint have ANY analytics other than the Usage Reports which are way too summarized? For example, our marketing dept would like to send out weekly newsletters either via email, Yammer Announcement with a link to a file which will be stored in SharePoint. I know we can see in Yammer how many users have "seen" the post yet how can we verify how many users have VIEWED the file from the link? If we add a link to a SharePoint site for example, can we see its usage (just that file)? What do others do when we need to analyze what users are doing with our correspondences, shares, posts (how ever we do it)?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?
how do i get last week sale for same period when I don't have the dates column
Hi there, I have data in this format: One column has the year. The second column has the period (12 periods in a year, but they are not the same as months, as they start on different dates). The third column has the week number (every period has at least 4 weeks; some of them have 5 weeks). I'm trying to create filters for the data: The first filter is the year, followed by the period and then the week. The data I get after applying these filters is correct. Now, I've tried using the 'sameperiodlastyear' function to retrieve data from the previous year with the same period and week, but it's not working. Can you please help me? Thanks.
