Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jos818
Helper I
Helper I

Best practice - Switching data source xlsx to SQL table

Hi, I have a pbix currently populated using 3 local excel files. Im looking to set automation and publish the dashboard to eliminate the need for manual processes, the benefit will be daily refresh on the dashboard effectivelessly.

There are currently 40 tabs in PBIX each with over 5 visuals so any time spent not having to repoint data source, measures etc would be greatly appreciated.

Is there a quick way in PBI to simply switch the data source over to the new? 

 

Many thanks in advance.

1 REPLY 1
HotChilli
Super User
Super User

Each of the 40 tabs has nothing to do with the data connection.  The data connection is per each query in Power Query and it will be one line in each query. 

The challenge will be to do with the structure of the data and any differences between Excel and SQL Server.

3 Excel files may contain individual tables (which are extracts from the SQL database? - it doesn't say this in your post so I'm guessing) and it may be as simple as replacing the connection line in each query to use

Sql.Database

with appropriate parameters, instead of 

Excel.Workbook

If that was the case, happy days but I suspect it won't be so straightforward.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors