How to Visualize Python Charts in Power BI (2022-08-15)

SQLServerCentral Newsletter for August 15, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to Visualize Python Charts in Power BI]( - [Re-baselining a Database using Flyway Desktop]( - [Metrics that matter for IT organizations on an agile journey]( - [From the SQL Server Central Blogs - Max server memory recommendations are just a suggestion]( - [From the SQL Server Central Blogs - SQL Homework – August 2022 – Replication part 1]( Question of the Day - [GENERATE_SERIES Permissions]( The Voice of the DBA  Daily Coping Tip Make some tasty food for someone who will appreciate it. I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Reducing Debt and Increasing Security Many of us know that reducing financial debt in our lives leads to a bit more security in our minds. We are better able to cope with unexpected expenses when we have the ability to get credit or pay for something in cash. If you've ever had a major house repair, car calamity, or (hopefully not) medical issue, you know what I mean. At least in the US. That last one is less of an issue in many other countries. We know that our code has technical debt, and often we fight a battle with project managers and business people over whether we should spend time paying down that technical or developing new features. We certainly can do both, but often that's not a choice we are given. If we do get the chance to reduce technical debt, it's a tiny fraction of the time that is allocated to adding something new. There might be a better argument to reducing some technical debt: security. There's [an article that talks about the security risk]( posed by moving too fast and not ensuring here is rigorous security testing. This is a common problem in many companies that adopt some of DevOps, but forget that quickly deploying new code isn't the only principle. We also need to learn from our mistakes and quickly correct them. I am a big fan of releasing often, especially for security purposes, but those releases need to build on each other with not only new code but refactored old code that doesn't perform well or has a security issue. More importantly, we need to ensure when we find issues in code, that all developers are aware of the problem and don't repeat the issue. We also need to update our testing to ensure that humans don't continue to write code in a style that causes known issues. This is less of a developer issue than a managerial one. The C-suite and all management that are involved in software need to prioritize security so that known issues are fixed quickly. This also should involve ensuring that technical debt is kept under control as a lot of this poorly written code increases the chances that a vulnerability is in the code. Either because the code isn't well written or because developers avoid touching the code in the future. The best solutions, to me, involve DevOps. Make small changes, deploy them, instrument them, and learn if they work well. If not, fix them quickly. While this might end up delaying some features, ultimately it ensures that our software is in better shape, with a reduced risk of simple security mistakes upsetting our customers. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to Visualize Python Charts in Power BI]( Daniel Calbimonte from SQLServerCentral This article will show how you can code in Python and produce a chart for Power BI. [External Article]( [Re-baselining a Database using Flyway Desktop]( Additional Articles from Redgate Over time, Flyway projects can accumulate a lot of migration scripts, with many database objects being created, altered, and dropped across many files. Tonie Huizer explains why you might want to create a new baseline migration file to create the latest version of a Flyway-managed database in a single leap, and how to persuade Flyway Desktop to do it. [External Article]( [Metrics that matter for IT organizations on an agile journey]( Additional Articles from SimpleTalk Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile. [Blog Post]( From the SQL Server Central Blogs - [Max server memory recommendations are just a suggestion]( Randolph West from Born SQL with Randolph West Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan Kehayias. The chart has... [Blog Post]( From the SQL Server Central Blogs - [SQL Homework – August 2022 – Replication part 1]( Kenneth.Fisher from SQLStudies You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading   Question of the Day Today's question (by Steve Jones - SSC Editor):  GENERATE_SERIES Permissions In SQL Server 2022, I want to allow a user permission to execute the GENERATE_SERIES function. What minimal permissions does the user need? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Python in Power BI I want to use Python to import data into a Power BI Desktop report. If I have the need to pick a specific version of Python that is used to run scripts, what are my options? Answer: In the Power BI Desktop options, you can select the version of python based on what is installed on your system Explanation: If you have multiple versions of Python on your system, you can select the Options menu in Power BI and there is a Python Scripting section where you can select the version of python to use. Ref: - How to Get Data Using Python in Power BI - - Run Python Scripts in Power BI Desktop - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [Which version of SSMS to connect to SSIS 2008]( - I suspect that an SSIS package in source control is not the latest deployed version in production. I want to pull the current deployed package from the production server and check its logic. This package is deployed to an old SQL 2008R2 box that I'm currently working on moving all the SSIS packages off and […] SQL Server 2017 - Development [DB Mail sysmail keeps stopping. sysmail_start_sp takes forever and never finshes]( - i use exec dbo.sysmail_start_sp to start DB Mail but it keeps running forever. When i check the status using EXEC dbo.sysmail_help_status_sp , it shows Started. But i automcatically goes in STOPPED mode and i have to restart DB Mail. None of the emails are going through and can be viewed in sysmail_mailitems table with status […] [SSIS Rows per Batch and Max Insert Commit Size]( - I have an SSIS package which is copying 5 large tables daily. There is no WHERE logic in these data pulls, every record is selected and the source tables will only keep growing. Currently, we are now at the point where the SSIS package causes the Transaction Log on the target SQL Server to run […] SQL Server 2016 - Administration [Truncate partition table failed due to index not partition. Help please.]( - I have 1 table which has a partition on Date column. However this table has a unique constraints on it's ID. Here's how the table creation script looks like. CREATE TABLE [TestDB].[dbo].[tblDS2]( [GSN_ID] [varchar](50) NOT NULL, [DS2_Lot_ID] [varchar](50) NULL, [DS2_SubLot_ID] [varchar](50) NULL, [DS2_X] [smallint] NULL, [DS2_Y] [smallint] NULL, [DS2_Bin] [varchar](10) NULL, [DS2_Date] [smalldatetime] NULL, [GsnBeforeFix] […] [Can I retrieve T-SQL from Maintenance Plan without using GUI?]( - Can I retrieve T-SQL from Maintenance Plan steps by running a query ? (without using GUI in SSMS) [Stored procedure able to be built over table that doesn't exist]( - SQL 2016 SP3 So we're updating some procedures to use a different table, it's the same name but different schema, neither one uses the dbo schema. The table under the old schema has been deleted. I found that I was able to successfully build the procedure even though I missed changing one of the references […] SQL Server 2016 - Development and T-SQL [Read multiple files of same name and process in DB]( - Hi All, I have a requirement like, we will receive multiple csv files in a shared path and those files needs to be processed to the corresponding tables. Say for eg: if Employee file has 3 files like employee_2022_08_08_11_11 / employee_2022_08_07_12_00 / employee_2022_08_08_16_07 i need to process these three files to my employee table and […] Administration - SQL Server 2014 [Sql Reconfigure]( - Hi Will the below script will stop services ot will execute without restarting services sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'max server memory', 65536; --64GB GO RECONFIGURE; GO WAITFOR DELAY '00:02:00'; GO sp_configure 'max server memory', 215040; --210 GB GO RECONFIGURE; GO Thanks  Development - SQL Server 2014 [Use 2 CTEs in a Single SQL Query]( - Hi , I'm trying to union 2 CTE queries into one. but must be missing something. as I get an issue after the union . I tried a few things but no luck. Im trying to select different Meshtypes as per query. The first CTE is sum_cte and the s2nd is sum_cte2 this is what […] SQL Server 2019 - Development [Finding Special Characters in Email Address]( - Hi All, I have to find the special characters in email address apart from alphabets, numbers SELECT EmailAddress AS ValidEmail FROM Contacts WHERE EmailAddress LIKE '%_@__%.__%' AND PATINDEX('%[^a-z,0-9,@,.,_,\-]%', EmailAddress) = 0 GO  Regards Sathish Kumar [when check directory at shared path remotely it display not exist (false) althou]( - when check directory at shared path remotely it display not exist (false) although it exists I have shared path '\\192.168.7.9\Import\8' I face issue when try to check this directory path exist or not . when run script python on sql server 2019 it must return true because directory path exist but my issue is python script return […] SQL Server 2008 Administration [How to restore a database with Full Text Search]( - HI, The SQL Server instance is 2008 R2. I have a database with a Full Recovery Model and Full Text Search. I need to make a copy of the database on the same server. I have used SSMS to make a backup of the database. I checked the box "Copy-only backup". I want to create […] Azure Data Factory [Any good resource to learn Data Factory ?]( - I just joined a company and I'm new to Azure. It's a powerful tool but I don't like Data Factory because it reminds me of SSIS and I think it's just clumsy and quite difficult to create pipelines, let alone debug them. Although, I don't know of I hate it because I don't know how […] XML [XML Query to return xml element as column for specific attribute value]( - Despite having read several articles/examples, I can't solve what seems like it should be a simple problem -- How do I return an xml element value as a column for a specified value of an attribute in that same element. e.g.,   31 -- How I return this as LengthMinutes?   […] Integration Services [How to unzip the Updates files and avoid which are already unzipped?]( - Hi everyone, I recently started using WinSCP. I download some .zip files using it from a remote server on a daily basis. These files are basically updates that arrive on the server on a daily basis and save to my local folder: D:\Updates\ Named like these: UPDATE_20220805.zip, UPDATE_20220804.zip, UPDATE_20220803.zip, UPDATE_20220802.zip .....  I want to […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -