Forum Discussion
Advocate IConnecting to www.explore.ms
Solution SageHi Funkmiester ,
If we want to use the online Excel file, we at least need to let the link to the Excel file like "explore.ms/....../.xlsx", then the PowerBI may recognize it.
Because the www.explore.ms is not accessable in my environment, I can't test it. If you can't let the link like above, there is another workaround, we can use Python script to get the Excel from web then convert the Excel file as Pandas data frames, PowerBI can recognize it: https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts
Best Regards,
Teige
Advocate IThanks Teige,
I can grab excel files from the web I was just interested if anyone had specifically done it with explore.ms.
I've tried every version of the permissions and still can't connect, I get various versions of permission denied or credentials not valid (I have the correct sign in details for the site). I was wondering if anyone in the community had already done it. I know it's a curious thing it's a commercially important MS site that looks like it was built in 1996 either that or there is an unsupervised hipster thinking a throwback website is "cool". Thanks for your suggestion, I will look into the python script but it won't be soon. I will check back and post if I get in. Thank you for your suggestion, is is always appreciated.