Forum Discussion

dimazaid's avatar
dimazaid
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Updates to the Web connector

We are currently working on improving the refresh of cloud based data sources. As part of this, one of the changes we have made recently is that new datasets that leverage import from Web pages will ...
Announcement
General Comment
PBI_KLo's avatar
PBI_KLo
Icon for Helper I rankHelper I
9 years ago

Hey everyone, 

 

I managed to get Google Sheets to work instead for another document (more like, it hasn't given me an error yet..) based on some other searching on the internet so not entirely my own discovery:

 

  1. In Google API Console, enable Sheets API
  2. Under "Credentials", create "OAuth Client ID". Copy the "Client ID" and "Client Secret". (This will be your username and password for "Web credentials")
  3. In your Google Sheet, go to "File > Publish to the Web", select Excel as the file format, copy the url.
  4. In Power BI Desktop, use "Web" as a source, and use the Publish to Web url, use Basic as the credential type, and use the Client ID and Client Secret as username and password. 
  5. On the Scheduled refresh page on PowerBI.com, you will need to re-enter these again.

good luck

 

-Kevin