How To Extract data from Sharepoint Online using Power BI

How To Extract data from Sharepoint Online using Power BI


Code Snippet as below:

let
    Source = SharePoint.Files("https://XYZ.sharepoint.com/", [ApiVersion = 15]),
    #"Sprint Backlog.xlsx_https://XYZ.sharepoint.com/Reporting  Forms/" = Source{[Name="Sprint Backlog.xlsx",#"Folder Path"="https://XYZ.sharepoint.com/Reporting  Forms/"]}[Content],
    #"Imported Excel" = Excel.Workbook(#"Sprint Backlog.xlsx_https://XYZ.sharepoint.com/Reporting  Forms/")
    
in
    #"Imported Excel"

Comments

Post a Comment

Popular posts from this blog

Request failed with HTTP status 503 Server Error

Image
Problem: When 100's of users ae trying to access Reporting services report then, SSRS throws error as below : "Request failed with HTTP status 503 Server Error" and how to resolve this error Solution: From experience, this issue can be caused by multiple reasons Problem might be related to: 1 - TCP/IP Port Exhaustion: When a client initiates a TCP/IP socket connection to a server, the client typically connects to a specific port on the server and requests that the server respond to the client over a short-lived TCP or UDP port. The default range of short-lived ports used by client applications is 1025 through 5000. Under certain conditions, it is possible that the available ports in the default range are exhausted. 2 - If you are using any custom assembly method in any of your report (say for example PrivateFontCollection class or anything else), if yes then you might want to review that 3 - Change MaxActiveReqForOneUser from its default value o...
Read more

Removing and Manipulating Time portion from DateTime in SQLServer

Image
One of the common transformation we would have to do as part of ETL would be manipulating Time portion. Please see some of below code, which would help to resolve some of the time related transformation Case1 - Getting only Date portion from DateTime /* Removing Time portion from DateTime */   Select -- Standard date with time   getdate () As DateWithTime , -- Returns Date Portion Only   dateadd ( d , 0 , datediff ( d , 0 , getdate ())) As DateOnly Result as below: Case2 -  /* Removing Seconds from DataTime */ /* Removing Seconds from DataTime */ declare @t datetime set @T = GETDATE () SELECT @T as Original , DATEadd ( ss ,- datepart ( ss , @t ), @t ) as wihtout_sec -- if no milisecs , DATEADD ( mi , DateDiff ( mi , 0 , @t ), 0 ) as OneMore_Variation Case3 - We want to Keep Hours but remove Minutes and Seconds from DateTime /* Keep Hou...
Read more

First hit to Reporting services is slow

Problem: First hit to Reporting services is slow Proposed Explanation and solution: This is because IIS is a demand-driven web server, i.e. IIS does things only when asked for. For example: an IIS worker process spawns up only when requests arrive for the sites that are hosted in this worker process. So when someone hit the reporting service for first time then it will perform some of the initialization activities such as: Initialization of data structures Loading data from a datastore into memory  (caching) Compilation of code, e.g. .NET applications Establishing database connections Recommendations: 1 – Spinning up an app pool can take some time and make the application less responsive so keeping them up for longer can help performance, so may be changing default recycle time from 720 min (12 hours) to 2880 min (48 hours) will help the performance 2 – Create and run simple scheduled report to keep SSRS active running every hour. For example: A simple ...
Read more