Forum Discussion
Anonymous
7 years agoNot applicable
Google Sheet as Datasource not working
Hello Community,
I want to create a dashbaord based on google sheet datasource but no chance
I have followed both links:
https://community.powerbi.com/t5/Power-Query/googlesheet-to-powerbi-desktop/td-p/626173
https://www.youtube.com/watch?v=2hFCeduIP6k
I am getting null everytime :( Please see attached screenshots
Any help will be appreciated
Best Regards
Asma
2 Replies
- AnonymousNot applicable
Thank you for your reply :)
I have already tried this but unfortunately it is not working .
It is maybe a firewall issue or Authentication ..
Best Regards
Asma
- TeigeGaoSolution Sage
Hi Anonymous ,
We will need to use the "Publish to the web" option to get the link, the link we get will be end of xlsx:
Then we can get the data from PowerBI:
Best Regards,
Teige