Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.