Find Power BI data sources for on premise server
How can I run a query (sql, powershell, or rest) to find all the data sources of my Power BI dashboards? Most the documentation is around using powershell but the soultions are all against the cloud Power BI service. I have a local/on premise Power BI server and I am trying to document the SQL server names and databases for each of the published dashboards. It would be helpful if it looped through all the dashboards in the sub folders so I don't have to manually add the indivdual dashboards.
Vanishing Slicer Data, differing User Experiences
We use a dashboard with multiple interrelated date filters. Today, while using the dsahboard, I adjusted the month slicer by removing checked months to narrow the focus. When I did, those month disappeared from the slicer and could not be brought back. I've tried refreshing the dashboard page, refreshing underlying data, rebooting my PC, accessing through different browsers, clearing browser history and cookies, and opening the desktop version as well. None restored the slicers to functionality. Oddly, no other users are having the same issue. The same behavior occurs in desktop Power BI. I'be tried adding a new slicer and associating it with the same data. When added, it shows no data though there is data in the underlying table. Help?!
ERROR EN ACTUALIZACION PROGRAMADA
Hola comunidad, Tengo un problema al momento de que se ejecutan mis actualizaciones programadas, pues me está llegando un correo indicandome que ocurrió un error en la actualización, pero, no me detalla a que se debe. Por favor, ¿alguien me podría ayudar a personalizar los errores que se envian por correo y, en este caso puntal cómo identificar a que se debe y poder solucionarlo? Cabe resaltar, que me conecto vía MySQL para obtener mis datos. El error es el siguiente: Oops, something went wrong. Refresh failed: 09_MI_REPORTE has failed to refresh. Failure details: Next refresh for 09_MI_REPORTE is scheduled for March 15, 2019 18:30 UTC. Learn more > "https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios" Technical Information Activity Id: ec544bf2-7997-4a38-b17e-25bdd441cb06 Request Id: d11cc2a3-cbb7-4275-8c1c-4e8617bb8c06 Cluster Name: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net Refresh Start Time: March 15, 2019 21:02 UTC Refresh End Time: March 15, 2019 21:16 UTC Gracias por su apoyo. Daniel Castillo
Request dashboard credentials
Good Morning, After updating the report server to the January 2019 version, some dashboards started requesting user and password for viewing. Follow the image with the message "your connection to this site is not private". https://1drv.ms/u/s!AvdvqhTl8gnGm1oUGZwNsT2IIzEF Any idea how to solve the problem?
Subscription for on-site server
Hi, May I know if we were to deploy a on-site server with 2 developers and 10 viewers for personal dashboards, what kind of subscription should I go for? The premium one seemed too extreme the server has to be hosted locally due to sensitive data and we do need the remote virtual machine. Thank you.
