ADF copy activity with salesforce connector doesn't work.
I'm changing my pipelines that copy data from salesforce into a file, because the old salesforce linked service will stop working in october. I created a new linked service, a new dataset and changed my copy activity into the new source dataset. Now, I…
How can we access SQL Server hosted on on-premises from Function app
I am trying to access SQL Server hosted on Azure VM from Function app using python. But I am getting this error: Result: Failure Exception: OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login…
Unable to connect SQL server to Azure data factory
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-1J7NBOS', Database: 'DataWarehouse', User: 'ak2'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the…
Why does impersonation (Execute as) work in a User database and not in the master database in Azure SQL DB?
Execute As User = 'User1' doesn't work in the Azure SQL DB master database. User1 account created in the master database and in a user database. Execute As User works in the user database and in the master database, receives the error: Msg 15517, Level…
New Phone: Microsoft authenticator app is not working during switching to my personal directory
The Microsoft Authenticator app is working ok when I use my company's subscription. But as soon as I try to switch to my personal domain , which is also linked with my company's email , it asks for Approve sign in request but it never reach to The…
Content type changes when using copying file from one blob to another using extra outputs (blob storage binding)
I'm a TypeScript developer trying to build a flow using Function App. The flow is very simple: when a file gets uploaded to Storage Blob a message containing the filename is dispatched on Storage Queue which triggers another function (doc-analyse) that…
how to fix Error SQL71501: Error validating element [dbo].[int ]: Column: [@tWebCheckins].[TenantID] has an unresolved reference to Built-in Type [dbo].[int ]. Error SQL71501: Error validating element [dbo].[int ]: Column: [@tAttendance].[TenantID] has an
Error SQL71501: Error validating element [dbo].[int ]: Column: [@tWebCheckins].[TenantID] has an unresolved reference to Built-in Type [dbo].[int ]. Error SQL71501: Error validating element [dbo].[int ]: Column: [@tAttendance].[TenantID] has an…
Delete the file from SharePoint location
Hi All, I am trying to copy the files from Share Point to ADLS and referring to the below URL pipeline to achieve the copy functionality. https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-factory/ I need…
Dynamic Time series using ADF data flow - rule based mapping
Can i get expression for rule based mapping in data flow using select transform, my dataset is "allow schema drift" enabled, but i want to maintain new schema always don't want to keep old time series headers from mapping. Let me know if this…
ADF expression cannot be evaluated because property 'property_name' cannot be selected. Property selection is not supported on values of type 'String'
I have created a parameter with name p_persondetails of OBJECT type, below is the paramater value. { "property_name": { "key1": "value1", "key2": "value2" "key3":…
I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues.
I am encountering an error when trying to debug a data flow in Azure Data Factory that connects to an Azure SQL Database. My linked service and dataset connections to the Azure SQL Database are working fine, and I can preview data without any issues.…
Disaster Recovery for Power BI Embedded in Azure
I want to plan a disaster recovery (DR) strategy for my Power BI Embedded resource. Currently, I have a Power BI Embedded resource active in the US East region. Now, I want to replicate this setup in my DR region, which is US West. This is because I want…
Can you setup Azure CDN custom origin to be public IP address of windows azure virtual machine running IIS
Trying to see if this is even possible. I have Azure Virtual Machine running as a windows webserver IIS. Is it possible to setup Azure CDN to pull content from that webserver? Things tried. Created CDN. Changed Origin to custom and set the public IP…
Effect of MC792991 Disablement of Symmetric keys for Microsoft Entra first-party applications Service Principals
Hello Team, Greetings! This is Joni. Due to the Microsoft post as follows, a partner need to address how this affects to end users' resources and workloads. Disablement of Symmetric keys for Microsoft Entra first-party applications Service Principals…
vHub private route intent blocking traffic to and from UDR.
This is not a duplicate of previous question as it only relates to private intent. UDR - 172.16 core - 172.20 onprem -192.198 I am trying connectivity by simulating a production migration scenario. I am simulating existing third party appliance with…
Why are Reservations not available for Ddsv5 instances on Azure PostgreSQL Flexible Server?
I'm calculating the cost of Azure PostgreSQL Flexible Server which uses Ddsv5 instance and notice that Reservations for this series and Dadsv5 instances are not available. Is there an explanation for this? Reservations are available for the older Ddsv4…
Need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server.
We need to know ETA of reservations support for V5 instance series of Azure Database for PostgreSQL flexible server, as we're thinking to upgrading all of our servers to V5 along with taking benefit of reservations for it.
how to split a csv file based on columns.
Hi Team, There is a scenario in which we have to split columns of a CSV file into unique files in blob. for example let's say I need to create each file based on the combination of (TimeStart + TimeEnd + A) i.e. three columns per file and filename would…
ADF unable to call internal API via web activity with self-host Integration Runtime
Hi, I am working on a project with Azure Data Factory. We have setup an internal application and provided a API for updating record, and we would like to trigger a POST call by web activity in ADF (with Self host IR), but failed with the follow…
Issue while accessing Azure Policy REST API in Power BI - Getting Error: Access to the resource is forbidden
I am trying to access Azure Policy Compliance data from Azure Policy REST API to Power BI. To access the Azure API into Power BI, I have registered an application in Entra ID and generated Client ID and Client Secret. In the App Permission, I have…