If you set the credentionals on data source settings ist just for the current site dosen't matter if you set publicįor me that is a bug. ![]() Now with the version these setting is gone and for every site that is specified you need to enter the credentials because is set to anonymus. In early version of Power Query (20) if you first time use the query, you have the specify your credentials and you could choose if you want to set those credentials only for the current site or for the webapplication (The version we build the Than we have a loop function to to query a SharePoint List in all of these Site Collections (also based on Odata Feed). Please upgrade to a newer Excel version. (Note: The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. ![]() The SharePoint list has a url column and these column links to other site collections in SharePoint Site Collections. Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. Again, your data could be stored in Excel files, csv files, Access, SQL server database, SharePoint, Salesforce. You use the buttons in the Data or Power Query tab to get your source data. ![]() Do they take a lot of time and effort to repeat the same task over and over again If your answer is yes then it. Once installed, the Power Query tab will be visible in the Excel Ribbon. Power What Do you spend a lot of time building dashboards and reports in Excel. We have build a query to access a SharePoint list through odata feed (SP 2013 OnPrem). In Excel 20 for Windows, Power Query is a free add-in.
0 Comments
Leave a Reply. |