Forum Discussion
default value for parameters
Hi, Anonymous
Finally, I have solved the issue. I'm trying to explain it.
The key point is that I need to append up to 15 purchase tables in Power BI desktop. Every table comes from a different ODATA Url. Every URL is a parameter.
The problem was that not all URL ODATA are always used. So, I need to introduce a value in order to create empty queries.
The first thing I tried was typing word 'NOT' in URL not used. So, I can create emtpy queries depending on this condition. That was the resason because I ask a question. I wanted NOT value by default, and only change ODATA that are going to be used.
However, I couldn't refresh when I try to refresh dataset in Power BI Service using On-premise data gateaway because there was an invalid Data Source.
How did I solve that?. For queries that are not going to used URL Odata, I introduce the same URL ODATA that parameter 1. And works in Power bi desktop and Service... Something like that... If Parameter Url 4 = Parameter URL 1 then CreateEmtpyTable and so on for every query.
It works!!!!!..
Anyway, thanks for your help....
Angel,
I am not very clear about your requirement. If you doesn't have possible values for the parameter, how do you determine the default value?
Regards,
Lydia
Hi, Anonymous
Finally, I have solved the issue. I'm trying to explain it.
The key point is that I need to append up to 15 purchase tables in Power BI desktop. Every table comes from a different ODATA Url. Every URL is a parameter.
The problem was that not all URL ODATA are always used. So, I need to introduce a value in order to create empty queries.
The first thing I tried was typing word 'NOT' in URL not used. So, I can create emtpy queries depending on this condition. That was the resason because I ask a question. I wanted NOT value by default, and only change ODATA that are going to be used.
However, I couldn't refresh when I try to refresh dataset in Power BI Service using On-premise data gateaway because there was an invalid Data Source.
How did I solve that?. For queries that are not going to used URL Odata, I introduce the same URL ODATA that parameter 1. And works in Power bi desktop and Service... Something like that... If Parameter Url 4 = Parameter URL 1 then CreateEmtpyTable and so on for every query.
It works!!!!!..
Anyway, thanks for your help....