cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FranciscoE
Frequent Visitor

Gateway with two datasets

Buenos days to all.

I'm working with Power BI recently and I'm updating two datasets (each for a specific report.

The question is that if I have to make a new data door for each dataset or just take the same installed data door and there do the links?

I hope you can help me.

Thank you.

FranciscoE_0-1601042878389.png

After giving him update

FranciscoE_1-1601042935217.png

I hope you can help me.

Best regards.

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @FranciscoE ,

 

For each dataset , you may need to add one or more data sources of your dataset to the gateway, as described in Add a data source. Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.

 

If your data source credential expired,  try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

 

If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway,  and then you may configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

 

Note that you also need to select "Allow user's cloud data sources to refresh through this gateway cluster" option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

Please make sure the gateway is online, and try to upgrade the gateway to latest version.

 

For the refresh issue, you may refer to the troubleshooting link :Troubleshooting refresh scenarios .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

1 REPLY 1
v-xicai
Community Support
Community Support

Hi @FranciscoE ,

 

For each dataset , you may need to add one or more data sources of your dataset to the gateway, as described in Add a data source. Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.

 

If your data source credential expired,  try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

 

If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway,  and then you may configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

 

Note that you also need to select "Allow user's cloud data sources to refresh through this gateway cluster" option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

Please make sure the gateway is online, and try to upgrade the gateway to latest version.

 

For the refresh issue, you may refer to the troubleshooting link :Troubleshooting refresh scenarios .

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors