Forum Discussion
Dynamic Query
Community ChampionAnonymous its hard to understand what you asking for, please provide screen shots with the expected result.
Hello vanessafvg,
Actually I have 350 tags and 15 shift back data from current shift .
Data is every 1 minutes so one shift is 8 Hours like for one shift 480 data points .
It is impossible to tack all data in power bi (350*15*480) rows
so i want to pass when i select shift date and time and tag that time dynamic data fetch from data base and show on scatter chart
Hope you understand Now....
If possible please suggest me any solution
Regards ,
pooja- vanessafvg
Anonymousso in other words from the front end you want to tell the db what to bring back? i know you couldn't do that a while back, i dont think that has changed, if you only want to bring the last day back or a data range you can use parameters in query editor, however that wouldnt work from the front end as far as i know,
What would you make that selection based on? i don think all the data in power bi is an issue if you model it correctly 2 million rows is a lot if the data is very wide but in memory has great compression, just depends on how much duplication of values there are.
Hello vanessafvg,
If I created parameter in power bi how that will refresh at Report server??live is it possible???Regards'
Pooja