How to create a Power BI report using REST API data (2022-12-16)

SQLServerCentral Newsletter for December 16, 2022 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to create a Power BI report using REST API data]( - [Deploy and Configure Azure SQL Managed Instance]( - [New Flyway Course on Redgate University]( - [From the SQL Server Central Blogs - My Office Setup]( - [From the SQL Server Central Blogs - Creating a user for a STONITH resource in vSphere]( Question of the Day - [Migrating to Synapse]( The Voice of the DBA  Daily Coping Tip Send a gift to someone new 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. Are You Still Using Portable Drives? It's the holiday season and that means lots of promotions for various items to give as gifts. Black Friday took place recently and I had no shortage of advertisements that I saw for all sorts of things. From computers to televisions to headphones to any sort of tech gadget you can think of. One item that kept cropping up for me was SSD drives. I saw [an article in Tom's Hardware]( about prices crashing to all time lows. That dovetailed with my part of the Data Community Summit keynote where I remembered Jim Gray saying 1TB would soon be US$10,000 in 1999 at the first PASS conference. I looked back at a few orders, and I saw I paid $150 for 512GB in 2017 and $125 for 1TB in 2020. Now I could get quality portable, SATA, or even NVMe drives for under $100/1TB. I thought about this recently as I packed for a trip. I used to carry 2 1TB drives in my bag, along with a couple of thumb drives. At a recent event, I realized I only had 1 thumb drive in my bag, which I hadn't used for years. Packing for another trip, I saw that my portable drives had been pulled out sometime during the pandemic and never returned. Despite almost 10 work trips in 2021 and almost 20 in 2022, I haven't needed a plug in drive. In fact, I'm not sure the last time I used a drive I connected to with wires. I'm used to getting everything through a network, even if it's not a fast one. I wonder how many of you just live only on networks and never worry about using physical storage to transfer data. It seems that the idea of not really needing to use some physical medium to transfer information is becoming the norm rather than the exception. I know there are still uses for physical drives. The [Azure Data Box]( and [AWS Snowball]( are used when large transfers will overwhelm a network. There are likely still some people who flip tape drives or mount and dismount disks as more storage is needed, but that seems to be a specialist role rather than something that many of us worry about. Especially with the cloud, it's more likely that many of us may never need to touch physical storage again in our lives. I don't know if this is a good thing for the world, but I do think it is convenient. Knowing there is almost always a network around, and that we can make transfers between devices with wi-fi or Bluetooth without needing a physical cable is somewhat amazing. It's a far cry from using multiple floppy disks or CDs to move data around. In fact, I had to search around for an optical drive as I realized I still have backups of pictures on DVD and none of the last few machines I've owned have a DVD drive. The changing nature of storage still amazes me, someone that first dealt with tape storage as the medium for saving work. The world has come a long way, and I'm looking forward to what comes next. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to create a Power BI report using REST API data]( Daniel Calbimonte from SQLServerCentral In this article, we will learn how to use a REST API from Power BI to get data for a report. [External Article]( [Deploy and Configure Azure SQL Managed Instance]( Additional Articles from MSSQLTips.com This article covers how to deploy, configure and test the managed instance version of Azure SQL Database using the General-Purpose edition. [External Article]( [New Flyway Course on Redgate University]( Additional Articles from Redgate Flyway Desktop is the newest way to automate database deployments. In this brand new course Kathi Kellenberger provides an overview of DevOps, including definitions, tools, and demos of some of the advanced features available in Flyway Desktop. [Blog Post]( From the SQL Server Central Blogs - [My Office Setup]( Tim Mitchell from Tim Mitchell At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from... [Blog Post]( From the SQL Server Central Blogs - [Creating a user for a STONITH resource in vSphere]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Migrating to Synapse Using the SQL Server Migration Assistant (SSMA), from which platforms can I migrate a database to Azure Synapse Analytics? 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) Nested Triggers Which types of triggers can be nested and how far can they be nested in SQL Server 2022? Answer: Both DDL and DML triggers can be nested to 32 levels Explanation: Both DML and DDL triggers can be nested to 32 levels in SQL Server 2022 (and other versions). Ref: Create Nested Triggers - [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 [Installation error]( - SQL Installation is got failed with error 1603 and no sql is installed previously .How to fix this and start the installtion again .. Administration - SQL Server 2014 [Rectify Error]( - Hi Experts, How can I rectify the below error in SQL Agent log. [298] SQLServer Error: 805, SSL Provider: The certificate chain was issued by an authority that is not trusted. [SQLSTATE 08001] [298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001] How can we identify when client is trying to connect. This […] SQL 2012 - General [Upload only new files from SFTP Server]( - Hi all, I'm working with SSIS'12 and I should create a package which will upload from SFTP only new files. It means that the process should run each 1 hour and check if we uploaded the files and if no, we should upload it. Could you please help me how to implement it? [SS 2012 login popup behind main window]( - I'm using SS 2012 on a Win 10 Pro laptop with a second display. Suddenly when I start Management Studio the login popup opens BEHIND the main Management Studio window, and the main Management Studio window is frozen so I can't move or kill it. I have use Task Manager to terminate the application. If […] [Looking for help installing Sql express 2012]( - So I normally have no issues with installing this software but I popped open some new systems that came in. Windows 10 pro x64 on HP probook6450b. All solid state drives, and i5 processors. All attempts to install express 2012 fail. I can launch the program without issue. Select fresh install. But while going through […] SQL Azure - Development [Substitute of trigger in a merge statement.]( - Hello Everyone I hope you all are rocking. My question is regarding the merge statement. I am using Microsoft SQL Azure (RTM) - 12.0.2000.8. I am transferring users' data from one table to another table with some manipulation of data. Everything works fine without any issues. Now I have another table that maps the user […] SQL Azure - Administration [Move Azure SQL Managed Instance across subscriptions]( - Hi, Is there a way ( with less downtime ) to move Azure SQL Managed Instance across subscriptions? One way to do it would be to take a COPY-ONLY backup to an URL and then restore to the new subscription. But this can require significant downtime for cases where the database is huge. General Cloud Computing Questions [Silly Cloud computing story]( - A few years ago I was interviewing for a position. Roughly 2016. I was speaking with the IT director (fairly small company, located in the N Chicago suburbs). One of the things he told me was that when he joined, the company was using a cloud service based in Texas. The first thing he did […] Reporting Services [RS.exe is having issue while subscription is completing the report.]( - Hi We have a report that is running via rs.exe utility and it errors out, but when we execute it via subscription it is completing. The error is below, the report is executing an oracle stored procedure  runningjobs!ReportServer_0-18!14cc!12/08/2022-08:37:28:: i INFO: RunningJobContext.IsClientConnected; found orphaned request 35ybh2mbnhiom22ugojqi52l processing!ReportServer_0-18!14cc!12/08/2022-08:37:28:: i INFO: DataPrefetch abort handler called for Report […] SSRS 2016 [List all data sources]( - Hi is there a way to list all the data sources in SSRS 2016, and if possible which reports use them? Cheers Alex Disaster Recovery [log shipping monitor instance]( - I tried to setup log shipping on two data centers. Server A in location A, serverB in nearby location B. On the server there are multiple databases, I created the first logshiping database, I created the monitor instances on ServerB. It works well. I then tried to create another log shipping for another database, when […] SQLServerCentral.com Test Forum [Page 2 test - Dec 2022]( - a test thread to see what happens when we get to page 2. [Page 2 test - Dec 2022]( - a test thread to see what happens when we get to page 2. SQL Server 2022 - Administration [SQL 2022 - Contained AlwaysOn restore]( - Hi,  Ive been playing around with the new SQL Contained AlwaysOn, and its looking really promising so far! But one thing im missing from the documentation / my PoC, is how to restore the master database of the contained availability group. Like we normally can do, with a bit of twerks.  The best […] SQL Server 2022 - Development [get a substring value from string]( - Hi, I am new to SQL Server. I have table create table tmp1 ( serialnumber varchar(500) ) insert into tmp1 values('1232132|2343345435|34543534534534|3344562534'),('23243|23423432432|34543534534235|3344562534') select * from tmp1 I need to fetch the value before the last pipe symbol the output would be as below 34543534534534 34543534534235 anyone can help   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -