Connecting Google Sheets to Power BI
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- This video shows how to connect, link, or get data from Google Sheets file to Microsoft PowerBI. This video will also troubleshoot problems in the process such as headers not being detected as column titles in MS PowerBI and blank rows showing up when migrating data from Google Sheets to Power BI.
Hi, thank you for the super clear video! I just have one question: Why do we have to exclude the /edit part from the URL?
Some things you just have to. :)
/Edit means you will get an editable version of the file. Since this is PowerBI, it does not need an editable version, you just need the data
I have seen protocols like this change. In the future, you may not need to remove this anymore
sa google sheet main source nya, pwede bang mag update ng data doon sa google sheet tapos refresh data nlang sa power bi? thanks.
Yes, but there is a known error "Too many requests" when you refresh too much or you have too many rows in your Google Sheets
You can see the resolution here: community.fabric.microsoft.com/t5/Service/Error-429-quot-Too-many-requests-quot-when-refreshing-a-dataflow/m-p/3646045