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

Import files once, never load them again

I've made a dashboard that uses a combination of data from an azure db and files that I imported once from my virtual machine. 

 

I'm now unable to schedule a refresh because "data source credentials" is greyed out on the Power BI admin website. It looks like it wants me to use an on-premise gateway to refresh data (because there are a few file connections in the dataset). 

 

However, I don't want to use the on-premise gateway. I don't even want to refresh the data from the files. They were a one time upload that I will NEVER change again.

 

In Power BI desktop/powerquery I've already deselected the relevant option ("include in report refresh"), but it still won't allow me to enter data source credentials.

 

 

So what should I do? I can not deselect "enable in load" because it will remove the table, which obviously I don't want. Is it possible to treat the files as a one time data import, without requiring active connections to the original files?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Import files once, never load them again

@daje,


The "include in report refresh" option only has effect on Power BI Desktop report, it will not affect the refresh in Power BI Service. 

When you combine online data source(Azure SQL database) and on-premises data source(Excel file) in a single dataset, gateway is required to refresh the dataset, and it is not possible to refresh specific data source in this single dataset. If you don't want to use gateway and want to set schedule refresh, you can upload Excel file to OneDrive,  then connect to the Excel in Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Import files once, never load them again

@daje,


The "include in report refresh" option only has effect on Power BI Desktop report, it will not affect the refresh in Power BI Service. 

When you combine online data source(Azure SQL database) and on-premises data source(Excel file) in a single dataset, gateway is required to refresh the dataset, and it is not possible to refresh specific data source in this single dataset. If you don't want to use gateway and want to set schedule refresh, you can upload Excel file to OneDrive,  then connect to the Excel in Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
daje Frequent Visitor
Frequent Visitor

Re: Import files once, never load them again

Thanks Lydia, that worked!

 

I found it a little tricky to get it done, but to other who are reading this and have the same problem:

1. Upload your files to your workspace files in power bi (go to power bi web -> workspace -> files and upload them there)

2. In Power BI Desktop, change the source for your flat file queries to the web URL (find the web URL here)

3. Apply changes, re-publish your dashboard

4. Finally, in settings, make sure you use OAuth to establish a connection to each of the files individually. Once done you should be able to set a refresh schedule

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 409 members 4,263 guests
Please welcome our newest community members: