Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there any way to create a powerbi report by accessing data from Google sheet?
Generally speaking, there is not good way today. However, there is a hack that works sometimes.
This is the only way that I was able to do it and it only works if you only have a single sheet in your spreadsheet.
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