SharePoint BI topics https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/bd-p/SharePointBI SharePoint BI topics Sat, 23 Oct 2021 15:14:10 GMT SharePointBI 2021-10-23T15:14:10Z building reports for SharePoint lists inside Power BI, are my reports achievable https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/building-reports-for-sharepoint-lists-inside-power-bi-are-my/m-p/2877157#M231 <P>I want to build 3 charts and show them inside my SharePoint online modern page, the charts are as follow:-<BR /><BR /></P><DIV class="">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="charts2types.png" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/319464iE295938BDEA6B3AA/image-size/large?v=v2&amp;px=999" role="button" title="charts2types.png" alt="charts2types.png" /></span></P><P>&nbsp;</P><P>1) First chart is to group the items from a single SharePoint list by Created date, and show the total number of items based on the day of the week (Mon till Sun). So for example, if today is Wednesday, it should show the results from past Tuesday till today (Wednesday)</P><P>2) Second chart is to show the total number of items from 4 different lists and show the percentage inside a pie chart</P><P>3) Third chart is to group the items from a single SharePoint list by Created date, and show the total number of items based on the month from the first month of the year till current month.</P><P>So can i build these charts using Power Bi and embed them inside SharePoint modern page?</P><P>Thanks</P> Sat, 23 Oct 2021 14:38:28 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/building-reports-for-sharepoint-lists-inside-power-bi-are-my/m-p/2877157#M231 john john 2021-10-23T14:38:28Z SharePoint get all Site Views (not only Top 10 by standard Site-Analytics) https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-get-all-site-views-not-only-top-10-by-standard-site/m-p/2797905#M230 <P>Hey everyone,</P><P>&nbsp;</P><P>I want to get all the SharePoint Intranet statistics that are possible.</P><P>Unfortunately the "standard" Site-Analystics doesn't help, because they only list the top 10 elements (e.g. Top 10 Sites, Top 10 Site Pages, Top 10 Document)<BR /><BR />Is there a way to get ALL view numbers of ALL Elements?&nbsp;<BR />In the specific case I want to see the less seen Sites and the less seen Documents (so my colleques can improve these sites/ documents to get more views and relevance in the intranet)<BR /><BR />Thank you very much in advance ;)</img>&nbsp;<BR /><BR />P.S: The audit log reports (in the SPO Site Settings) doesn't work anymore... So there must be a way in the compliance center or via PowerShell...</P> Thu, 30 Sep 2021 06:08:19 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-get-all-site-views-not-only-top-10-by-standard-site/m-p/2797905#M230 SPONoob 2021-09-30T06:08:19Z Can't see people's name when reporting a SharePoint List in a Power BI report https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/can-t-see-people-s-name-when-reporting-a-sharepoint-list-in-a/m-p/2700930#M229 <P>I created a column in my SharePoint List called "Category Manager", and populated with people's names in the company.&nbsp; After creating a Power BI report using this List as data source, I can only see numbers in the Category Manager column, not names.&nbsp;&nbsp;</P><P>I tried different lists with different report, the numbers corresponding to same person aren't the same.&nbsp; So it looks like the numbers aren't from my company's employee database.&nbsp;</P><P>What is it then?&nbsp; How do I get the report to show people's name other than a number?&nbsp;</P><P>Thanks&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StuDaMan_0-1630379010748.png" style="width: 102px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/306851iF441E7FC33956E61/image-dimensions/102x291?v=v2" width="102" height="291" role="button" title="StuDaMan_0-1630379010748.png" alt="StuDaMan_0-1630379010748.png" /></span></P><P>&nbsp;</P> Tue, 31 Aug 2021 03:04:43 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/can-t-see-people-s-name-when-reporting-a-sharepoint-list-in-a/m-p/2700930#M229 StuDaMan 2021-08-31T03:04:43Z Visualise a list via power BI https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/visualise-a-list-via-power-bi/m-p/2614109#M228 <P>Hello All,</P><P>&nbsp;</P><P>Hope someone can advise.</P><P>The new visualise a list feature is a nice addition but when it builds in power BI i am unable to edit.</P><P>There is no edit button on the ribbon for me.</P><P>&nbsp;</P><P>I do have a Power BI pro license.&nbsp;</P><P>I noticed in the bottom right pane, that its says this feature is in preview.</P><P>Would this be the reason why i can't edit?</P><P>&nbsp;</P><P>thank you</P> Thu, 05 Aug 2021 08:39:23 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/visualise-a-list-via-power-bi/m-p/2614109#M228 DairyG1 2021-08-05T08:39:23Z Migration Onpremise PowerBI report to SPO/Cloud? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/migration-onpremise-powerbi-report-to-spo-cloud/m-p/2316378#M226 <P>We are migrating some of our SharePoint 2016 onpremise report to SPO/Cloud.&nbsp;</P><P>&nbsp;</P><P>How do we migrate OnPremise PowerBI reports which is hosted onpremise PowerBI Server? What Pre-requisite required and what processes need following?</P><P>&nbsp;</P><P>Avian</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 03 May 2021 07:47:17 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/migration-onpremise-powerbi-report-to-spo-cloud/m-p/2316378#M226 Avian 1 2021-05-03T07:47:17Z How many members have viewed a file in a SharePoint document library. https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-many-members-have-viewed-a-file-in-a-sharepoint-document/m-p/2201869#M222 <P>Hello Community, I would like to make a continuous evaluation of my files in SharePoint. For this purpose I am looking for the information how many people have viewed a certain file. How can I get this information through the SharePoint API?<BR />Unfortunately, I can't find the column that contains this information. Maybe this info is also stored in another system list?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saintenr_0-1615449010875.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/262748i1E9D00FBE23A5FDA/image-size/medium?v=v2&amp;px=400" role="button" title="Saintenr_0-1615449010875.png" alt="Saintenr_0-1615449010875.png" /></span></P><P>Thanks for your response<BR />Saintenr</P> Thu, 11 Mar 2021 07:51:01 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-many-members-have-viewed-a-file-in-a-sharepoint-document/m-p/2201869#M222 Saintenr 2021-03-11T07:51:01Z Query Confirmation Messages - Data Notice https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/query-confirmation-messages-data-notice/m-p/2192816#M221 <DIV class="lia-message-subject-wrapper lia-component-subject lia-component-message-view-widget-subject-with-options">Hello everyone,</DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><P>I have a split Access DB: the Back-end part on linked tables in SharePoint, the Front-end part on Windows PC.</P><P>When I work with the DB, Query Confirmation messages are displayed: updating, modification, deletion, queuing.</P><P>I went to Access Options -&gt; Client Settings -&gt; in the confirmation paragraph I removed the "flags" on all three items: Edit record - Delete documents - Command query.</P><P>In fact these settings work very well when using the DB locally (not split ...). But when I split it into SharePoint it seems to ignore the "Client Settings Menu" settings.</P><P><STRONG>Is there a way even from SharePoint, to disable Query Confirmation messages?</STRONG></P><P>Thanks for your help.</P></DIV></DIV></DIV></DIV> Mon, 08 Mar 2021 10:02:20 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/query-confirmation-messages-data-notice/m-p/2192816#M221 MAC_8128 2021-03-08T10:02:20Z Basic Analytics Question https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/basic-analytics-question/m-p/2111500#M215 <P>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.</P><P>&nbsp;</P><P>Does SharePoint have ANY analytics other than the Usage Reports which are way too summarized?&nbsp; 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.</P><P>&nbsp;</P><P>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?&nbsp; If we add a link to a SharePoint site for example, can we see its usage (just that file)?&nbsp;&nbsp;</P><P>&nbsp;</P><P>What do others do when we need to analyze what users are doing with our correspondences, shares, posts (how ever we do it)?</P> Tue, 02 Feb 2021 17:35:11 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/basic-analytics-question/m-p/2111500#M215 Mercedes Green 2021-02-02T17:35:11Z Employee timesheets in Sharepoint list https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/employee-timesheets-in-sharepoint-list/m-p/2028476#M213 <P>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.</P><P>&nbsp;</P><P>I expect there will be 100k rows after one year of filling this list.</P><P>&nbsp;</P><P>Can Sharepoint list support such large amount of data?</P><P>Will I be able to retrieve data from the list using PowerBI?</P><P>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.</P> Mon, 04 Jan 2021 07:42:46 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/employee-timesheets-in-sharepoint-list/m-p/2028476#M213 ArturasF 2021-01-04T07:42:46Z Import SharePoint Online list data to On premise SQL server database using SSIS https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/import-sharepoint-online-list-data-to-on-premise-sql-server/m-p/1934375#M207 <P>Hello Community,&nbsp;</P><P>&nbsp;</P><P>I am trying to import SharePoint online list data to SQL server using SSIS. I have connected this using O Data Source Editor. I can see all the columns except the choice type columns in SSIS destination mapping.&nbsp; Is there any different approach to do this ?</P><P>Any help is greatly appreciated!</P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 26 Nov 2020 15:48:44 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/import-sharepoint-online-list-data-to-on-premise-sql-server/m-p/1934375#M207 uday_kumar 2020-11-26T15:48:44Z How to delete the site i just created ? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-delete-the-site-i-just-created/m-p/1883721#M200 <P>Hi All</P><P>I accidently create a site at share point , can some one share with me how to delete it ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PAULYEO11_0-1605258445450.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/233372iBB6FEF9D08B57185/image-size/medium?v=v2&amp;px=400" role="button" title="PAULYEO11_0-1605258445450.png" alt="PAULYEO11_0-1605258445450.png" /></span></P><P>&nbsp;</P> Fri, 13 Nov 2020 09:07:39 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-delete-the-site-i-just-created/m-p/1883721#M200 PAULYEO11 2020-11-13T09:07:39Z hi https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/hi/m-p/1859649#M198 <P>hi</P><P>&nbsp;</P> Fri, 06 Nov 2020 03:06:28 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/hi/m-p/1859649#M198 9321924 2020-11-06T03:06:28Z How does a SharePoint Folder link to a SharePoint Online List https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-does-a-sharepoint-folder-link-to-a-sharepoint-online-list/m-p/1799171#M197 <P>Hi<BR />I am building a Power BI dashboard that links to a SharePoint Folder. I have added the Approve and Reject option for a document. I was hoping to pull this data into my PBI dashboard. So I am using the SharePoint Folder connect or to get this, however this does not contain the Accept or Reject status - so I am assuming this stored in the Documents section of a SharePoint Online List. But I don't see how these two entities link together<BR /><BR /></P><P>See attached screen shots of what I am trying to do</P><P><BR />Any thoughts would be greatly appreciated</P><P><BR />IG</P> Tue, 20 Oct 2020 12:28:40 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-does-a-sharepoint-folder-link-to-a-sharepoint-online-list/m-p/1799171#M197 Indy_UK 2020-10-20T12:28:40Z Scheduled Powerpivot data refresh not working when moved to new SQl Server https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/scheduled-powerpivot-data-refresh-not-working-when-moved-to-new/m-p/1591501#M195 <P>We have SP 2013. We changed our SQL server which caused the scheduled data refreshes to fail.</P><P>Since we were using an alias, we changed it to the new SQL server.</P><P>&nbsp;</P><P>How can I add a new data source for all the documents scheduled for Powerpivot refresh?</P> Sun, 16 Aug 2020 14:19:21 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/scheduled-powerpivot-data-refresh-not-working-when-moved-to-new/m-p/1591501#M195 Test SharePoint 2020-08-16T14:19:21Z How to bookmark a Power BI filter within Sharepoint Power BI embedded web part https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-bookmark-a-power-bi-filter-within-sharepoint-power-bi/m-p/1502127#M194 <P>Use case: I'm a sales leader using a sharepoint report catalog and when I select my bookmarks for the North division power bi report I only want to see that power bi report filtered to North division. Is this possible without having to load a separate embedded power bi urls for each filter?</P> Wed, 01 Jul 2020 18:57:28 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-bookmark-a-power-bi-filter-within-sharepoint-power-bi/m-p/1502127#M194 Emilyviz 2020-07-01T18:57:28Z Access Request Sharepoint Site https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/access-request-sharepoint-site/m-p/1377924#M191 <P>Hi Experts,</P><P>I am looking for a SharePoint functionality to implement in our reporting project.</P><P>I have a SQL server database table which has City Hierarchy data. Now I want to build a<SPAN>&nbsp;</SPAN><STRONG>Reports Access Site</STRONG><SPAN>&nbsp;</SPAN>which should have the City arranged in hierarchical order (Country-&gt;Region-&gt;State-&gt;City).In order to view the data for respective cities, the user need to go to this site and create an access request by selecting the cities/state/region/country he needs access to and then submit for approval.</P><P>This request should then go through various approval levels and then store this request along with approval details/status in another database table in SQL SERVER so that it can be used by system to provide access.</P><P>&nbsp;</P><P>Is this doable and if yes then is there any links/videos which can guide me on how to do it.</P><P>Thanks</P><P>Nivi</P> Sun, 10 May 2020 13:21:21 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/access-request-sharepoint-site/m-p/1377924#M191 NiviPower 2020-05-10T13:21:21Z Building a SharePoint Engagement Metrics report / dashboard https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/building-a-sharepoint-engagement-metrics-report-dashboard/m-p/1329091#M189 <P>I'm looking into building a SharePoint Engagement Metrics report.&nbsp;</P><P>&nbsp;</P><P>I understand that SharePoint provides some basic analytics but this view does not offer user granularity.&nbsp;</P><P>&nbsp;</P><P data-unlink="true"><A href="#" target="_blank">https://contoso.sharepoint.com/sites/my-sharepoint-site/_layouts/15/siteanalytics.aspx?view=19</A>&nbsp;</P><P data-unlink="true">&nbsp;</P><P data-unlink="true">I'm looking into using the Office 365 Unified Audit Logs, specifically the 'ViewedPage' SharePoint activity.&nbsp;</P><P data-unlink="true">&nbsp;</P><P data-unlink="true">Is this the right approach for this? Is there a better option, if so what are those options? Please advise.</P> Wed, 22 Apr 2020 15:28:04 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/building-a-sharepoint-engagement-metrics-report-dashboard/m-p/1329091#M189 dataninja 2020-04-22T15:28:04Z Reading Sharepoint 2019 List with StreamReader.readtoend() returns empty string https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/reading-sharepoint-2019-list-with-streamreader-readtoend-returns/m-p/1277647#M188 <P>I currently must extract data from Sharepoint List to XML.&nbsp; It works fine when I'm reading data from a Sharepoint 2010 List.</P><P>Now, Sharepoint server will be migrated, and I have to test if current script will works with new version of Sharepoint. Unfortenately, the following code:</P><PRE><SPAN class="pln"> response </SPAN><SPAN class="pun">=</SPAN><SPAN class="pln"> request</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">GetResponse</SPAN><SPAN class="pun">();</SPAN> <SPAN class="kwd">string</SPAN><SPAN class="pln"> xmlData</SPAN><SPAN class="pun">;</SPAN><SPAN class="pln"> using </SPAN><SPAN class="pun">(</SPAN><SPAN class="typ">StreamReader</SPAN><SPAN class="pln"> sr </SPAN><SPAN class="pun">=</SPAN> <SPAN class="kwd">new</SPAN> <SPAN class="typ">StreamReader</SPAN><SPAN class="pun">(</SPAN><SPAN class="pln">response</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">GetResponseStream</SPAN><SPAN class="pun">()))</SPAN> <SPAN class="pun">{</SPAN><SPAN class="pln"> xmlData </SPAN><SPAN class="pun">=</SPAN><SPAN class="pln"> sr</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">ReadToEnd</SPAN><SPAN class="pun">();</SPAN><SPAN class="pln"> sr</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">Close</SPAN><SPAN class="pun">();</SPAN> <SPAN class="pun">}</SPAN></PRE><P>returns empty string. I try to add position = 0, but it return error (can not use seek for this stream, or something approaching).</P><P>Trying</P><P>&nbsp;&nbsp;&nbsp;</P><PRE><SPAN class="pln"> string xmlData = "";using </SPAN><SPAN class="pun">(</SPAN><SPAN class="typ">StreamReader</SPAN><SPAN class="pln"> sr </SPAN><SPAN class="pun">=</SPAN> <SPAN class="kwd">new</SPAN> <SPAN class="typ">StreamReader</SPAN><SPAN class="pun">(</SPAN><SPAN class="pln">response</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">GetResponseStream</SPAN><SPAN class="pun">()))</SPAN> <SPAN class="pun">{</SPAN> <SPAN class="com">//xmlData = sr.ReadToEnd();</SPAN> <SPAN class="kwd">while</SPAN> <SPAN class="pun">(!</SPAN><SPAN class="pln">sr</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">EndOfStream</SPAN><SPAN class="pun">)</SPAN> <SPAN class="pun">{</SPAN><SPAN class="pln"> xmlData </SPAN><SPAN class="pun">+=</SPAN><SPAN class="pln"> sr</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">ReadLine</SPAN><SPAN class="pun">()</SPAN> <SPAN class="pun">+</SPAN> <SPAN class="str">"\n"</SPAN><SPAN class="pun">;</SPAN> <SPAN class="pun">}</SPAN><SPAN class="pln"> sr</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">Close</SPAN><SPAN class="pun">();</SPAN> <SPAN class="pun">}</SPAN></PRE><P>will not work. In this case, in debug mode, the program not pass on while loop (as if the position of cursor was directly at end of Stream).</P><P>Is there any change regarding Sharepoint 2019 that need to be add on code ?</P> Fri, 03 Apr 2020 05:56:32 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/reading-sharepoint-2019-list-with-streamreader-readtoend-returns/m-p/1277647#M188 cascador84 2020-04-03T05:56:32Z Subscription doesn’t work properly. Someday it works and someday doesn’t https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/subscription-doesn-t-work-properly-someday-it-works-and-someday/m-p/1221533#M187 <P><SPAN>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>Subscription doesn’t work properly. Someday it works and someday doesn’t</P><P><SPAN>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>There are no error message in the subscription page</P><P><SPAN>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>No issue identified with the file size. Even I tried to create subscription without any attachment and it’s also not working regularly.</P><P><SPAN>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>Sharepoint version 2016</P><P><SPAN>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>Jobs not scheduled in sql server agent</P><P><SPAN>·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>All reports and scheduling managed in sharepoint itself</P> Wed, 11 Mar 2020 06:06:28 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/subscription-doesn-t-work-properly-someday-it-works-and-someday/m-p/1221533#M187 Rajesh_Ganesan 2020-03-11T06:06:28Z Error connecting Sharepoint (excel) file to PowerBI desktop file https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/error-connecting-sharepoint-excel-file-to-powerbi-desktop-file/m-p/1191883#M186 <P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture3.PNG" style="width: 200px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/173182i0C35D0758B6D1E96/image-size/small?v=v2&amp;px=200" role="button" title="Capture3.PNG" alt="Capture3.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.PNG" style="width: 200px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/173185i3E04A086D5B87AA0/image-size/small?v=v2&amp;px=200" role="button" title="Capture2.PNG" alt="Capture2.PNG" /></span></P><P>Hi, on Friday I connected this excel file in Sharepoint to a PowerBI desktop report I am developing. No errors. Today, Monday, as soon as I opened the PBI desktop file, I got the error (1st screenshot attached) which I didn't have on Friday and nothing has changed regarding file connections. Then, as a test, I opened a new blank Power BI desktop file, and tried to connect all over to the sharepoint file to see if I got the same error. And I sort of did - see 2nd screenshot attached.&nbsp;</P><P>But what I don't understand is why there would be this error now when it wasn't an issue the last time I opened this file on Friday and nothing has changed in terms of connection. Thanks.&nbsp;</P> Mon, 24 Feb 2020 23:07:23 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/error-connecting-sharepoint-excel-file-to-powerbi-desktop-file/m-p/1191883#M186 aishayeoh 2020-02-24T23:07:23Z Get Sharepoint Document Location from Dynamics into Power BI https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/get-sharepoint-document-location-from-dynamics-into-power-bi/m-p/1132855#M184 <P>Hi everyone,&nbsp;</P><P>&nbsp;</P><P>This is my first post in this community and I really hope you can assist me. I'm trying to create a report in Power BI, where I need some information about the SharePoint document location in Dynamics.&nbsp;<SPAN>I'm running into an issue once I load the Sharepoint Document information from Dynamics into Power BI. I'm able to fetch the SharePoint document location through Power BI, but when I try to get the absolute URL it is only obtainable through a function (see picture below). The dream scenario is that I'm able to get the URL itself directly into a table.&nbsp;</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="clipboard_image_0.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/167671iFADC96EFC9F14000/image-size/medium?v=v2&amp;px=400" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P><P>&nbsp;</P><P>Do you have any suggestions on how to resolve this? Note that the data is gathered through the Dynamics API.&nbsp;</P><P>&nbsp;</P><P>Cheers</P><P>Kristian&nbsp;</P> Tue, 28 Jan 2020 12:19:42 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/get-sharepoint-document-location-from-dynamics-into-power-bi/m-p/1132855#M184 kristianjdp 2020-01-28T12:19:42Z Site Collection Settings - Site Usage - Access data within PowerBI https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/site-collection-settings-site-usage-access-data-within-powerbi/m-p/1101310#M183 <P><STRONG>Use case</STRONG> &gt; the Site usage option returns very useful analytics about Visits, Unique Viewers &amp; other stats for the site in general &amp; particular pages. With the Site usage data we could get an overview of how well the user adoption is in general and which pages/info is consulted often/regular/seldom/not. Unfortunately there a few conditions &amp; drawbacks:</P><UL><LI>Only Site Collection owners can access the Site usage option &amp; dat</LI><LI><SPAN>Our current intranet (built on SP-O365) consists of multiple site collections and many pages &gt; which impedes that we have to click &amp; collect data from a dozen different places</SPAN></LI></UL><P><STRONG>Questions:</STRONG></P><OL><LI>Is it possible to access the data shown on the Site Usage page from within Power BI?</LI><LI>If so, how (<SPAN>source/URL/…</SPAN>) can we then connect to that data?</LI></OL><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Settings-SiteUsage.png" style="width: 188px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/164722i7D6D22C1BA8C3EED/image-size/medium?v=v2&amp;px=400" role="button" title="Settings-SiteUsage.png" alt="Settings-SiteUsage.png" /></span>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Settings-SiteUsage-SiteVisits.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/164724iD7980623B6D77C98/image-size/medium?v=v2&amp;px=400" role="button" title="Settings-SiteUsage-SiteVisits.png" alt="Settings-SiteUsage-SiteVisits.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Settings-SiteUsage-UniqueViewers.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/164723iDB79E03B197F2E66/image-size/medium?v=v2&amp;px=400" role="button" title="Settings-SiteUsage-UniqueViewers.png" alt="Settings-SiteUsage-UniqueViewers.png" /></span></P> Fri, 10 Jan 2020 13:30:50 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/site-collection-settings-site-usage-access-data-within-powerbi/m-p/1101310#M183 Eric Deferm 2020-01-10T13:30:50Z Except PowerBI, what BI tool work best with SharePoint Online? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/except-powerbi-what-bi-tool-work-best-with-sharepoint-online/m-p/1064358#M182 <P>Hi,&nbsp;Except PowerBI, what BI tool work best with SharePoint Online?</P><P>Thanks</P><P>Peter</P> Fri, 13 Dec 2019 09:53:37 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/except-powerbi-what-bi-tool-work-best-with-sharepoint-online/m-p/1064358#M182 Peter Cheung 2019-12-13T09:53:37Z Report Viewer Web part https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/report-viewer-web-part/m-p/1016707#M177 <P><SPAN class="css-901oao css-16my406 r-1qd0xha r-ad9z0x r-bcqeeo r-qvutc0">The wonderful SharePoint 20193 book by <LI-USER uid="8711"></LI-USER>&nbsp;and <LI-USER uid="130"></LI-USER>&nbsp;states that the Report Viewer web part can be used, but the docs from MS at </SPAN><A title="https://www.microsoft.com/en-us/download/details.aspx?id=55949" href="#" target="_blank" rel="noopener noreferrer">microsoft.com/en-us/download<SPAN class="css-901oao css-16my406 r-1qd0xha r-hiw28u r-ad9z0x r-bcqeeo r-qvutc0">/details.aspx?id=55949</SPAN><SPAN class="css-901oao css-16my406 r-1qd0xha r-ad9z0x r-bcqeeo r-lrvibr r-qvutc0">…</SPAN></A><SPAN class="css-901oao css-16my406 r-1qd0xha r-ad9z0x r-bcqeeo r-qvutc0"> don't list&nbsp; SharePoint 2019 as a supported version. Does that web part work with SP2019, is MS documentation wrong?</SPAN></P> Tue, 19 Nov 2019 10:20:14 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/report-viewer-web-part/m-p/1016707#M177 Dean Gross 2019-11-19T10:20:14Z Embedding BI https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/embedding-bi/m-p/1005887#M176 <P>There was a great thread from 2017 as it relates to the licensing required for embedding BI in Sharepoint. It sounded like in that thread that the licensing was going to change.&nbsp; I have a pro license for myself.&nbsp; What does my organization need in order to embed in Sharepoint?&nbsp; Do I need to have a premium license across the organization?&nbsp; Does every user need to have a pro license?&nbsp; Is it a combination of the two?&nbsp; I can see the embedded document, but no one else can....</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Wed, 13 Nov 2019 16:03:02 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/embedding-bi/m-p/1005887#M176 Smitty1730 2019-11-13T16:03:02Z Generate a dynamic report in SharePoint Online so that list data can be viewed easily https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/generate-a-dynamic-report-in-sharepoint-online-so-that-list-data/m-p/908476#M174 <P><FONT face="andale mono,times">Hi All,</FONT></P><P><FONT face="andale mono,times">We have a SharePoint Online List having data related to one project with multiple columns like Title , Owner, Description, Testing Status ( Completed , On Hold etc. ) . We want to generate a dynamic&nbsp;report ( graphs, charts etc, ) in SharePoint Online so that data can be viewed easily . We are not planning to develop a code as such . What are the available options ?&nbsp;</FONT></P> Fri, 11 Oct 2019 12:23:47 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/generate-a-dynamic-report-in-sharepoint-online-so-that-list-data/m-p/908476#M174 Vimmi Rawat 2019-10-11T12:23:47Z Access forbidden when connecting to SharePoint folder from PBI desktop https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/access-forbidden-when-connecting-to-sharepoint-folder-from-pbi/m-p/781485#M168 <P>SharePoint 2016 on-prem/Power BI Report Server (on-prem)</P><P>&nbsp;</P><P>In the Power BI desktop client, when you try to 'Get Data' and select the option for SharePoint folder, we enter the URL and trim the path down to the top-level, use Windows (AD) credentials to access the SharePoint content, it returns an error 'Access to the resource is forbidden'.&nbsp; We've tried using a service account specifically set up for this role, and we've tried using our elevated accounts that not only have access, but are site collection admins, and get the same results.&nbsp; I've checked the logs and don't see any errors on the App or Web servers.</P> Wed, 31 Jul 2019 14:18:12 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/access-forbidden-when-connecting-to-sharepoint-folder-from-pbi/m-p/781485#M168 Greg Webb 2019-07-31T14:18:12Z Get information from website and put these into SharePoint Web Part automatically https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/get-information-from-website-and-put-these-into-sharepoint-web/m-p/767374#M166 <P>Hi all,</P><P>&nbsp;</P><P>I want to get information from website and put these into SharePoint web part automatically.<BR />Anyone have any ideas how this can be done?</P><P>&nbsp;</P><P>Thank you.</P> Mon, 22 Jul 2019 11:24:30 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/get-information-from-website-and-put-these-into-sharepoint-web/m-p/767374#M166 Mohamed_Ben_Moussa 2019-07-22T11:24:30Z Automatically trim the audit log for this site? (SharePoint Logs) https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/automatically-trim-the-audit-log-for-this-site-sharepoint-logs/m-p/764866#M165 <P>Is there a way to Turn Off the "Automatically trim the audit log for this site" for a specific site with in my SharePoint Online Collection or is it only possible at the root level?</P><P>&nbsp;</P><P>Also, is there a reason the option is greyed out for me event if I am the Site Owner/Admin?</P><P>&nbsp;</P><P>I am trying to Achieve some analytics on a specific Site that we have.</P> Fri, 19 Jul 2019 14:59:37 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/automatically-trim-the-audit-log-for-this-site-sharepoint-logs/m-p/764866#M165 myke_deabreu 2019-07-19T14:59:37Z Error connecting sharepoint custom list with PowerBi "We couldn't parse OData response result" https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/error-connecting-sharepoint-custom-list-with-powerbi-quot-we/m-p/750459#M164 <P>We have a custom list inside our sharepoint on-premises 2013, and using the Power BI desktop app i want to connect with the sharepoint custom list. so i did the following steps:-</P><P>1) Inside power BI &gt;&gt; click on "Get Data" &gt;&gt; "SharePoint List"</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="splist.png" style="width: 472px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/123042i87AE5775C7385BED/image-size/large?v=v2&amp;px=999" role="button" title="splist.png" alt="splist.png" /></span></P><P>2. i entered the site url &gt;&gt; select the intended custom list &gt;&gt; but i got this error:-</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="navi.png" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/123047i33181759BC471934/image-size/large?v=v2&amp;px=999" role="button" title="navi.png" alt="navi.png" /></span></P><P>&nbsp;</P><P><STRONG>DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'QuickOrder', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.</STRONG><BR /><STRONG>Details:</STRONG><BR /><STRONG>DataSourceKind=SharePoint</STRONG><BR /><STRONG>DataSourcePath=http://****/****/_api/Web/Lists(guid'80ca0b70-24c5-4d06-b4f4-03de6c7b733f')/Items</STRONG></P><P>&nbsp;</P><P>where the "QuickOrder" is a custom site column of this type</P><P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qo.png" style="width: 640px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/123043iE84DCDEB89C0E380/image-size/large?v=v2&amp;px=999" role="button" title="qo.png" alt="qo.png" /></span></STRONG></P><P>&nbsp;</P><P>so not sure why Power BI raised this error on this column specifically? is there a way to fix this error? or to exclude this column for the integration?</P> Thu, 11 Jul 2019 16:10:00 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/error-connecting-sharepoint-custom-list-with-powerbi-quot-we/m-p/750459#M164 john john 2019-07-11T16:10:00Z Upgrading PowerPivot SharePoint 2013 to Power BI 2019 https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/upgrading-powerpivot-sharepoint-2013-to-power-bi-2019/m-p/734694#M163 <P><SPAN>We are in the process of upgrading our SharePoint On-Premise 2013 farm to SharePoint On-Premise 2019. In the 2013 farm we are using PowerPivot and SSRS integrated mode. It's my understanding in 2019 its recommended to use Power BI but is it still possible to use powerpivot and SSRS integrated in 2019? If not what is involved in migrating from SharePoint 2013 PowerPivot/SSRS to Power BI?</SPAN></P> Tue, 02 Jul 2019 16:20:21 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/upgrading-powerpivot-sharepoint-2013-to-power-bi-2019/m-p/734694#M163 spin800 2019-07-02T16:20:21Z Does PowerBI Integrate with a Sharepoint Business Intelligence (BI) Center site? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/does-powerbi-integrate-with-a-sharepoint-business-intelligence/m-p/716285#M162 <P>Hi All,</P><P>&nbsp;</P><P>I have been looking into the options for publishing Power BI reports to Sharepoint. I understand that it is possible to embed a Power BI report in a Sharepoint modern site page.&nbsp;<A title="" href="#" target="_blank" rel="noopener nofollow noopener noreferrer">https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo</A></P><P>&nbsp;</P><P>However, I came across a potential second option which was a reference to a type of Sharepoint site called Business Intelligence (BI) Center site. I would like to determine if we could use this type of site as our one stop location for reports/KPIs/scorecards/dashboards etc. However, I do not see Power BI listed as a tool which can be used to create reports on the Business Intelligence Center site.<SPAN>&nbsp;</SPAN><A title="" href="#" target="_blank" rel="noopener nofollow noopener noreferrer">https://support.office.com/en-us/article/create-a-report-or-a-scorecard-sharepoint-server-1b0cff41-d...</A>&nbsp;</P><P>Is there a way to embed existing Power BI reports in this type of site? Obviously we do not want to redesign our existing Power BI reports using one of the listed tools. I would like to know if there is any kind of integration between Power BI and a Sharepoint Business Intelligence (BI) Center site.</P><P>&nbsp;</P><P>Thank you in advance for any information.</P><P>&nbsp;</P><P>Regards,</P><P>Linda</P> Mon, 24 Jun 2019 09:42:06 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/does-powerbi-integrate-with-a-sharepoint-business-intelligence/m-p/716285#M162 LindaH665 2019-06-24T09:42:06Z SharePoint folders and re-sharing permissions with external parties https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-folders-and-re-sharing-permissions-with-external/m-p/642688#M160 <P>Hello</P><P>&nbsp;</P><P>I have a site in our company, that has been requested to share certain folders with external parties (not in our domain) and to also allow them to reshare the folders.</P><P>&nbsp;</P><P>I have tried several different ways, from link sharing, to adding them to the users allowed to edit.</P><P>&nbsp;</P><P>The end users can see the files and do what they need, but are not allowed to re-share it (this is a screenshot from 1 of the external shared users)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharepoint_issue.png" style="width: 567px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/115889i6653AF3EBEEAF0C4/image-size/large?v=v2&amp;px=999" role="button" title="sharepoint_issue.png" alt="sharepoint_issue.png" /></span></P><P>&nbsp;</P><P>Please help</P><P>Thanks</P> Fri, 24 May 2019 02:55:56 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-folders-and-re-sharing-permissions-with-external/m-p/642688#M160 RobbieJiang 2019-05-24T02:55:56Z How to increase timeout period for SharePoint SSRS report subscriptions https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-increase-timeout-period-for-sharepoint-ssrs-report/m-p/510979#M159 <P>Hi All,</P><P>&nbsp;</P><P>We have SSRS 2016 environment in SharePoint 2016 integrated mode. I observed there are some subscriptions which are taking longer time than expected, though not generating report (may be due to timeout), is there any way we can increase timeout period for subscriptions (not report processing time), if yes&nbsp;</P><P>&nbsp;</P><P>1. Should we increase timeout for whole environment or just for affected subscriptions?</P><P>2. As per my understanding, by design subscriptions are processed sequentially not parallel so we don't have any control on subscription processing, any suggestions here if we can control it programatically?</P><P>3. We already automated the SQL queries but there are some subscriptions pulling data for long period (6-7 years), what can be done in this case to make subscriptions run?</P><P>We have only couple of Datasets and no caching plan setup as of now.</P><P>&nbsp;</P><P>Any comments or suggestions would be greatly appreciated.&nbsp;</P><P>Thanks in advance!!!</P> Thu, 02 May 2019 08:22:44 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-increase-timeout-period-for-sharepoint-ssrs-report/m-p/510979#M159 NeerajMalhotra 2019-05-02T08:22:44Z Group by view not showing all groups https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/group-by-view-not-showing-all-groups/m-p/482861#M158 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I have a document library with multiple tags. One of the fields is a dropdown with 3 items. When I do a 'group by' using the dropdown field I can only see groups for 2 items. The 3rd one is just invisible. I have documents tagged to all three options. So all the 3 tags are in use. When I ungroup them they are all visible.</P><P>&nbsp;</P><P>Any help will be appreciated.</P> Thu, 25 Apr 2019 17:00:03 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/group-by-view-not-showing-all-groups/m-p/482861#M158 dipand 2019-04-25T17:00:03Z Generic log in Power BI Dashboard into SharePoint on premise. https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/generic-log-in-power-bi-dashboard-into-sharepoint-on-premise/m-p/481372#M157 <P>Hi,</P><P>&nbsp;</P><P>I have a number of Power BI Dashboard and I am trying to put each one into SharePoint page.</P><P>When I am trying to view the page then each Dashboard needs to log in with&nbsp;<STRONG>BASIC authentication</STRONG>.</P><P>I do not want each user to have to log in to each Dashboard each time they load the page.</P><P>Anyone have any ideas how this can be done?</P><P>&nbsp;</P><P>Thank you.</P> Tue, 23 Apr 2019 16:57:19 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/generic-log-in-power-bi-dashboard-into-sharepoint-on-premise/m-p/481372#M157 Mohamed_Ben_Moussa 2019-04-23T16:57:19Z refresh excel spreadsheets with on prem data connections https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/refresh-excel-spreadsheets-with-on-prem-data-connections/m-p/459836#M156 <P>We have created a Sharepoint site on Office&nbsp; 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.&nbsp; 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.</P> Tue, 16 Apr 2019 11:08:47 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/refresh-excel-spreadsheets-with-on-prem-data-connections/m-p/459836#M156 OSU4EVER 2019-04-16T11:08:47Z SP2016/2019 Office Online licensing https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sp2016-2019-office-online-licensing/m-p/355302#M151 <P>Hi</P><P>Some questions regarding licensing...<BR />Do I need SP Enterprise?</P><P>And what license (If there are options) do i need for Office Online Server?<BR />The users has&nbsp;O365 E3 licenses so they should not need cals should they? (Nope, SPOnline is not an option, Cubes is too big to sync)</P><P><BR />I need Office Online server to co-collaborate on excel?<BR />Do I need SharePoint Enterprise&nbsp;or Office Online server to connect a spreadsheet running on SharePoint to a SSAS Cube?<BR /><BR />Thanks in advance&nbsp;</P><P>&nbsp;</P> Fri, 22 Feb 2019 12:55:32 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sp2016-2019-office-online-licensing/m-p/355302#M151 Danie Claassen 2019-02-22T12:55:32Z Cannot Release Lock on SharePoint Online File https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/cannot-release-lock-on-sharepoint-online-file/m-p/354478#M150 <P>Hi</P><P>How can I get an xls&nbsp;hosted on SharePoint Online to pull data from a Analysis server cube hosted onPrem?</P><P>&nbsp;</P><P>Looking at On-Premise Data Gateway but not sure if that will work?&nbsp;</P><P>Something like this maybe possible? (Orange is existing infrastructure)<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 845px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/83886iB2D1F3A375136648/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 21 Feb 2019 06:25:49 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/cannot-release-lock-on-sharepoint-online-file/m-p/354478#M150 Danie Claassen 2019-02-21T06:25:49Z How to get SharePoint Library metadata / custom columns in Excel via PowerQuery? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-get-sharepoint-library-metadata-custom-columns-in-excel/m-p/266002#M140 <P>When I use the "Export in Excel" option from a SharePoint library, this creates a query file with the iqy extension. This can be saved as an odc connection for future refreshes, but either way I'd rather handle everything via Power Query rather than mix PQ with "old school" data connections.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Export to Excel from SharePoint library" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/55323iF210870A556AD1F1/image-size/large?v=v2&amp;px=999" role="button" title="SP-export-excel.png" alt="Export to Excel from SharePoint library" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Export to Excel from SharePoint library</span></span></P><P>The Excel table built via the iqy file or resulting odc connection (through&nbsp;<EM>Data &gt; Existing Connections</EM>) includes extra columns that we added to the library</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="User-created columns" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/55325i7252FF09EB5A17E3/image-size/large?v=v2&amp;px=999" role="button" title="user-columns.png" alt="User-created columns" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">User-created columns</span></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="via iqy query / odc connection" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/55326i911FD0A2BCCA2B21/image-size/large?v=v2&amp;px=999" role="button" title="excel-cols.png" alt="via iqy query / odc connection" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">via iqy query / odc connection</span></span></P><P>However using PQ to retrieve a SharePoint folder only returns default columns:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Get Data &amp;gt; From SharePoint Folder" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/55328iF6967C7372C73976/image-size/large?v=v2&amp;px=999" role="button" title="sp-pq.png" alt="Get Data &gt; From SharePoint Folder" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Get Data &gt; From SharePoint Folder</span></span></P><P>I also had a look at results returned by the SharePoint Lists and Odata feed connectors, and they return way more than what I need (and I'm not sure they have what I do need, I'd rather mess around with these if I don't have to).</P><P>&nbsp;</P><P>Is there a way to get the same results via Power Query that you get from "Export in Excel" as detailed above? Any help appreciated.</P><P><BR />This is with Excel 2016 (up-to-date O365 ProPlus monthly release) and SharePoint Online. I haven't tried from PBI Desktop though I'd expect the same behavior.</P> Tue, 02 Oct 2018 22:51:01 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-get-sharepoint-library-metadata-custom-columns-in-excel/m-p/266002#M140 Olivier Travers 2018-10-02T22:51:01Z Sharepoint list data imported into Excel 2016 using Odata:Does not refresh when published to Sharepo https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-list-data-imported-into-excel-2016-using-odata-does/m-p/222481#M137 <P>Using Excel 2013 it was possible to import the list(s) data from SharePoint online into excel using OData option. This excel when uploaded to SharePoint document library,&nbsp;It was possible to perform the real-time refresh of the data so that the excel pulls the information directly from the SharePoint list into the excel&nbsp;online(not from excel on local machine).</P><P>&nbsp;</P><P>Based on my experiments i have written couple of Blogs here :&nbsp;</P><H4><A href="#" target="_blank">Excel for BI Reporting and Publishing Through SharePoint - Part 1<BR /></A><A title="Excel for BI Reporting and Publishing Through SharePoint – Part 2" href="#" target="_blank">Excel for BI Reporting and Publishing Through SharePoint – Part 2</A></H4><P>However,&nbsp;in Excel 2016 it doesn't seem to work. I get the error when i try to refresh. This was a good feature to be used by people who are&nbsp;happy with mini custom application driven through SharePoint.</P><P>&nbsp;</P><P>Can anyone tell why this is not working now? and how to report this&nbsp;?</P><P>&nbsp;</P><P>Thank you..</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 02 Aug 2018 08:50:02 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-list-data-imported-into-excel-2016-using-odata-does/m-p/222481#M137 Rajashekhar Sheelvant 2018-08-02T08:50:02Z New feature: Create Power BI reports from tables in Excel files and CSV files https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/new-feature-create-power-bi-reports-from-tables-in-excel-files/m-p/201843#M131 <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">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.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="OpenInPowerBI.PNG" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/35576iF7D65F4A8C78DC8B/image-size/large?v=v2&amp;px=999" role="button" title="OpenInPowerBI.PNG" alt="OpenInPowerBI.PNG" /></span></P> <P>&nbsp;</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">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 <A href="#" target="_blank">formatted as tables in Excel</A>.</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="DatasetIsReady.PNG" style="width: 626px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/35577iC0CA8DBD8500D70B/image-size/large?v=v2&amp;px=999" role="button" title="DatasetIsReady.PNG" alt="DatasetIsReady.PNG" /></span></P> <P>&nbsp;</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">The dataset created in Power BI will be automatically refreshed when you make changes to the original Excel or CSV file.&nbsp; 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.</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">&nbsp;</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">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.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Visualize.PNG" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/35578i366ADE4B30BC3577/image-size/large?v=v2&amp;px=999" role="button" title="Visualize.PNG" alt="Visualize.PNG" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P style="margin: 0in;"><SPAN style="font-family: Calibri; font-size: 11.0pt;">If you are a first time Power BI user, you may find <A href="#" target="_blank">this page </A>helpful for an introduction</SPAN><SPAN style="font-family: Calibri; font-size: 11.0pt;">.</SPAN></P> <P style="margin: 0in;">&nbsp;</P> <P style="margin: 0in; font-family: Calibri; font-size: 11.0pt;">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.</P> Thu, 07 Jun 2018 14:38:00 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/new-feature-create-power-bi-reports-from-tables-in-excel-files/m-p/201843#M131 Kerem Yuceturk 2018-06-07T14:38:00Z Move SharePoint 2013 PowerPivot to new SQL Server https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/move-sharepoint-2013-powerpivot-to-new-sql-server/m-p/169933#M128 <P>I can't find clear documentation on this so looking for any clarification or confirmation.&nbsp; Have&nbsp;SharePoint 2013 on prem using&nbsp;PowerPivot and wants to move the instance to another SQL server.</P> <P>&nbsp;</P> <P>My understanding would be setup the SQL instance and PowerPivot install, stop the PowerPivot service instance in SharePoint, backup/restore the databases, run the PowerPivot config wizard to point to the new SQL instance, start the service instance. Is that right?&nbsp; Do the datasources in the Excel workbooks need to be updated too?&nbsp; Or what's the proper method?&nbsp; Thanks!</P> Fri, 09 Mar 2018 18:26:52 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/move-sharepoint-2013-powerpivot-to-new-sql-server/m-p/169933#M128 Doug Allen 2018-03-09T18:26:52Z SharePoint 2016 On Premises PowerPivot support for High Availability (HA) https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-2016-on-premises-powerpivot-support-for-high/m-p/151892#M126 <P>Can a&nbsp;SharePoint 2016 PowerPivot Service Application be installed on 2 application servers so that it can be "highly available"? I have a requirement to support PowerPivot availability during SharePoint patching, so that the PowerPivot service is available when one of our two application servers is being patched.&nbsp;</P> <P>I am unable to find any TechNet resources that provide this info.&nbsp;</P> Fri, 02 Feb 2018 16:31:47 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-2016-on-premises-powerpivot-support-for-high/m-p/151892#M126 Dan Rosenberg 2018-02-02T16:31:47Z PowerPivot Excel 2016 https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/powerpivot-excel-2016/m-p/145460#M125 <P>Hi,</P> <P>I find nowhere the response, I'm not an "IT guy".</P> <P>1. I have created as now an excel file in sharepoint with a data model linked to several power view reports. Excel 2017 linked to Report Q1;Report Q2;Report Q3;ReportQ4.</P> <P>I always update the excel file updating the data model with update all, changes reflecting in all my reports.</P> <P>2. As my excel sheet Excel 2017&nbsp;is quite heavy (a lot of datas), for the year 2018, I would like to create a new Excel 2018 with a similar data model and same power view report, not re-doing all the work., exactly same presentation.</P> <P>(My previous Excel 2017 must still be linked with Report Q1;Report Q2... I want to see later these reports with datas 2017, keeping reports 2017 with datas 2017.)</P> <P>&nbsp;</P> <P>What is the best way "copying" work 2017, updated with 2018 datas?</P> <P>&nbsp;</P> <P>Hope that somebody can help me with a simple language, I'm beginner.</P> <P>Thanks a lot in advance,</P> <P>&nbsp;</P> Tue, 16 Jan 2018 14:15:39 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/powerpivot-excel-2016/m-p/145460#M125 null null 2018-01-16T14:15:39Z Document library Shared documents https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/document-library-shared-documents/m-p/138748#M124 <P>Hi Everyone,</P> <P>&nbsp;</P> <P>recently, we migrated around 15000 documents from Box to SharePoint online document library and&nbsp;now I need to generate View Only (No sign-in required)&nbsp;link and export to CVS.&nbsp;</P> <P>I'm not sure what&nbsp;are the options I have. Power Shell comes on my mind but not sure about script.&nbsp;</P> <P>&nbsp;</P> <P>Any information on this would be a great help</P> <P>&nbsp;</P> <P>Thanks a lot&nbsp;</P> Wed, 20 Dec 2017 03:51:46 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/document-library-shared-documents/m-p/138748#M124 Divyang Patel 2017-12-20T03:51:46Z Printing Power BI report on sharepoint webpart https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/printing-power-bi-report-on-sharepoint-webpart/m-p/136986#M123 <P>Hi!</P> <P>&nbsp;</P> <P>I'm using Power Bi webpart on my SharePoint modern pages but since I have to print this report I didn't find anything about. The alternative way that I saw was go to the power bi web page and print the report. For my it's ok to do these steps but for my users we will have a lot of problems.</P> <P>&nbsp;</P> <P>Anyone have an alternative to print the report directly form Power Bi Webpart?</P> <P>&nbsp;</P> <P>Thanks a lot!</P> Wed, 13 Dec 2017 19:45:30 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/printing-power-bi-report-on-sharepoint-webpart/m-p/136986#M123 João Henrique Mortati Fuzinelli 2017-12-13T19:45:30Z SharePoint Online PowerBI Webpart error 10002 resource not allowed https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-online-powerbi-webpart-error-10002-resource-not/m-p/117167#M122 <P>Not sure if anyone else has ran into this yet, or if I need to just open a premier case instead.&nbsp; The PowerBI web part came out of preview today in our tenant, and I tried to add it to a modern page, but got an error, that I simply cannot find anywhere on the net.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Power BI Web Part Error Message" style="width: 811px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/22278iB575C0A8DCA173F8/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="Power BI Web Part Error Message" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Power BI Web Part Error Message</span></span></P><P>When I ran a Fiddler trace during adding the webpar I got some insight on the error. The SharePoint SP.OAuth.Token/acquire endpoint was trying to connect to the resource "<A href="#" target="_blank">https://analysis.windows.net/powerbi/api</A>" but was getting a status of HTTP 400.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Fiddler Trace" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/22279i0940EABC4F2BCC74/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="Fiddler Trace" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Fiddler Trace</span></span></P><P>&nbsp;</P><P>Anyways, not sure if anyone has had this yet, and if so, what did they do? When I try to browse to the <A href="#" target="_blank">https://analysis.windows.net</A> domain, I get a DNS error, so I'm not sure.&nbsp; The only real configuration modifications on the SharePoint Service was we are using Azure AD Conditional Access on SharePoint and OneDrive but not PowerBI right now.&nbsp;</P> Tue, 17 Oct 2017 11:05:05 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-online-powerbi-webpart-error-10002-resource-not/m-p/117167#M122 Louis Simonetti 2017-10-17T11:05:05Z Separating internal traffic from Sharepoint data https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/separating-internal-traffic-from-sharepoint-data/m-p/116104#M121 <P>Hi all,</P><P>I've been trying to separate our internal traffic from our external users in SPO. We can separate our users by either location office or department, but it seems the only kind of data we can see in the usage reports is "last" login.</P><P>&nbsp;</P><P>Is there a way we can get more granularity out of the reporting? I've had some success with the Adoption content pack but then again, struggled get data that didn't have our internal users in the mix. Here are some things I'm interested in having better analytics on:</P><P>- Most popular sites</P><P>-most popular documents</P><P>-Average duration of session</P><P>-top searches</P><P>-lowest ranked content</P><P>&nbsp;</P><P>Thanks,</P><P>&nbsp;</P><P>Oscar</P> Thu, 12 Oct 2017 21:15:37 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/separating-internal-traffic-from-sharepoint-data/m-p/116104#M121 Oscar Huang 2017-10-12T21:15:37Z How to connect with Excel Sheet in SharePoint Online to an on premise Cube? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-connect-with-excel-sheet-in-sharepoint-online-to-an-on/m-p/110951#M118 Hi,<BR /><BR />i have the following scenario:<BR /><BR />I have an on premise SSAS Cube and an Excel Sheet which connect to this Cube and the user is able to filter and work with the data. Now the Excel Sheet should be placed in SharePoint Online and the user should be still able to connect to the on premise Cube through Excel Services for refreshing the data etc.<BR /><BR />Is this possible and if yes, which options do i have? Wed, 27 Sep 2017 12:36:59 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/how-to-connect-with-excel-sheet-in-sharepoint-online-to-an-on/m-p/110951#M118 Yavuz Bogazci 2017-09-27T12:36:59Z Refresh failed: Office 365 Adoption_PreviewAprUpd has failed to refresh https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/refresh-failed-office-365-adoption-previewaprupd-has-failed-to/m-p/102202#M117 <P>Column 'UserId' in Table 'UserActivity' contains a duplicate value '123C5CF6FC0DF903076CC379DB1CCB03' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.</P><P>Next refresh for Office 365 Adoption_PreviewAprUpd is scheduled for 08/31/2017 00:00:00.</P> Wed, 30 Aug 2017 20:43:08 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/refresh-failed-office-365-adoption-previewaprupd-has-failed-to/m-p/102202#M117 Paul Miglio 2017-08-30T20:43:08Z Transfer PowerBI Data to new user https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/transfer-powerbi-data-to-new-user/m-p/83883#M111 <P>Hey Guys/Gals</P><P>&nbsp;</P><P>Searched but could not find this asnwer.</P><P>&nbsp;</P><P>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?</P> Thu, 29 Jun 2017 19:40:48 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/transfer-powerbi-data-to-new-user/m-p/83883#M111 davidpetree1 2017-06-29T19:40:48Z SharePoint Usage Doesn't Include External People? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-usage-doesn-t-include-external-people/m-p/78852#M110 <P>TL;DR: &nbsp;Is it possible in any way to get access to the usage information on a per site / per site collection basis and include external users?</P><P>&nbsp;</P><P>I'm trying to get some stats for SharePoint usage, but I'm really struggling. &nbsp;It seems audit reports aren't available programmatically to get detailed information. &nbsp;The Power BI Office 365 Adoption Preview only provides summarised data and doesn't provide the information I really need as far as I can tell.</P><P>&nbsp;</P><P>Ideally, I'd like to see usage on a per site collection / per site basis. &nbsp;And I'd like it to include external participants. &nbsp;So far, all the information I've seen only includes internal users? &nbsp;Does that sound right?</P><P>&nbsp;</P><P>Any information anyone can provide would be greatly appreciated. &nbsp;Thanks.</P><P>&nbsp;</P> Mon, 19 Jun 2017 14:48:30 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/sharepoint-usage-doesn-t-include-external-people/m-p/78852#M110 Darren Parkinson 2017-06-19T14:48:30Z What! You need a Power BI Pro Licence https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/what-you-need-a-power-bi-pro-licence/m-p/68688#M77 <P>Guys, is it right that all users who wish to view a power bi dashboard on SharePoint page require a Power BI liecnce ?&nbsp;</P><P>&nbsp;</P><P>If yes, Then I find this mad!&nbsp;</P> Wed, 10 May 2017 08:51:56 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/what-you-need-a-power-bi-pro-licence/m-p/68688#M77 John Gaskell 2017-05-10T08:51:56Z PowerBI: Office 365 Adoption_PreviewAprUpd data refresh disabled https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/powerbi-office-365-adoption-previewaprupd-data-refresh-disabled/m-p/67464#M76 <P>Anyone trialling this too and seeing their refresh disabled? Any pointers on why this has happened and how to fix this?</P><P>&nbsp;</P><P>Thanks</P> Fri, 05 May 2017 10:30:45 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/powerbi-office-365-adoption-previewaprupd-data-refresh-disabled/m-p/67464#M76 Philine von Guretzky 2017-05-05T10:30:45Z The data connection uses windows authentication and user credentials could not be delegated https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/the-data-connection-uses-windows-authentication-and-user/m-p/48867#M73 <P>Hi Guys</P><P>&nbsp;</P><P>In my on-premises SharePoint 2013 farm I have configured another domain as a two-way non transitive trust. I'm using the SharePoint farm to host PowerPoivot workbooks with BISM connections to an analysis services (same domain where I hosted my SharePoint).</P><P>&nbsp;</P><P>Observations : Users from my primary domain can refresh workbooks, but users in external domain cannot refresh. The error is "SPSecurityContext: Could not retrieve a valid windows identity for username 'DOMAINB\test' with UPN 'test@domainb.com'. UPN is required when Kerberos constrained delegation is used"</P><P>&nbsp;</P><P>I did following checks</P><UL><LI>Service users (claims to token service and excel services) is available in local "<SPAN>WSS_WPG" group</SPAN></LI><LI><SPAN>Claims to windows token service is started</SPAN></LI><LI><SPAN>No duplicate SPNs</SPAN></LI><LI><SPAN>Kerberos event log message "</SPAN>KDC_ERR_C_PRINCIPAL_UNKNOWN"</LI></UL><P>&nbsp;</P><P>Hope someone can shed light :)</img></P> Mon, 27 Feb 2017 11:13:58 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/the-data-connection-uses-windows-authentication-and-user/m-p/48867#M73 dinusha Kumarasiri 2017-02-27T11:13:58Z PowerBI Web Part https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/powerbi-web-part/m-p/42560#M65 <P>When will the embed PowerBI Report Modern Webpart be available in SharePoint Online. This was shown at ignite a long time ago but, there has been no news about it since then.</P> Mon, 30 Jan 2017 22:39:52 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/powerbi-web-part/m-p/42560#M65 Scott Mckenzie 2017-01-30T22:39:52Z Excel File with Data Model in SharePoint Online https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/excel-file-with-data-model-in-sharepoint-online/m-p/38037#M60 <P>I’ve been working to move a lot of my Excel reports&nbsp;to SharePoint from our file shares and have our users interact with them either directly through Excel online. &nbsp;A lot of my reports contain data that reside in the workbook’s data model (PowerPivot).&nbsp; 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&nbsp;tenant.&nbsp; 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.</P><P>&nbsp;</P><P>The file that I'm testing with is a&nbsp;basic Excel file, that contains no external data connections, and the pivot table’s data source is a table in the data model.&nbsp;</P><P>&nbsp;</P><P>Here are some of the things I’ve tried and verified to this point (our test tenant is first-release enabled):</P><P>&nbsp;</P><OL><LI>Made sure my test tenant collection and production collection matched on enabled site collection features</LI><LI>Same thing as above just for the individual site features</LI><LI>In the test tenant, I confirmed that it worked with multiple accounts, some with the free Power BI license applied and others without</LI><LI>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.&nbsp; Same error message for both accounts.</LI><LI>I’ve tried opening the file in Excel online in multiple sites in both test and production.&nbsp; The results are the same throughout, I can filter the pivot table in test but I can’t in production.</LI></OL><P>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? &nbsp;</P><P>&nbsp;</P><P>Thanks.&nbsp;</P> Fri, 06 Jan 2017 15:04:43 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/excel-file-with-data-model-in-sharepoint-online/m-p/38037#M60 Riley Hale 2017-01-06T15:04:43Z Updates for Excel Services and BI in SharePoint 2016 on-premises https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/updates-for-excel-services-and-bi-in-sharepoint-2016-on-premises/m-p/31385#M59 <P><SPAN>If your organization enables Excel Services for SharePoint to enable BI, we have some updates on what has changed with SharePoint Server 2016 BI. Updates include architecture changes to the SharePoint-based on-premises Microsoft BI Stack </SPAN><SPAN>and how you can benefit from upgrading your BI farms to SharePoint Server 2016, SQL 2016 and Office Online Server with Excel Online. </SPAN></P> <P>&nbsp;</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Architecture of the Microsoft BI Stack 2016 for on-premises" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/8711iA558807E64718B5F/image-size/medium?v=v2&amp;px=400" role="button" title="SharePointBI3.png" alt="Architecture of the Microsoft BI Stack 2016 for on-premises" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Architecture of the Microsoft BI Stack 2016 for on-premises</span></span></SPAN></P> <P><SPAN>Learn more on the <A href="#" target="_self">blog</A>.&nbsp;</SPAN></P> Tue, 22 Nov 2016 17:11:13 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/updates-for-excel-services-and-bi-in-sharepoint-2016-on-premises/m-p/31385#M59 Michael Holste 2016-11-22T17:11:13Z Struggling to keep up with all things Power BI? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/struggling-to-keep-up-with-all-things-power-bi/m-p/8157#M47 <P>We released a free Power BI News aggregation app today for Windows 10. Download it here:&nbsp;<A href="#" target="_blank">https://www.microsoft.com/store/apps/9NBLGGH51KVR</A>&nbsp; As this is a v1, any and all feedback is welcome.</P> Tue, 30 Aug 2016 16:52:19 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/struggling-to-keep-up-with-all-things-power-bi/m-p/8157#M47 Treb Gatte 2016-08-30T16:52:19Z Is there any replacement for WEEKNUM in Power BI https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/is-there-any-replacement-for-weeknum-in-power-bi/m-p/7011#M37 <P>Is there any way to find the Week Number from a Date field using a custom column in POWER BI desktop app</P> Tue, 23 Aug 2016 14:47:02 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/is-there-any-replacement-for-weeknum-in-power-bi/m-p/7011#M37 Rashid Mohammed 2016-08-23T14:47:02Z Issue powerbi getting data from SharePoint Search https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/issue-powerbi-getting-data-from-sharepoint-search/m-p/6710#M27 <P>For a Client of mine i am trying to create a dashboard of all documents in a sitecollection.</P><P>it was no problem with odata.feed. but problem with that was that i can not schedule it to refresh.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>I worked a lot out and came down to this and here is my problem:</P><P>Table.FromRows(List.Transform(element1, each List.Transform(_, each Record.FieldValues(_{1}){0} ))),</P><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>I am new to the Powerbi stuff so have tried a lot but syntax incorrect or did not work :(</img></P><P>&nbsp;</P><P>hope for some answers.</P><P>&nbsp;</P><P>Kr,</P><P>&nbsp;</P><P>Paul</P> Sat, 20 Aug 2016 11:49:48 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/issue-powerbi-getting-data-from-sharepoint-search/m-p/6710#M27 Deleted 2016-08-20T11:49:48Z Power Query refresh in SP2016 environment https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/power-query-refresh-in-sp2016-environment/m-p/6709#M26 <P>Didn’t find the latest news about that, do I understand correctly the feature is not implemented so far? If so, any hopes when it could be?</P><P>More exactly I speak about Excel2016 model published on SP2016. We are only going to deploy SP2016.</P> Sat, 20 Aug 2016 11:29:17 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/power-query-refresh-in-sp2016-environment/m-p/6709#M26 Sergei Baklan 2016-08-20T11:29:17Z Excel Services and On-Premises SQL Data https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/excel-services-and-on-premises-sql-data/m-p/3263#M12 <P>I am looking to have an active data connection from an Excel file in Excel Services on SharePoint&nbsp;Online (O365)&nbsp;that has a data connection to an on-premises SQL database.</P><P>&nbsp;</P><P>Need to be able to have data refresh work like it does with SharePoint on-premises.</P><P>&nbsp;</P><P>The DMG used for PowerBI doesn't appear to have connections for Excel.</P><P>&nbsp;</P><P>I am looking for "out-of-the-box" solution (or close to one).&nbsp;</P><P>&nbsp;</P><P>Is this still a supported scenario? It was widely used in on-premises SharePoint system as is currently blocking some key Office 365 adoption.</P><P>&nbsp;</P><P>Thanks!</P> Wed, 27 Jul 2016 13:27:41 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/excel-services-and-on-premises-sql-data/m-p/3263#M12 Eric Adler 2016-07-27T13:27:41Z displaying Power BI dashboards and charts in SharePoint on-premise https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/displaying-power-bi-dashboards-and-charts-in-sharepoint-on/m-p/2939#M7 <P>Can anyone tell me what the options are for displaying Power BI dashboards inside SharePoint on-prem?&nbsp; And can you display individual charts as well?</P><P>&nbsp;</P><P>Are there different options available for SharePoint Online?</P><P>&nbsp;</P> Fri, 22 Jul 2016 09:04:22 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/displaying-power-bi-dashboards-and-charts-in-sharepoint-on/m-p/2939#M7 Andrew van Renen 2016-07-22T09:04:22Z Why SharePoint BI? https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/why-sharepoint-bi/m-p/2446#M5 <P>Why not a standalone Power BI Group?</P> Wed, 20 Jul 2016 12:04:02 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/why-sharepoint-bi/m-p/2446#M5 Pawel Bojkowski 2016-07-20T12:04:02Z Bringing data to life using Power BI https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/bringing-data-to-life-using-power-bi/m-p/1707#M1 <P><SPAN>Hi folks,</SPAN></P><P><SPAN>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!&nbsp;<A href="#" target="_blank">http://www.slideshare.net/techChirag/bringing-your-data-to-life-using-power-bi-sps-london-2016</A></SPAN></P> Sun, 17 Jul 2016 07:49:33 GMT https://gorovian.000webhostapp.com/?exam=t5/sharepoint-bi/bringing-data-to-life-using-power-bi/m-p/1707#M1 Chirag Patel 2016-07-17T07:49:33Z