Forum Discussion
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)
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-googleI hope that helps,
Hi Anonymous ,
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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-googleI hope that helps,