Dataflow from Excel on google drive

[jbetkowska]

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)

[ibarrau · Accepted solution]

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,

[v-kkf-msft · Accepted solution]

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 · Accepted solution]

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,