Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
I have a report with Google Sheets as a source. I found here that if I use Source = Web.Contents instead of Web.BrowserContents I won't need a gateway to refresh the report.
I changed the function but now I can't save the report, it says that the report file is opened somewhere else.
Here's my code:
Source = Web.Contents("https://docs.google.com/spreadsheets/d/e/2.....SQ/pubhtml?gid=108173371&single=true")
What could it be?
Thank you!
Solved! Go to Solution.
These issues are unrelated. Check if you have the same PBIX file open twice. Also check in Task Manager if there are any orphaned Powere BI Desktop instances.
These issues are unrelated. Check if you have the same PBIX file open twice. Also check in Task Manager if there are any orphaned Powere BI Desktop instances.
@lbendlin thanks) the issues were indead unrelated. I just saved the file as a new one and restarted the computer. All's good now 😬