Forum Discussion

jirineoral's avatar
jirineoral
Post Patron
10 years ago

Server name parameterization causes refresh issues

Hi, last Power BI desktop update introduced parameters. I changed hard coded Server name in pbix and replaced it with parameter SERVER_NAME. After this change refreshes through Enterprise Gateway to...
General Comment
jirineoral's avatar
jirineoral
Post Patron
10 years ago

Hi dimazaid,

I'm importing data from SSAS Multidimensional. In my .pbix file I had server name as constant for all my MDX queries. Refresh worked ok. After introduction of parameters. I replaced server name with parameter passing the same value of registered data source in Power BI Enterprise Gateway. Refreshes started to fail. Because I did multiple steps lately (updated Gateway as well) I didn't know what the problem is.

Yesterday I simulated same steps on demo data before changing server name to parameter value. Refresh works, after change fails witch unknown error in EG.

So I suspect that this is problem of EG that it somehow can't read properly parameter value? Not sure.

 

Jiri

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

jirineoral - While I realize it is a workaround, it would be interesting if you tested the techique I posted to see if the EG's problem with parameters is a general problem or if it is specific to the use of the parameter as the server name/connection string.