I am running into a similar issue. I have the Enterprise gatway setup on Azure VM. I am successfully able to add SQL DB and Azure Blob data source connections. But when I try to add conections to Sahepoint Folder, it thows me an error. Can you please let me know if any one has faced such issue and how did you resolve it.
Hi, How Are You. I have tried to do everything I read in different publications but I still have not been able to configure the update schedule. Our report is connected to data from Solman (SAP) and Sharepoint but for this I have had no way to work, and therefore, I can not update from Power BI Service (app.powerbi.com) but yes I can update manually from Power BI Desktop
My Power BI Service license (app.powerbi.com) is different from Sharepoint, but under "Data source credentials" I enter the license without any inconvenience. The only rare thing that every time I press "Edit Credentials" asks me to re-enter the Sharepoint license (maybe it is correct that this is so; I enter here every time I read a note on this topic because I no longer know that I do).
I have tried to do everything that I think is necessary, but since I do not understand much English there are some things that are beyond my understanding (I use translate.google a lot).
I attached some screen printing of how it is configured and a step-by-step when I enter "Edit Credentials".
I had a similar problem and managed to create a workaround utilizing dataflows. In my case the goal is to combine SSAS database with a Sharepoint Excel file into a single data set. Here's what I did roughly:
1) For the Excel on Sharepoint, I created a dataflow to read the Excel. No gateway is selected.
2) In Power Query (Desktop), I created a query for my SSAS database which is on premise (gateway required). Then I created another query where the source is my dataflow that I created in step 1.
3) I published my dataset/report
4) The refresh worked.
Another thing to note here is to make sure you have the most recent gateway installed. This is because the dataflow feature is relativley new in Power BI Service and since you want to use the dataflow as a source in PowerBI you need to make sure you have the most recent gateway installed or at least the one that support connecting to a dataflow from Power Query Desktop.