cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fia123 Helper II
Helper II

Exclude from refresh certain queries from Excel files

I have report with a lot of queries from a sql server - and some queries from Excel files.  I have just installed a gateway to get the data from sql served to be updated, but it is not necessary to refresh the data from the Excel files (static data) . Is it possible to configurate the schedule updates to only refresh the sql data?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Exclude from refresh certain queries from Excel files

It's the Enable Load option, disable that.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

7 REPLIES 7
Super User IV
Super User IV

Re: Exclude from refresh certain queries from Excel files

In Query Editor, right click your query and set it to not refresh.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Fia123 Helper II
Helper II

Re: Exclude from refresh certain queries from Excel files

Hi thanks - do you mean not select "Include in report refresh"? 

 

Report_Refresh.jpg

 

I have tried that, but still it seems that the Excel file (Dato_Tabell.xlsx) will be refresh. In any case, I am asked to add my credentials when I tried to set up a schedule plan.

Gateway_Excel.jpg

Fia123 Helper II
Helper II

Re: Exclude from refresh certain queries from Excel files

Hi again, I am struggling to find a solution to my problem - and hope you (or someone) have another tip 🙂

 

I have a report with data from a Sql server and some additional static information in Excel files.  I tried to set up a schedule refresh plan for the data set, but it seems hat it is not possible to combine on-premises data (Sql) with data in Excel files.  If it had been possible to exclude the Excel files from the refresh plan, my problem had been solved. I tried to untagged "Include in report refresh", but it does not help. To your information I am using a data gateway.

 

Thanks in advance!

Microsoft Eric_Zhang
Microsoft

Re: Exclude from refresh certain queries from Excel files


@Fia123 wrote:

Hi again, I am struggling to find a solution to my problem - and hope you (or someone) have another tip 🙂

 

I have a report with data from a Sql server and some additional static information in Excel files.  I tried to set up a schedule refresh plan for the data set, but it seems hat it is not possible to combine on-premises data (Sql) with data in Excel files.  If it had been possible to exclude the Excel files from the refresh plan, my problem had been solved. I tried to untagged "Include in report refresh", but it does not help. To your information I am using a data gateway.

 

Thanks in advance!


@Fia123

The option "Include in report refresh" only works in Power BI desktop.

 

Power BI gateway(personal mode in your case) definitely support such combined data sources. You can click "edit credential" and ensure that when using a absolute path(c:\\xxxx\xxxx\xxxx.xlsx), ensure that the gateway is on the same server, otherwise you can encounter error as below.

Capture.PNG

 

 

peikba
New Member

Re: Exclude from refresh certain queries from Excel files

Hi,

 

My experience is that this is not possible.

If the Excel sheet containg data areas, it will always require a gateway and if it only contains data, it requires credentials, which do not exist.

 

My work around is to

- copy all data in the excen sheet,

- go to Power BI desktop to the Enter Data in the Home tab

-  Paste the data in from the clipboard 

- Name the table 

 

Then it will be excluded from refresh

 

/Peik

peikba
New Member

Re: Exclude from refresh certain queries from Excel files

Hi,

 

My experience is that this is not possible.

If the Excel sheet containg data areas, it will always require a gateway and if it only contains data, it requires credentials, which do not exist.

 

My work around is to

- copy all data in the excen sheet,

- go to Power BI desktop to the Enter Data in the Home tab

-  Paste the data in from the clipboard 

- Name the table 

 

Then it will be excluded from refresh

 

/Peik

Super User IV
Super User IV

Re: Exclude from refresh certain queries from Excel files

It's the Enable Load option, disable that.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors