Forum Discussion
Can't connect to Sharepoint subsites using PowerBI
Hi Jose,
Please try below.
Add new dataset from Sharepoint folder.
Fill in link to sharepoint folder, please do not put "/" after folder name
Log in using microsoft account and connect.
Once table preview will load, go and hit "Edit"
Then query will open, looking like this. Find file which you want to connect and just click right on "Binary" and choose "Add as new query" so you don't have to go trough whole setup when more files are needed.
LEt me know, if any questions.
Rasty
Hi Anonymous,
I got myself as far as you described. However, once I try to open or proceed on the binary it offers me only
company_name.sharepoint.com
and then I can only "Open as" pdf, json, csv, Excel, Access, HTML... but not .pbix ...
Any clue what I can do?