Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.