Is it possible to get report error message that display when someone open the report?
I created an API alert system that would alert report PIC about the error through telegram, the thing is the detail error message only available for data refresh but not for user execution error. I tried looking in execution log 2 & 3 but no luck, all I can get is execution status and additional info. I tried looking in log file but no relevant information was found either. So my question is, is it possible to get the report error message that occured when someone viewing the report. TLDR; I want to get above error message, ideally from report server database tables. Is it possible? Thanks.
Unable to perform Direct Query against SQL Server
We recently upgrade to PBIRS and are excited to take advantage of leveraging PBI on-premise. We have created some basic PBIX files that are configured as Direct Query. They work fine in PBI desktop, however, we get the following error when trying to run the PowerBI report after it has been uploaded.
PowerBI License with SQL Server Enterprise (SA)
I have a trial version of PowerBI Report Server running. The PowerBI Report Server is NOT running on our core corporate SQL Server Enterprise Instance. We have SA. I know that running SQL Server Enterprise with SA entitles an organization to run PowerBI Report Server. Since it is typical to run reporting services on another (isolated) instance I would expect the ability to setup such an instance would be covered with our existing Enterprise license. Thoughts? Thanks, Bill
