Power Bi Services and Excel Report Not Syncing

[Anonymous]

Hello All,

I have built a report via power bi desktop that was based on an excel file hosted on sharepoint. I have now published the power bi report to the online services and would like the power bi report to reflect the changes made onto the excel document it is built off. I know that I need to create a data gateway in order for this to work, but have been running into an error when trying to add a data source to my gateway:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance.

I am trying to get my gateway data source via file path from the excel report that is sitting in the onedrive folder of my machine. Is this an issue maybe with my windows credentials? Any help would be appreciated.

[Anonymous]

Hi Denis,

Thank you for your response. 

The file is located on the sharepoint on premise (the cloud where the entire company can post docs to). And the gateway is through power bi services which is accessible via the same sharepoint that hosts the excel file. 

Does this answer your question? 

[v-janeyg-msft]

Hi, @Anonymous 

If your data source is online, you don’t need to add it to the gateway, you only need to configure credentials under the dataset.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hi jane, 

i am not sure what you mean by configuring credentials, where do you go to add/configure credentials under the dataset tab?

thank you

[v-janeyg-msft]

Hi, @Anonymous 

Is your problem been solved?

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-janeyg-msft]

Hi, @Anonymous 

You can go to workspace >>dateset>>more option>>setting>>data source credentials,then edit.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @Anonymous ,

that's a little difficult to say.

Is it sharepoint online or sharepoint on premises?

In general the data source has to be available from the server, where the gateway is running. So if you write in the Power BI file C:\Temp\myExcel.xlsx the file has to be reachable from the Gateway server on the same path C:\Temp\myExcel.xlsx 

Can you check that?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi