Skip to main content
5 votes
Accepted

Embed Power BI report on SharePoint on-prem page, with SP List as data source and repeatable deployment?

Create a Power BI report that uses a SharePoint list as a data source Yes, you can get SharePoint List / Library data using OData Feed. SharePoint List as a direct data source connection For more ...
Mohamed El-Qassas MVP's user avatar
4 votes

What is best option for BI capabilities with SharePoint

Regarding If I install SSRS for SharePoint is it possible to achieve the same? Everywhere showing examples of external database like Adventure Works with SharePoint. But I have to build a report using ...
Mohamed El-Qassas MVP's user avatar
4 votes
Accepted

How to display a RDLC report to SharePoint 2013?

You can easily render your RDLC report in Report viewer control within a visual web part using visual studio then publish it to your SharePoint. Note: You may face issue related to the ...
Mohamed El-Qassas MVP's user avatar
3 votes

Creating a form to collect submissions and collate them into a report

I think this is possible without any REST API or JavaScript. I recently did something similar for the project highlight reports. I am sure it will work on 2010 but I did this on SharePoint online: ...
SharePointer's user avatar
  • 3,046
2 votes

what is the better way of develoment report in SharePoint 2013

There are a lot of reporting options that enable you to show Data from SharePoint List like Excel Service. Performance Point. SQL ServerReporting Service Create SSRS Report from SharePoint 2013 List ...
Mohamed El-Qassas MVP's user avatar
2 votes
Accepted

Report for Permissions Groups and Users

I developed something for a similar purpose. This is not exactly what you are looking for but It can be modified for your need. The code is tested and run without any error. What the code does: You ...
Ehsan Aliverdi's user avatar
1 vote
Accepted

Auditing SharePoint Online

With your description, I assume you want to check for keywords in documents according to pre-configured compliance policy. Just like Josh said, there shall be tools useful for you in Security & ...
Jerry_MSFT's user avatar
  • 4,230
1 vote

Auditing SharePoint Online

I would recommend looking into the Security and Compliance center. You can setup DLP and Retention polices to achieve this.
Josh McClanahan's user avatar
1 vote
Accepted

Report of all lists/libraries and documents where a particular keyword in available

Do you wish to generate a report on search result of certain keyword (old tool name)? If that is the scenario, here is a sample script for SharePoint on-premises: Add-PSSnapin Microsoft.SharePoint....
Chelsea_MSFT's user avatar
  • 4,542
1 vote
Accepted

Making a monthly Report of a sharepoint list

I don't have your exact schema, but for purposes of a prototype, I created a custom List named ChangeRequests from which the information will be gathered, and a Document Library named ChangeReports to ...
willman's user avatar
  • 3,724
1 vote

Extract/download SharePoint Online Search reports (Top Queries)

If you want to check the report manually, just click on the "Top Queries by Day" and the excel file will be downloaded automatically. You can find the search reports for each site collection via ...
Chelsea_MSFT's user avatar
  • 4,542
1 vote

Extract/download SharePoint Online Search reports (Top Queries)

Yes, if you are SharePoint Administrator. Open the SPO Admin center and navigate to Classic Feature from left menu. Now click on Open button for Search. This will take you the Search Administration ...
ThinkB4Code's user avatar
  • 2,970
1 vote
Accepted

Converting rows to columns in SharePoint Online List PowerBi Report

Fun question! You can use a Power Query feature named "Extract Values" to do this. In my example, I renamed the Title column in each list to Project_ID and Tasks_Title. When these are brought into ...
Mike Smith - MCT's user avatar
1 vote

Power BI Report Not Visible

Like Kasper said it is most likely a licensing issue, here is a link to the Power BI documentation that explains the licensing needed for sharing content in Power BI. Depending on what and how you are ...
Peter's user avatar
  • 11
1 vote

Power BI Report Not Visible

That sounds very much like a licensing issue. As I recall it you must have an E5 or a explicit Power BI license in order to view the Content. Try to assign such a license to one of your users to ...
Kasper Bo Larsen's user avatar
1 vote

whats difference between xml query with sql query?

I have no experience using XML query to create reports but a little using SQL query. So, from my unknowledge, I think the latter will be more effective and will have a better performance because of, ...
jaloplo's user avatar
  • 789
1 vote

Sharepoint Reporting Options

There are several report solutions based on your report complexity. Power Pivot SSRS for SharePoint Other front-end report libraries like Google chart
Lee's user avatar
  • 4,271
1 vote

Sharepoint Reporting Options

There is some basic built-in reporting at the Site and Site Collection levels. 1) Under Site Settings, Site Administration, Popularity Trends. 2) Site Settings, Site Collection Administration, ...
Josh G's user avatar
  • 11
1 vote
Accepted

Display SP Online list data as report in Excel Web Access Webpart

You can follow the steps below to add connection to a SP Online list and upload the excel file to a SP Online library. The data in the workbook will refresh automatically if the refresh control is ...
JoannaW_MSFT's user avatar
  • 6,621
1 vote

2013/online auditing reports (content viewing never works)

In order to do content viewing reports in SharePoint Online, you must use the Compliance Center. The viewing option is not available in the SharePoint audit reports like on prem. Another alternative ...
Eric Alexander's user avatar
1 vote

Tracking Views on Webparts (by user)

I am looking for both, entire page views and individual webpart views. Is there anyway to do this with the Out-of-the-Box platform? I'm not looking to spend additional money. You can do it for ...
Danny '365CSI' Engelman's user avatar
1 vote

Surveys answers reports

Combining the lists may be best achieved using SSIS. Once you have a single data source you can access the list from Excel and design a dashboard in Excel and deploy it to SharePoint. Alternatively ...
MikeAinOz's user avatar
  • 184
1 vote

SharePoint 2013 Workflow Reports

If you add Log Workflow History List and Set workflow status under Action , You will look at the detail of your workflow process.
Mathew's user avatar
  • 1,386
1 vote

SSRS Dataset valid, but data does not show up in generated reports

SSRS will only return items in the default view unless you create a filter parameter on the query itself. So if items are in folders or hidden from the default view your query wont pull them without ...
Amanda Matthews's user avatar
1 vote
Accepted

Document views reporting

Yes you can, by configuring audit settings for a site collection To configure audit settings do the following Go to root site. Site Settings > Site Collection Administration > Site collection audit ...
Mohamed El-Qassas MVP's user avatar
1 vote
Accepted

SP 2013 - Audit Report - Custom Report - Filters not working

You must be a site collection administrator, then you can do: Site Actions Site Settings Modify All Site Settings Site Collection Administration Site collection audit settings Cofigure Audit ...
Leo Smith's user avatar
1 vote

What is the license terms for Power BI reports for streaming data

Power BI service For Individuals Cost: Free Connect to cloud sources Simple dashboard sharing 1GB per user data capacity Daily scheduled data refresh 10K rows per hour streaming data Power BI ...
Kumar Reddy's user avatar
1 vote

Install Sharepoint Desginer 2007 on Windows Server 2008 R2

It is client products not the server. Why you want to install it on the windows Server 2008 R2. Simply install it on your client machine and connect to the site & generate the reports.
Waqas Sarwar MVP's user avatar
  • 56.9k
1 vote

create some dashboards/reports in sharepoint 2013 without having access to dashboard designer or central admin

report/dashboard that shows the team members availability In our farm we use list that have team members. Add a web part to page that shows this list and you are able to view the list of members ...
Richard Hughes's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible