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

The 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.

Reply
Maria_Maria
Helper II
Helper II

Web.Contents doesn't allow to save a file

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!

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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 😬

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!