Import Web pages with Power BI (2022-03-21)

SQLServerCentral Newsletter for March 21, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Import Web pages with Power BI]( - [Working with MySQL tables]( - [Think you know SQL Monitor? Think again.]( - [From the SQL Server Central Blogs - Populating a Microsoft Word Template using Power Automate]( - [From the SQL Server Central Blogs - Query Plans in Azure Data Studio]( Question of the Day - [Starting a Pipeline]( The Voice of the DBA  Daily Coping Tip Stop. Breath. Notice. Repeat regularly 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. Is CosmosDB the One? The question asked of Keanu Reeves in the first [Matrix]( by many of the characters is whether he is the one. THe one that can save the world, and make a difference in their war. It's a fun movie, and one I've enjoyed many times. Keanu doesn't really believe he's that special until the end. That's in contrast to the products that most vendors build. Most of the times I think developers, marketers, salespeople, or all three think that whatever they've recently released is the best thing ever. CosmosDB is mentioned in a piece as the [potential one database to rule them all](. The article talks about some of the basis and value that come from the platform, which Microsoft continues to push as the database that can store any kind of data and meet the needs of any application. Whether you believe that or not, I find many articles and blogs from developers that are experimenting and building systems on top of CosmosDB. I do think the consistency models for CosmosDB are interesting, and having a variety of these models across a distributed RDBMS table would be great. I'd love to be able to insert data into a table, have it not available as a live value until committed on other nodes, and avoid locking my table. I realize I'm asking for something that seems like a bit of magic, but I bet Microsoft could add this to the SQL Server relational engine. CosmosDB is very interesting to me, and it's an item on my list that I want to learn more about. I think there are certainly domains of problems where CosmosDB would fit very well. If any of you are working with CosmosDB, I'd be interested in knowing why and how it fits for your particular environment. There was a quote in the article that I thought was interesting. A Microsoft Technical Fellow said, “No data is born relational. In the real world, nobody thinks in terms of schemas — they think graphs or maybe JSON document if you’re an IOT device..." That's interesting. If I produce a JSON document, am I not thinking relational? Do I not expect that most strings, values or arrays will exist in most of the documents? Am I not thinking schema, even ragged schema, from the beginning? I'd think most data relational. It's just not easy to get it into that format when you deal with many instances of data. Of course, dealing with many instances of data is hard for most humans. That's why we built relational databases. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Import Web pages with Power BI]( Daniel Calbimonte from SQLServerCentral Introduction In this article, we will learn how to create charts from web pages with Power BI. Power BI is an extremely great tool to easily generate reports. We will combine and analyze data from different websites, and we will talk about COVID 19 with the reports. In order to analyze the information, we will […] [External Article]( [Working with MySQL tables]( Additional Articles from SimpleTalk After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts. [External Article]( [Think you know SQL Monitor? Think again.]( Additional Articles from Redgate You spoke we listened We are dedicated to listening to what our customers want and need and implementing feedback accordingly. Learn about how SQL Monitor has evolved, and the key features we've added, since 2018. From the SQL Server Central Blogs - [Populating a Microsoft Word Template using Power Automate]( Devin Knight from Devin Knight In this video, Devin will guide you through leveraging Power Automate to automatically populate a Word template. This could be used for automatically populating a [Blog Post]( From the SQL Server Central Blogs - [Query Plans in Azure Data Studio]( Grant Fritchey from The Scary DBA I have long been a fan of Azure Data Studio, but one shortcoming has kept me from truly adopting it: Query Plans in Azure Data Studio. Sure, there was...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Starting a Pipeline In Azure Data Factory, which item will initiate the execution of a pipeline? 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) Saving Synapse Money You have a dedicated SQL Pool in your Azure Synapse Analytics Workspace. This pool is used heavily during the day, but from 8pm local time until 6am, it isn't accessed. What is the easiest way to save money in this situation? Answer: Pause the pool at night and resume it in the morning Explanation: The easiest way to save money for a dedicated SQL pool that is not being used is to pause it. This will eliminate the costs for the compute overnight. You always pay for storage. Ref: Dedicated SQL Pool - [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 [Need advice on optimizing a query]( - Hi All, We have an application internal query which runs multiple times and it is taking ~30 mins. The query is selecting data from a VIEW. Wanted to know the causes of slowness of the query and looking for any possible recommendations. This database is vendor specific database and the query is generated/executed by that […] SQL Server 2016 - Administration [Changing license in SQL Cluster environment]( - Hello, We have installed Enterprise edition for SQL Serve cluster environment (Two node) based on client requirement. But, now client wanted to change the SQL server edition to Standard edition due to some licensing issue. Is there any option to downgrade SQL cluster from Enterprise to Standard edition or do i have to completely destroy […] [Free Space on Clustered Environment]( - Hello! The script outputs the mounted disk information, what do I need to incorporate to get information for drives that are local to that particular node like C:\? SELECT DISTINCT volume_mount_point [Disk Mount Point], file_system_type [File System Type], logical_volume_name as [Logical Drive Name], CONVERT(DECIMAL(18,2),total_bytes/1073741824.0) AS [Total Size in GB], ---1GB = 1073741824 bytes CONVERT(DECIMAL(18,2),available_bytes/1073741824.0) AS […] SQL Server 2016 - Development and T-SQL [SSRS Matrix - Conditional expression to change Background color based on value]( - I have a matrix in my SSRS 2016 reporting services report. I am trying to set a conditional expression on background color for the sum(field.value). This field is formatted as a percent. Here is my expression which does appear to have any errors: Background Color Expression: =Switch(Fields!PicturesbeforeFirstSignoutCount.Value<.80,"Red",Fields!PicturesbeforeFirstSignoutCount.Value >= .80 and Fields!PicturesbeforeFirstSignoutCount.Value < .95,"Yellow",Fields!PicturesbeforeFirstSignoutCount.Value >= .95,"lightGreen") […] Development - SQL Server 2014 [Simple sort makes query hang]( - I have a fairly simple query that is supposed to return only a single number – the ID of the TOP record from the query. It is not especially elegant, but it works well, except for the Sort clause. When I select and execute all but the Sort clause, it executes instantly, but naturally does […] SQL 2012 - General [How to make select statment get data based on partid from last date with gapes ?]( - I work on sql server 2012 i face issue i need to make select statment get Partid from last month until current month based on last date exist per partid and on same time if there are any gaps between dates then file it based on last date so first case if i found partid […] SQL Server 2019 - Administration [(707) 710-9881 ➽ Delta Airlines Reservations Contact Number](e2%9e%bd-delta-airlines-reservations-contact-number) - Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881 Delta Airlines Reservations Contact Number (707) 710-9881  How to Quickly Get in Touch with Delta Airlines? Help Center Delta […] [Always On]( - We had log backup issue due to the space filled up on the backup drive, and that caused the database to be in suspended state on the secondary replica due to not enough space on the disk . I could not able shrink the database on primary due to suspended state on the secondary replica […] [SSD drives for SQL Server]( - Our company is using a Citrix farm for some of our SQL Servers (2019), they currently have an SSD for their storage so our servers have the tempdb/data/logs all using the E drive. Does it make sense to try and have these files separated out since they are now on SSD drives? I have asked […] [SQL Server 2019 Instance Name Change]( - I am running SQL 2019 on Windows 2019 server and have come across an issue I have not seen before and cannot find a resolution on the web. I have went through the normal process of changing the Instance name by using the following.. EXEC sp_dropserver ''; GO EXEC sp_addserver '', local; GO I rebooted […] SQL Server 2019 - Development [Finding duplicates in a table with 20 million records]( - HI All I have a huge table with 20M records with around 70 columns. I need to check if a combination of 30 columns has duplicate values. Use of Group by takes too long and is very heavy on tempdb. I was thinking to concatenate the 30 columns and do a CHECKSUM and then group […] SQL Azure - Development [Sales Force Connector Question]( - Hello All - I have a question regarding the Sales Force Connector in a logic flow. I'm very new to this and haven't been able to find any answers via endless searching. I'm able to create a flow which connects to my instance of Sales Force. I need to return accounts and their corresponding account […] Azure Data Factory [Staging issue for Copy data using non-standard table name]( - This is an issue I've encountered in ADF/Synapse Pipelines when looking to Ingest a table from SAP that have non-standard characters in them. The copy bombs out giving an error message: { "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=AdlsGen2OperationFailed, 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'BadRequest'. Account: 'ingvdatalakenp'. […] Design Ideas and Questions [Denormalized as much as possible]( - Please assist? I would like to model this data( for Bigquery as much as possible in a denormalized data model. Bigquery favours denormalized data models. I am busing creating the data model of the data tab/table in the sheet. The Data tab/table contains the data as it comes from CM360(data source). Journey and Mapping Tab/table […] Business Intelligence [compare and insert]( - Hello, new to ssis so wanted to find out how to compare the data in the destination then get data from source and insert what exist (in source) for example i have set of record id in the destination. based on that i need to bring that record id only from source to destination. Thanks […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -