Forum Discussion
End user fetching data from Hana??
- I am fetching the data from a Hana view using a key date. That means I am getting the data that I need just for that specific date. With this data, I create a dashboard.
- I publish the dashboard to Power BI Service and from there I share it with an end-user.
- now the end-user wants to see the data for another day just to compare the data.
Gabr1el you cannot pull the data from power bi service. you can opt for creating another table with previous date in Power bi Desktop.....Only when the data is loaded in power bi desktop the user will be able to interact with it...
4 Replies
Gabr1el Since the end user is able to access the dashboard via apps he/she will not be able to edit the dashboard or input any prompts and moreover selection of prompt needs to be done in Power bi desktop.
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍Hi Hasna,
What should I create on the PBI desktop that can be used by the end-user in PBI Service or Apps, in order to pull the data from Hana for a previous date?
thanks
Gabr1el you cannot pull the data from power bi service. you can opt for creating another table with previous date in Power bi Desktop.....Only when the data is loaded in power bi desktop the user will be able to interact with it...
Hi Gabr1el ,
You will need to load all the data that you needed (current, previous, etc...) to Power BI Desktop. Then you could create a date slicer to select the corresponding data.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Or you could create formulas to show both current value and previous value together in a chart.
At last, publish the report to Power BI Servious and share it with end-users.
Best Regards,
Jay
