admin
3 TopicsAuthentication options for SharePoint Folder in Data Flow Gen2
Hi Experts, I come to you with a question that is bothering me. Well, in my project I have a Data Pipeline that uses Data Flow Gen 2 which has a connection to a SharePoint folder and pulls data from several excel files. Authentication is done via an account. The problem is that for this account the password is renewed from time to time and the connection can go down. Hence my question, are there any other methods to connect to SharePoint Folder in a better and less error-prone way? I was thinking about Service Principal but I have read that it gets deactivated every 100 days. Should I use another connection for ‘Web’ data or something like that to have a connection not based on the account I am using? Any suggestions would be greatly appreciated. Best regards, KonradSolved3.1KViews0likes6CommentsMicrosoft Fabric Data Pipeline + Power BI API Scanner
Hello, I'm looking to set up a data pipeline Fabric, I started by creating a copy data activity to retrieve a list of workspaces. But then I'm stuck, I can't manage to break down this list into packages of 100. Then for each block of 100 call the PostWorkspaceInfo API. Does anyone have any ideas? Best regards, Charline2.1KViews0likes5CommentsUnable to select lakehouse our warehouse in a pipeline (Copy data)
Hello everyone, I'm currently working on setting up a pipeline to transfer data from my Lakehouse to my Warehouse. However, I've encountered a difficulty: neither the Copy Assistant nor the Copy Canvas display the names of my "houses". I've attached an image below for further clarity: typo *appear Interestingly, after several page refreshes, the Lakehouse name finally appeared. However, when it came time to select the data destination, my Warehouse did not appear on the selection list. Then I refresh the page again and my Lakehouse disappeared from the list. Both Lakehouse and Warehouse are saved in myworkspace. Could this be a bug? If anyone has encountered this issue before, or if anyone has insights on how to remedy this situation, I would greatly appreciate your assistance. Thank you in advance for your time and help!2.5KViews0likes6Comments