Forum Discussion
The credentials provided for the SharePoint source are invalid
So, how can i merge Sharepoint list to another data source (SQL) ? as it seems it fails on this step..
Not sure why it still fails but you can create a Dataflow where you get her all your sources and then create your pbix
I've tried but from Dataflow i can't even connect to the Sharepoint list.
I also tried to copy the m code from the pbix file to the dataflox but get same error: (configure connection button takes me to the sharepoint credentials menu but all i did wasn't solved it)
This is what explains all your issue. If Power Query Online can't connect to your Sharepoint List then that's why your merged tables in the pbix did want to connect.
You need to verify your credentials and why can't you connect with your Sharepoint Admin
So how you explain the fact that I can connect from the pbix file and without the merge everything works fine ? including the service refresh of course..
As I have one username/ password- I don't know what else I can do.