Power BI: Organisational Content Pack not visible to other users

Recently, we created a content pack in power BI with access to entire Organisation as shown below: After creating it, we used another user to search for this content pack in Power BI and see the result. However, we didn't find any content pack by clicking on Get Data --> My Organisation or Get Data … Continue reading Power BI: Organisational Content Pack not visible to other users

SSIS: The component returned a failure code when the pipeline engine called PrimeOutput()

Recently, while working on SSIS package, we encountered the error after few minutes of execution of package. To get rid of this issue, we implemented one workaround: Go to Data Flow --> Properties Decrease the default buffer size to 1MB i.e. 1048576 Bytes Decrease the default Max Buffer rows to 1000 as shown below: After … Continue reading SSIS: The component returned a failure code when the pipeline engine called PrimeOutput()

SSIS: The column with the sortkeyposition value of 1 is not valid. It should be 0

Recently, while working on one of the existing SSIS package, we found that there were number of sort blocks in SSIS where as it could have been sorted at the source itself and informing the SSIS package that the data is already sorted at the source and can be processed further. Another disadvantage of using … Continue reading SSIS: The column with the sortkeyposition value of 1 is not valid. It should be 0