Forum Discussion
Post PatronReport will not update after changing the parameters in Power Bi service?
Hello All,
I have a report that has StartDate and EndDate Parameters. After updating the parameters in power bi desktop, the data will change however when the report is in service and I update the both the parameters, apply the changes and refresh the dataset. After refresh; the data remains same as with diffrent parameters. I don't understand why the data is not changing. It works on the desktop though.
Any idea what am I missing?
This is a Stored Procedure that I am using.
Thanks in advance!
Keep Learning Power BI.
PThapa
I recreated the new connection and parameters, it seems working now. I don't know the delima why the previous wasn't working, but it is working now. Like lbendlin mention on his comment, might be the function will not work.
Thanks for your advises lbendlin. Appreciate your comments and time.
Keep learning PBI.
Pthapa
10 Replies
- lbendlin
Super User
Did you hit the Save button?
Are you refreshing the semantic model after you changed the parameters?
pthapaHi lbendlin,
Yes, after entering the values in those parameters, I hit Apply. Go back to the sementic model and click refresh the dataset.
- lbendlin
Did you then wait for the refresh to complete, and did you then reload the browser?
- pthapa
Yes, I waited for the refresh to complete then reload the browser.
- lbendlin
please show a sanitized version of the Power Query.
- pthapa
Here is the Power query section:
- pthapa
I forgot to add a note, when I checked the refresh history, for some reason the on-demand refresh is only taking couple seconds vs the schedule refresh usally taking about 12-13 mins. Something seems doesn't right, don't know what though!
- lbendlin
The Power Query only shows a function. Functions are not partitions, they are expressions. They will not appear in the Power BI data model. Please clarify your scenario.
- pthapa
Here is the code from Advance Editor:
Not sure if I did it wrong. My scenario is trying to have two parameters StartDate and EndDate because the stored procedure has those two parameters. It is complex query so I don't want to modify.Then have report user able to run the report based on the input on StartDate and EndDate parameters.
What would be best approach if my approach is not correct?
Thanks
- pthapa
I recreated the new connection and parameters, it seems working now. I don't know the delima why the previous wasn't working, but it is working now. Like lbendlin mention on his comment, might be the function will not work.
Thanks for your advises lbendlin. Appreciate your comments and time.
Keep learning PBI.
Pthapa
