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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
powermicha
Regular Visitor

How to exclude one or two sources from Auto update in Power BI Services ?

Hello folks,

 

my report has an API source and two excel sheets as sources. The two excel sheets are stored on my laptop. The data from the excel sheets are static and never change. API ist available 24h via internet. Now I have published the report on Power BI Services and configured an auto update once per day. But the auto update fail, if my laptop is off and works fine, if my laptop is on. The data which come from the excel sheets does not have to be updated because it is static. How can I disable the two excel sheets from beeing updated ?

I found a solution in Power BI Desktop. There I can configure each source separately. But in Power BI Services I didn't find it. Any idea how I can exclude sources from beeing updated in Power BI Services ?

 

Thanks for help

Michael

1 ACCEPTED SOLUTION
powermicha
Regular Visitor

Thank You for Your answer Eason. Meanwhile I found that it is not possible to exclude local data source from being refreshed via schedule in Power BI Services, if You have multiple data sources. But I put my local excel sheets now on a cloud server and transformed it into json format. This works fine.

 

Michael

View solution in original post

3 REPLIES 3
v-easonf-msft
Community Support
Community Support

Hi, @powermicha 

If you think this problem has been solved, please mark a useful reply as a solution to close this thread, so that community members who encounter similar problems can quickly find it.

Best Regards,
Community Support Team _ Eason

powermicha
Regular Visitor

Thank You for Your answer Eason. Meanwhile I found that it is not possible to exclude local data source from being refreshed via schedule in Power BI Services, if You have multiple data sources. But I put my local excel sheets now on a cloud server and transformed it into json format. This works fine.

 

Michael

v-easonf-msft
Community Support
Community Support

Hi, @powermicha 

If you are referring to the scheduled-refresh , please disable it directly.

Your API source  doesn't require a gateway to be configurable for refresh.

 

Best Regards,
Community Support Team _ Eason

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors