Power BI User on 04 Nov 2014 03:05:31
Connecting to Excel workbooks in OneDrive is a great first step, but connectivity to Google Sheets should be there too.
Administrator on 08 Mar 2022 00:02:27
Thanks for the suggestions! I've split out the other cloud storage options into separate ideas for people to vote on.
- Comments (373)
RE: Connectivity to Google sheets
'This is a must:
- more and more companies are using the Google app suite;
- other BI products on the market have already been offering that connectivity for a while.
The highest security level (not being obliged to publish the spreadsheet on the web to everyone with a link) must be provided too.
RE: Connectivity to Google sheets
THE DONALD MAY NOT BE A SAINT,BUT I LIKE HIS STYLE!
RE: Connectivity to Google sheets
Compare to previous period selection in Date slicer like Google Analytics.
Would be useful if it was possible for the user to select compare to previous period ie either a date selection or last year last month etc like you can do with Google Anlytics but would be really useful due to it being your own data.
RE: Connectivity to Google sheets
Is there any way we can connect to Google Search Console Data now?
RE: Connectivity to Google sheets
I'd like to second (third, fourth?) the request for segments. Without this, the connector is no where near as useful as it should be.
RE: Connectivity to Google sheets
Maps are for spatial analysis and spatial visualization. That means you often have to show different 'layers' in their spatial context. If you can show customers but not stores in the same map or stores but not competitors you have made functionality that is at its best interesting. But, it is not useful for analysis.
You must be able to show different datasets or its a near useless capability.
RE: Connectivity to Google sheets
I agree. I want to create calculated measures on top of a powerbi report connected to my OLAP and Tabular servers in direct connection.
I do not import any data in powerbi and I'm relying on enterprise servers most of the time. and I dont want to change my OLAP cubes for every single need.
in Excel the olap extension allows me to create calculated measures, in SSRS I can write my MDX queries... but nothing available in Power BI.
RE: Connectivity to Google sheets
I want PowerBI support connect data with Facebook Ads API & Google Adword. I want see report ontime.
RE: Connectivity to Google sheets
A must, please add this.
Please make sure that Power BI can access the Google Sheet while keeping the security of the Google Sheet unchanged (the user should not be obliged to web publish the spreadsheet to everyone with a link)
RE: Connectivity to Google sheets
Hi, The Default google connector is connecting to sampled data API.
We would like to get a connector for google 360 unsampled API for premium google customers as this is not allowing us to get the best use of Powerbi