Connecting to www.explore.ms

[Funkmiester]

has anyone had success connecting to the reports stored in www.explore.ms

The are downloadable excel files and I would like to connect directly to.

None of the credentials seem to allow access. I just want to connect the desktop for real time dashboards of the files held in there.

Anyone had success and care to share the secrets?

[TeigeGao]

Hi @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

[Funkmiester]

Thanks 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.