Get and Transform Excel and Json files and Export to SQL Server database using Power BI

In this video, our Power BI faculty explains how to use Power BI to Get and Transform Excel and Json files and export them to SQL Server database using DAX studio as well as R script.

Learn more with our article :

Introduction :(0:00)
SQL Server :(0:23)
Getting data :(1:48)
Using the R Script :(6:05)
Json :(7:42)
Run R Script :(11:00)

This video is part of our preparation to the Microsoft Power BI certification (Exam DA 100, Microsoft Certified Data Analyst Associate).