Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not 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 appreciatedPBIIssue.PNGPBIIssue2.PNG

Best Regards

Asma

 

2 REPLIES 2
Anonymous
Not 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

TeigeGao
Solution Sage
Solution 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:

4dO1e40wGE.gif

Then we can get the data from PowerBI:

PBIDesktop_Us2IPIxhX0.png

Best Regards,

Teige

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.