Forum Discussion
Gateway Refresh - Query contains unknown or unsupported data sources. (null values)
I have a Power Bi template that I send out to different parts of our organization. Depending on which department is viewing the report, the template can specify a certain number (up to 5) of servers in the report. I have the report written using parameters where the user creating the report can easily input the server names.
So if user A has 5 servers they want to query, they input 5 server names, and there are a few tables where I append all of the results into the report.
If user B only have 4 servers, they input 4 server names and the same thing occurs. However, I put in an If statement basically saying if parameter for server 5 = null, then the table will be null and we ignore it during the appending of data.
The report itself works fine in Desktop but I cannot get them to refresh because of the refresh error above in the title. I suspect the Source = null for any blank parameters might be the issue but would need to get confirmation from someone. If that is indeed the case, any workarounds?
- Hi there,
I see that you said that there were 5 server names?
Could you not create a 6th one that points to an existing server so that you know when it should not be used?
10 Replies
Digging a little deeper into this, if I remove the blank parameters and their associated queries, it seems the refresh is enabled again. Kind of puts a damper on the usefulness of the templates, hoping there is a way around this.
- Hi there
I think it has to do with a Parameter cannot be NULL.
What about if you had to change the logic, where if a user does not need the server they put in "N/A" into the Parameter. You can then change your if statement to look for "N/A" and then apply the logic there after?
