Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Refresh of dataset for files on the sharepoint folder is not working

Hi there,

I have setup a report with a mysql database connection and two excel files on the sharepoint.(Also MailChimp and Google Analytics Connection)
On PowerBI desktop I have create a source for the sharepoint connection (using my organisational accout)

which is working.

The problem is that the refresh on PowerBI web is not working. I setup a gateway for the mysql database which is working.

For the sharepoint files I have just use the dataset integration to get a connection to the Sharepoint folder.

The datasets are updated correctly if I change something directly at file files and check the datasets.

But the two tables within the project file which are based on the excle files from sharepoint are not updated.

 

The problem is that the following error occur at the projekt dataset:

Error at the data source: The planned refresh has been cancled because there are missing login credentials for at least one data source.

Cluster-URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Aktivitäts-IDaa4bab0e-3d82-27f2-a243-7e5a816ee973
Anforderungs-IDc0028591-5f32-9832-36d6-5670b5707410
Zeit2018-07-31 10:29:31Z
 
If I have a look at the gateway properties for the project dataset, it says that the gateway for the sharepoint folder is missing.
I have already tried to add one but during the setup of the sharepoint gateway my windows credentials are not accepted. Within PowerBI desktop I had the same problem but within powerBI desktop I could use the organisational account which works. But this option is not available at the powerbi web version. Also I thought it wouldn't be necessary to setup the gateway if I added the sharepoint files directly as datasets.
 
Status: Needs Info
Comments
v-yuezhe-msft
Microsoft Employee

@danielvt,

Do you connect to Excel file locations at SharePoint online? If so, do you take any merge/append operations between online data sources(SharePoint online or Google Analytics or Mailchimp) and on-premises data source(MySQL)? If you have, you would need to use personal gateway to refresh the dataset.

However, if you don't have the merge/append operations, you can use on-premises gateway to refresh the dataset. After you add the MySQL data source within the gateway, please also select "Allow user's cloud data sources to refresh through this gateway cluster".

Regards,
Lydia

v-yuezhe-msft
Microsoft Employee
Status changed to: Needs Info