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.
Power BI Report Server Data Sources and Scheduled Refresh
I'm having several problems with Power BI Report Server that I hope someone can help with. When I first uploaded my model, the rendered page was completely blank, and when I went to the Settings to adjust the Data Sources I was getting "System.InvalidOperationException: Authentication type Integrated is not supported." I then upgraded from June 2019 to September 2019 release and rebooted the server. It was still not working, so I deleted the model from the server, checked the data sources and re-uploaded the model. The data sources then appeared, and allowed me to change them, but the Scheduled Refresh pane gave me an issue saying (paraphrasing, unfortunately I no longer have this message): "Cannot refresh when there is a DirectQuery data source" I double-checked the model and there were no DirectQuery data sources. I then recreated the data sources in the model, it is a mix of SQL (on premise) and Excel, and I have even removed the Excel data sources just to make sure it was only the Import SQL sources, and re-uploaded. Now, there are no Data Sources showing in the settings for the model on the server. The section for Data Sources is inactive, and cannot be clicked, and the error message on the scheduled refresh pane is "Scheduled Data Refresh is not available for reports. The report does not have any external data connections defined or is using an unsupported data source." The report is rendering, but we want it to refresh at 2am each day and so this is causing a lot of frustration, and a lot of annoyance with our management. Tangential: It is also really frustration that most errors, including why a report won't upload from Power BI Desktop to the server, show no appropriate messages, and the underlying issue needs to be investigated against a log on the server. When a problem occurs uploading the user only gets a message that it couldn't be uploaded, and not why. Any errors to do with the server are opaque and again you need to read the logs. Really poor experience.Unable to see datasources from sql server mobile reports publisher
Hi mates, I am new to power bi report server. I have logged in to power bi web portal. I have created new data source(sql server). Connection successful with windows authentication. I am developing a dashboard using Sql Server Mobile Report Publisher. Established connection(localhost/reports) but couldn't see the datasource I have created in web portal. What could be the issue Please suggest Regards Raj
