Olgun AydınSAP Raporlarını PowerShell ve SAP GUI Scripting ile Otomatikleştirme ve SSIS ile ETL SüreciSAP kullanarak rapor oluşturma süreci genellikle manuel parametre girişlerini ve raporları tek tek indirmeyi gerektirir. Ancak, tekrarlayan…5d ago5d ago
Olgun AydınSending Power BI Report from Mail Address with Power AutomateSending reports in xlsx or other formats on Power BI can only be applied in paginated reports format. In addition to this problem, we…Jun 12Jun 12
Olgun AydınAutomatically export VMware machine measurements to database with PowershellThe metrics of VMware machines can be tracked on VMware. However, customers may also want to see the latest status of their machines…Mar 19Mar 19
Olgun AydınPowershell ile Power BI Cloud Üzerinde Backup Alma SüreciBildiğimiz üzere Power BI cloud üzerinde raporlar Microsoft tarafından korunuyor fakat raporları sürekli indirme ve geriye dönük şirket…Sep 29, 2023Sep 29, 2023
Olgun AydınTemp table error when getting data from procedure with direct query in Power BIIn Power BI, we can use temp table structures on SQL while getting data with direct query. Power BI is not very comfortable with the temp…Apr 9, 2023Apr 9, 2023
Olgun AydıninAkkim AkademiHow to create an on-premises Data Warehouse (DWH)?In our in-house reports, we were pulling the tables from our database and processing them on the business intelligence tool. Inevitably, we…Oct 6, 2022Oct 6, 2022
Olgun AydıninAkkim AkademiGet Calculated Value From Previous Row With OLE DB CommandSometimes, I can’t perform an operation in SQL. Because, It is don’t allow this. We can get help from SSIS or ETL tools in this regard. It…Aug 12, 2022Aug 12, 2022
Olgun AydıninAkkim AkademiHow to use Emoji’s emotions on Power BI?Emojis are frequently used when creating a sales report.In other reports, emojis are often used to express the situation on cards and…Jun 20, 2022Jun 20, 2022
Olgun AydıninAkkim AkademiAzure SQL to SQL Server Connection-Azure SQL Table UploadWhat is Azure SQL?Apr 28, 2022Apr 28, 2022
Olgun AydıninAkkim AkademiRow Based Security (RLS) on SQL Server Reporting Service (SSRS)SSRS, one of the three services that SQL Server offers us free of charge, is actively used in daily business life. Particularly in…Feb 27, 2022Feb 27, 2022