Creating Tables in Power BI (2022-05-02)

SQLServerCentral Newsletter for May 2, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Creating Tables in Power BI]( - [Creating Flyway Migration Files using Redgate Schema Comparison Tools]( - [Clustering data for insights]( - [From the SQL Server Central Blogs - A Monthly Running Total–#SQLNewBlogger]( - [From the SQL Server Central Blogs - Microsoft Graph API in Power Automate: Registering the App in Azure]( Question of the Day - [Migrating to Synapse]( The Voice of the DBA  Daily Coping Tip Take an extra break in your day and walk outside for 15 minutes 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. Testing or Learning All of us get into challenging situations. This might be a coding problem that we struggle to solve. It might be an argument with a co-worker. It could be feedback from a customer on how we dealt with them or maybe just how our app works. Our responses to a challenge might determine how we view the situation, our future actions, or even just how we react to life in the next few hours. When someone struggles or feels as though they have failed in a situation, they tend to react in one of two ways. They can view the experience as though it were a test and they didn't pass. This is quite common among many people, who might become sad, angry, or defensive. They might defend their approach or look for an excuse. They might seek to put the whole situation behind them and move on. This is a common reaction and one I've had often. Like many people, I want to do well, and when I don't, it can feel as though I've failed or I am being attacked. Whether because of my words, actions, or code, I know I've often reacted in a way that I somewhat regret. I will try to solve the problem better, apologize, or find some way to rectify the situation, but it still feels like some sort of personal failure. The other way to view the situation is a learning opportunity. Things didn't go well, but how can I improve things in the future. How can I improve myself, or what can I learn? Maybe, more importantly, this reaction often has the person looking for a similar challenge and the chance to do better the next time. How do you approach a challenge? Do you view most things as tests or learning opportunities? I tend to view many things as tests, but I am trying to change and learn how to view them as opportunities to learn. When I don't or can't solve a problem, I look to find out how I can improve my thinking and skills and at least solve that problem in the future. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Creating Tables in Power BI]( Daniel Calbimonte from SQLServerCentral This article shows how we can create tables in Power BI using code and DAX functions. [External Article]( [Creating Flyway Migration Files using Redgate Schema Comparison Tools]( Additional Articles from Redgate How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files. [External Article]( [Clustering data for insights]( Additional Articles from SimpleTalk Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick demo. [Blog Post]( From the SQL Server Central Blogs - [A Monthly Running Total–#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was looking at some data and... From the SQL Server Central Blogs - [Microsoft Graph API in Power Automate: Registering the App in Azure]( Devin Knight from Devin Knight This video is one in a four-part series walking you through how to leverage the Microsoft Graph API within Power Automate. In this first video,   Question of the Day Today's question (by Steve Jones - SSC Editor):  Migrating to Synapse I want to migrate a database to Azure Synapse Analytics in May 2022. Can I use the SQL Server Migration Assistant (SSMA)? 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) Managed Instance Automatic Tuning Which of these actions for automatic tuning are available in Azure SQL Managed Instance (as of Mar 2022)? Answer: automatic plan correction only Explanation: In Azure SQL Managed Instance, the only automatic tuning option (as of Mar 2022) is Automatic Plan Correction. Ref: Automatic Tuning Options - [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 [Transaction Log Growth During a Delete]( - Our company has a database containing a single table that is used to log actions in our Mailer process. This database can grow larger than I would prefer in a short period of time. I am constantly having to shrink it and the other tables used in the Mailer process. The logging table currently has […] [NT Authority/System User failed to open Model database]( - Hi, I am seeing messages every day failed to open explicitly specified database model for the user NT Authority/System [Client: Local machine]. We don't have any jobs that run with that NT Authority/System . All jobs are running as sa only. I verified that there are no linked servers created. We have the 3rd party […] SQL Server 2017 - Development [sql rowstore vs columnstore]( - Currently I have a table with 100 Million rows of telemetry data using rowstore indexes. I was not familiar with columnstore indexes when I set this up and understand columnstore is more ideal for this type of data. How should I go about converting the existing table? Anything particular that I need to know with […] [How to prevent change columns name header when export sql server table to exce?]( - How to prevent change columns name header when export sql server table to excel file for second time? I work on sql server 2017 i have script python export SQL server table students to excel path When run script below excel file exported success with data and headers for first time only when use script […] SQL Server 2016 - Administration [ADD database's in AG]( - I have an requirement to automate adding databases to AG .I need to add multiple databases (150+) to AG .every month as part of the activity we need to refresh the data with prod in dev servers .the databases are configured in always on . we need to remove the databases from AG and again […] Development - SQL Server 2014 [Error - not a valid identifier]( - Hi ​  I am getting below error. Msg 203, Level 16, State 2, Line 20 The name 'select Name, [Item1],[Item2] from (select name,quantity,itemname from #temp) x pivot (Sum(quantity) for itemname in ([Item1],[Item2])) piv ' is not a valid identifier. declare @cols as nvarchar(max)=''; declare @query as nvarchar(max)=''; select @cols = @cols + QUOTENAME(ItemName) + ',' […] [how to get the result of amount used based on setup range table]( - assume i have 2 tables CREATE TABLE #Setup ([PPHProfileNo] INT, [%DPP] MONEY, RangeFrom MONEY, RangeThru MONEY, [%PPH] MONEY) INSERT INTO #Setup VALUES (1,50,0,60000000,5) INSERT INTO #Setup VALUES (2,50,60000001,190000000,15) INSERT INTO #Setup VALUES (3,50,190000001,250000000,25) INSERT INTO #Setup VALUES (4,50,250000001,4500000000,30) INSERT INTO #Setup VALUES (5,50,4500000001,999999999999,35) CREATE TABLE #Transaction ( [VendorID] [varchar](10) NOT NULL, [Year] [int] NOT NULL, […] SQL 2012 - General [MS SQL Server 2012 Bible, any opinions on this book?]( - Hello, the book MS SQL Server 2012 Bible is on O'Reilly's daily deal and I was wondering if anyone had any opinions or thought on it. I have been learning how to work SQL queries and databases at work for a project and am trying to decide if this book is worth buying. SQL Server 2019 - Administration [System database replication]( - Hi, I've never needed to worry about this before, but an incoming application writes data to the master database during its installation. So although after install of said application we can make its databases HA in an AG, the replica(s) won't have that vital data in their master databases so the application will fail when […] [Upgrade failure: This installation is forbidden by system policy]( - We are trying to upgrade one of our development SQL Server 2016 SP3 named instances to SQL Server 2019. Each time we received the following error. Action required: Use the following information to resolve the error, and then try the setup process again. Feature failure reason: An error occurred for a dependency of the feature […] SQL Server 2019 - Development [sql query help]( - I have below the table structure and data. I'm trying to write a query that will return me SubmissionGuid only if NONE of the records associated with that submissionguid has quote status =1 . for example in the below records I have submissionguid 2A9FDC62-DF94-45DF-ABA0-DA7BBAC4B6D5 which has 3 records and 2 of them have quotestatus =2 […] [Removing schema references]( - Hi all, I uploaded Adventurework2019.bak file to do a course on Udemy and found that all the tables have a prefix.tablename nomenclature. Is there a way to remove all the schema prefixes ? When I try DROP SCHEMA IF EXISTS PRODUCTION, I get a message schema cannot be dropped as it is being referenced by […] Amazon AWS and other cloud vendors [GPU accelerated instances]( - Hi. I want to explore AWS capabilities in terms of graphics programming (I am not sure I want to spend a ton of money on a powerful home PC, considering how expensive GPUs are). Are there EC2 instances with Nvidia GPU attached which fully support DirectX, OpenGL, Vulkan, CUDA? How can I setup one? I […] SSRS 2016 [SSRS 2016 - Headings in Subreports being removed in render]( - Hi All, Thanks for the input in advance. I’ve created a main report which features multiple sub reports. Each sub report is in a box so that it can have a page break at the end of each report. This is so that each report can appear on a separate sheet in Excel once it’s […] Integration Services [sqlcommand.timeout]( - I have a ssis package that gets data from oracle to SQLserver, use ado.net source task. Very occasionally I got a failure message that says ora-03113 end of file on communication channel. This usually means a server disconnected from oracle. a sudden drop of connection. I see in ado.net there is a property for sqlcommand.timeout, […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -