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

Refreshing few data sources from multiple ones

Suppose i have power bi report with 5 data sources(one is oracle and others are excel).I published it in power bi site.

Now i want to refresh only the oracle one from gateway, so i enter the credentials for oracle.

Now i don't want to refresh the excel ones.So i don't enter the credentials for excels.

So overally i want to refresh only oracle data source and don't want to refresh excel ones. So is this possible.

Every time i m doing this its give me the error.

2 REPLIES 2
ashishrj Senior Member
Senior Member

Re: Refreshing few data sources from multiple ones

@sumodjena Can you post what error you are getting? Also have you setup Power BI Personal Gateway for data refresh ? 

Also Power BI Personal Gateway should be online when scheduling for refresh. 

konstantinos Senior Member
Senior Member

Re: Refreshing few data sources from multiple ones

If you don't add the credentials for all sources it will fail. You can try to disable refresh for the excel queries/data sources.

Right click the Query in query editor -> Properties & then unselect enable Refresh. 

 

Haven't tried how it works in PowerBI service when you upload the file but with a try & error it can work ( upload it again, new import etc )

Untitled.png

 

Konstantinos Ioannou

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,146)