I have a pbix file which uses parameters and passes the parameters through to a SQL query to pull off transactional data between 2 date periods. The queries are in direct query mode and all works well in Power BI desktop.
However, when I publish the pbix file to the Power BI service and go to the dataset and select parameters I receive an error message stating that 'Parameters haven't been defined for this dataset yet. If you want to set parameters, use the Query editor', but I have defined the parameters!
Does anyone have any ideas, ideally I would like to have the facility to change the parameters in the service so that users can change them rather than me changing at pbix level and then having to republish.
AFAIK, if you want to use query parameters on power bi service side. You need to define them as accurate types and invoked in your query tables.(e.g. 'any', 'binary' not able use on power bi services side) Can you please explain more about your configuration and settings?
I found you are using same steps name to receive parameters, it may cause the conflict when power bi use parameters. I'd like to suggest you use other name to define receive parameters or direct use it in t-sql query.
Source = Sql.Database("xxxxx\data", "transactional",
[Query = "SELECT * from AVGdayrate A
where (A.Date > '" &StartDate& "' AND a.date < '" &EndDate& "')",
CommandTimeout=#duration(0, 0, 10, 0), HierarchicalNavigation=true, MultiSubnetFailover=true])
Community Support Team _ Xiaoxin Sheng If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For learning resources/Release notes, please visit: | |