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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
jbetkowska
Frequent Visitor

Dataflow from Excel on google drive

Hello, is there any option to create dataflow from Excel stored on googledrive?

I tried to do it, in Connection settings I paste path to google drive, file is not secured, anybody who has the link can open it, but seems that PowerBi doesn't recognize it. I got error as follows:

An exception occurred: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server. (Session ID: a8938af1-9f10-4891-a3f1-c24b983d5f34)

 

Untitled.jpg

2 ACCEPTED SOLUTIONS
ibarrau
Super User
Super User

Hi. I have tested this scenario from Power Bi Desktop before and it worked for me with the following process:
https://blog.ladataweb.com.ar/post/189308808470/powerbi-conectar-desktop-a-un-archivo-en-google

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

v-kkf-msft
Community Support
Community Support

Hi @jbetkowska ,

 

Please refer to the article shared by @ibarrau , and then connect using Web connector instead of Excel file.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

Hi @jbetkowska ,

 

Please refer to the article shared by @ibarrau , and then connect using Web connector instead of Excel file.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ibarrau
Super User
Super User

Hi. I have tested this scenario from Power Bi Desktop before and it worked for me with the following process:
https://blog.ladataweb.com.ar/post/189308808470/powerbi-conectar-desktop-a-un-archivo-en-google

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors