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.
Unable to update this data source's credentials. Invalid connection credentials.
I am trying create new dataflow. When I am connecting to data source, the system give an error. Please help me to fix this error. Details: BI data: The credentials provided for the Folder source are invalid. (Source at g:\my drive\trust bi data.) Please have this information handy if you choose to create a support ticket. ActivityId: 6910f48d-5acf-4468-9da2-3a8ed294c802 RequestId: 23f41a32-ae12-466b-a437-a6a7e5daa945 Cluster URI: https://api.powerbi.com Status code: 400 Time: Mon Apr 17 2023 17:01:54 GMT+0700 (Indochina Time)
Where are we with Shared Data Sources for Power BI Reports?
We are going through updating some documentation for deploying paginated reports and Power BI reports to Power BI Report Server, and I'm being reminded of how clunky the situation still is with managing data sources for PBI reports. I noticed in the January 2020 release there is a new PBIDS format, and it got me wondering if this might be a path to getting pubished shared data source that can be used for multiple reports? It's just one more difference between the paginated and Power BI reports that makes things feel disjointed.
