Forum Discussion
Direct Query report is breaking in Report Server October Version
Hi sgovindarajula,
I could publish a Power BI report with SQL Server Direct Query to Report Server. I worked fine on web portal. In your scenario, did you get any error when publishing or when opening report on portal? Please try to upload report directly from web portal to see whether it works. Also, does this problem occur to other Power BI reports with different data source?
Regards,
Yuliana Gu
Hi v-yulgu-msft,
Thanks for the response. It is failing with the below error in report server. Tried uploading the PBI file directly in the report server but no luck. The report is working fine in the power bi desktop. Everytime we open the report in Desktop, it is asking for us to validate or continue and then it starts rendering the visuals. I hope this isn't an issue.
And also we could see under data source settings, persist security info=False but when we tried to change it, the data source setiings option is greyed out in report server.
Please let me know your thoughts on this.