Queries with conditional sources not refreshing when published to PBI.com

[VoyagerJames]

Hi

We have a template whose queries can load their data from either a local folder of csv files, or a sharepoint folder of csv files (basically OneDrive Consumer and OneDrive for Business) However, when I publish this to PowerBI.com, the sharepoint files are not refreshing. Also, they don't appear in the Power BI Desktop 'Data source settings' window.

The only way I have got the publish working, is to remove all conditions from the query sources. This would therefore appear that I would have to maintain two templates ... one to connect to a local data source and one to connect to the sharepoint folder.

Does anyone have any ideas if I can get areound this?

Many thanks

James

[Seth_C_Bauer · Accepted solution]

@VoyagerJames What gateway are you using? The personal gateway should support a mixed scenario, but the other (what was Entperprise Gateway) does not support that yet. Even though you are using only one, if that configuration is set up in the file it may be what is causing the issue upstream.