Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.