Google Sheet as Datasource not working

[Anonymous]

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

[Anonymous]

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

[TeigeGao]

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