one lake
2 Topics
Error with Publishing Dataflows
I am attempting to publish a dataflow that has several different queries to a sql database, I am receiving the error listed below when attempting to publish the dataflow: For query "FactCaseMgmt", Schema evaluation did not return TableResult. Actual result type: Cancellation, Evaluation cancelled, Message: Evaluation is canceled The confusing part is that I had copied the Query steps from a PBIX file, where it currently runs every day without issue. It is also worth noting that when I attempt to publish, it tries to publish for an hour prior to returning an error message (extremely frustrating) Would appreciate any help with thisSolved5.4KViews4likes10Comments
Authentication 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.1KViews0likes6Comments