Forum Discussion
Google sheet
Is there any way to create a powerbi report by accessing data from Google sheet?
Not tested in PowerBI if is refreshable but the solution andre descibes , working on excel in Desktop. I have more than 3 excel data models working & refreshing with Googlesheets. One thing to keep in mind is that the Google spreedsheets (new ) allows you to connect & view the data only from the first sheet.
Actually, in googlesheets File-> Publish to Web and on the window open copy the link after you change the format from web page to excel .xlsx
konstantinos Thanks your solution worked perfectly for me