Change excel data source in Power BI report

Question

Hi,&nbsp;Is it possible to change the excel data source by pointing at a new excel file, as I do not wish to overwrite the existing excel file, used as data source?&nbsp;I have created a Power BI report with a local excel data source, called e.g. "March data".Now I want to update the Power BI report with an updated excel file (containing same columns), but the file is now called "April data".&nbsp;Is this possible? Since I do not want to overwrite the exisiting "March data" file with the data from the "April data" file.

syldia · Answer

Can I change the file type as well? Excel to online mySQL db table?

praveenkumar · Answer

I successfully changed data source from Excel to SQL table by following below steps&nbsp;1. Create a new Power BI wokbook and connect to SQL database&nbsp;2. In the new work book, go to Home --&gt; Edit Queries --&gt; Advanced Editor. Copy the query. It might look some thing like this&nbsp;letSource = Sql.Databases("YOURSQLSERVERNAME"),Now_Datamart = Source{[Name="YOURDATABASENAME"]}[Data],dbo_Tag_data = Now_Datamart{[Schema="dbo",Item="YOURTABLENAME"]}[Data]indbo_Tag_data&nbsp;3. Perform #2 for Excel as well and your query might look like this&nbsp;letSource = Excel.Workbook(File.Contents("I:\Power\Shipcom\Ride Analyzer\Sample_Data.xlsx"), null, true),Data1_Sheet = Source{[Item="Data1",Kind="Sheet"]}[Data],#"Promoted Headers" = Table.PromoteHeaders(Data1_Sheet, [PromoteAllScalars=true]),#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"TripID", Int64.Type}, {"Date #", Int64.Type}, {"Trip Date", type date}, {"Day", type text}, {"Planned Duration (Hrs)", type number}, {"Actual Duration (Hrs)", type number}, {"Delay (Hrs)", type number}, {"Vehicle Type", type text}, {"Passengers", type text}, {"RAND13", Int64.Type}, {"Trip Legs", type text}, {"Booking Type", type text}, {"Route Name", type text}, {"Driver", type text}}),#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"TripID", "Trips"}})in#"Renamed Columns"&nbsp;4. Replace excel connection with SQL connection&nbsp;letSource = Sql.Databases("YOURSQLSERVERNAME"),Now_Datamart = Source{[Name="YOURDATABASENAME"]}[Data],dbo_Tag_data = Now_Datamart{[Schema="dbo",Item="YOURTABLENAME"]}[Data]indbo_Tag_data&nbsp;5. Close &amp; Apply&nbsp;Power BI will take some time to read all the data from table (table should have the same format including data types and data that excel had before making changes) and exact reports would be generated. If there are any changes you did on excel data, you might want to repeat same.&nbsp;Let me know if it works !!!

greg_deckler · Answer

Yes, use the View | Advanced Editor and you should see a first two lines of something like:&nbsp;let
    Source = Csv.Document(File.Contents("C:	emp\powerbi\dates.csv"),[Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),Edit the path of your file and you should be in business.

anonymous · Answer

Hi,I am also facing same problem. I built report in power bi using excel as data source, now want to replace it wqith sql server. Is there a method to do this?

Forum Discussion

Change excel data source in Power BI report

4 Replies

Related content

Changing Data Source

Data Source Credentials Password Change

change data source of live connected report

Data source Schema changed

Change Source Connection on Mirrored Database