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
MatNyr
Frequent Visitor

How to auto refresh PowerBi report with direct query + import

Hi,

 

I was wondering if someone could help how we can auto refresh a PowerBi report consisting of direct query data & import from excel files and sharepoint folders. When I tried to put on autorefresh, it gave an error that it was not possible.

 

Is there any workable work-around? Or do I do something wrong?

4 REPLIES 4
DMiradakis
Advocate II
Advocate II

If you Premium Per User or Premium licensing, can you just setup a refresh pipeline through Power Automate or Powershell? That way, you won't have any refresh limits (you can go past 48 refreshes/day), and it will get Import Mode datasets to refresh at high frequencies.

MatNyr
Frequent Visitor

@Idrissshatila , @Dhairya ,

 

The problem is that my PowerBi files has both a direct query AND an import excel file. If I then want to autorefresh in the online preview, it gives the following error. How could I make sure the imported excel file get auto refreshed since the direct query gets automatically refreshed currently?

MatNyr_0-1683714202650.png

 

Dhairya
Solution Supplier
Solution Supplier

For import excel files or any other files from local system or server you need to install on-premise gateway then you can use scheduled refresh for timely refreshing your data.

Article for on premise gateway:https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem

Configuring scheduled refresh: https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

For Sharepoint you can refer this: https://www.youtube.com/watch?v=MC6TJMaiCRo

 

Idrissshatila
Super User
Super User

Hello @MatNyr ,

 

In direct  query mode, you set the automatic refresh from the power bi desktop.

 

check this video for instructions https://youtu.be/IT7x-3fHGvg

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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.