Tag: Data Flow

What is Common Data Service (CDS) and why it is important for you if you use Power Apps or Power BI?

Posted on by Reza Rad

For the world of Power Apps users, the Common Data Services (CDS) might be more understandable, however, in the world of Power BI users, we still have many who don’t know what it is and what is the use cases of it. So I thought better to write about it in this article, and explain Read more about What is Common Data Service (CDS) and why it is important for you if you use Power Apps or Power BI?[…]

AI in Dataflow, Azure ML Studio Integration with Power BI Services – Part 3

Posted on by Leila Etaati

  In the last two parts, first how we able to use cognitive service in Power BI service (Data flow) has been explained. Then in the second one, the process of using a Pre-built machine learning model for prediction ( classification, regression, and forecasting) has been explained. In this post, I am going to show Read more about AI in Dataflow, Azure ML Studio Integration with Power BI Services – Part 3[…]

Difference Between Connection Managers used in SSIS Control Flow Tasks and Data Flow Components

Posted on by Reza Rad

Hi folks, Today I face a question regarding usage of OLE DB VS. ADO.NET Connection managers in SSIS, there are some blog posts about difference between connection providers and speed and performance of them. So I thought that this will be helpful if I list different Control Flow Tasks and Data Flow Components in SSIS Read more about Difference Between Connection Managers used in SSIS Control Flow Tasks and Data Flow Components[…]

How to handle Failed Rows in a Data Flow

Posted on by Reza Rad

suppose this scenario: you have a source table and a destination table, you want to transfer rows from source table to destination table, so you can use simple data flow with OLE DB source and OLE DB Destination. but problem hits when destination table has few rows inside, and there is Unique Constraint in ID Read more about How to handle Failed Rows in a Data Flow[…]

Excel to SQL Server, Dynamic Data Flow

Posted on by Reza Rad

You need to import data from excel file to sql server table, you can do this with a simple import wizard or simple data flow task in SSIS. But there are lots of times which you want to do this data transfer dynamically. Suppose these scenarios: 1- you have many excel files with same structure Read more about Excel to SQL Server, Dynamic Data Flow[…]