Power BI - Change Data Source from Excel to SQL Server - M & Power Query trick

preview_player
Показать описание
Power BI data source settings do not provide a direct option to change the source from CSV/Excel to an SQL database.

We will change the data source by using some basic M language script in Power Query.

#powerbi #powerquery #dataanalytics #dataanalysis
  1. Data Analytics Central
  2. Power BI
  3. Power Query
  4. M Language
Рекомендации по теме
How to Replace 0:07:39

How to Replace Data Source in Microsoft Power BI| How to Change or Update Data Source in Power BI

How to Update 0:03:34

How to Update existing data and Refresh the PowerBI Dashboard ? | Power BI Tutorial

INSANE AMAZING Power 0:05:38

INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel

Power BI Desktop 0:03:19

Power BI Desktop Tips and Tricks (14/100) - Change Data source

How to Update 0:09:29

How to Update a Data Source in Power BI (without losing all of your work)

2 ways to 0:05:32

2 ways to replace data source in Power BI

How to Easily 0:07:30

How to Easily Change the Data Source Type in Power BI

Power BI - 0:06:25

Power BI - Changing data types

Data Analytics for 0:32:55

Data Analytics for Oil and Gas Industry using Power BI Part 2

Power Bi Data 0:03:34

Power Bi Data Source Connection: How to change Data source setting in Power bi

Change Data Source 0:08:11

Change Data Source - POWER BI [ Error - The key didn't match any rows in the table ]

Replace Values Based 0:05:00

Replace Values Based on Condition (in a Single Step) in Power Query

Changing Date Formats 0:02:15

Changing Date Formats in Power BI | Power Query Editor Date Error

How to use 0:13:07

How to use Power Query in Power BI | Microsoft Power BI for Beginners

Refresh Reports AUTOMATICALLY 0:08:32

Refresh Reports AUTOMATICALLY using Scheduled Refresh // Beginners Guide to Power BI in 2021

Data Source Settings 0:04:29

Data Source Settings and Refresh Settings in power bi | Power BI Tutorial

Making data source 0:03:28

Making data source parameters easy in Power BI Desktop

Power BI Trick 0:09:55

Power BI Trick No issues with changing sheet excel names any more

Refresh breaks due 0:16:28

Refresh breaks due to COLUMN NAME CHANGES? 3 ways to fix changing column headers in Power BI!

SWAP DATA SOURCES 0:10:53

SWAP DATA SOURCES EASILY using Parameters in Power BI // Beginners Guide to Power BI in 2022

Power BI: How 0:09:53

Power BI: How to Swap Data Sources

AUTOMATE your Monthly 0:09:58

AUTOMATE your Monthly Data in Power BI using Get Data From Folder

How to change 0:01:22

How to change data source in an existing Power BI report - Power BI 60s

Can’t INPUT DATA 0:17:39

Can’t INPUT DATA in Power BI? Here is a WRITE BACK Option with Power Apps!

Комментарии
Автор

Really Very help full and clear communications. Subscribing your channel Now

RamayanapuDurgaPrasad
Автор

What if the Source File is used for the Merge + Append + Group transformations with other files . but now the source file got Updated with Lots of Data and it is difficult to update the file and we need to replace the source file alltogether, with new file with same name, without affecting the previous output. Can it be done with "Parameters" Setting or something else. Please Advise.

arungupta
Автор

I am new to the SQL. In every tutorial I see that only CSV files are being used with SQL. I have used EXCEL file with multiple subsheets as my data source, it's in import query mode but I want to make it direct query so tha power apps forms can auto refresh. Your trick is very neat but is there any way to make it work with excel files? Thanks.

PallaviChauhan