Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I currently have 19 Google Sheets workbooks connected to Power Bi, but am looking to transfer these across to Microsoft Excel without changing any visualisations.
I thought it would be as easy as changing the data source settings, but this option isn't available. I've read online that I will have to connect each new Excel workbook and can copy across the whole Advanced Editor script to apply the same steps. However, as this is a new data source, this will break the visualisations and DAX measures I have... which there are far too many for me to want to do this!
Can anyone think of a work around for this?
Thanks
Solved! Go to Solution.
Hi, you connect to excel and copy from excel Advanced Editor to your existing query, this way you dont break anything.
Step 1 connect to excel, copy the part till in
Step 2, go to your existing table connected to google sheet, replace, dont forget comma before your other steps
if you copy the steps from your query to new excel query, you will break everything, but the other way around, copying the datasource of excel to your existing query will not break anything.
Hi, you connect to excel and copy from excel Advanced Editor to your existing query, this way you dont break anything.
Step 1 connect to excel, copy the part till in
Step 2, go to your existing table connected to google sheet, replace, dont forget comma before your other steps
if you copy the steps from your query to new excel query, you will break everything, but the other way around, copying the datasource of excel to your existing query will not break anything.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |