Forum Discussion
Post PatronExport to file for paginated report error- integrated security in the connection string
Try changing the datasource settings and unchecking the "Report viewers can only access this data source with their own Power BI identities using DirectQuery." box in the "manage" menu option page. if you are using a SQL authentication, change authentication to be basic, then click sign in.
Post PatronHi Anonymous
I have parameters in the paginated report. I want to run the whole report without passing any values to the parameters. I have tried all options but still getting the same error. Any pointers?
The problem is with the pagainted report. The API is unable to authenticate the export using windows or microsoft account authentication. It appears to need to be mapped to a gateway or SQL authentication.
Anonymous is there anything you can do to get a resolution to this? passing a value through the identities placeholder doesn't work either. I still get the same error
- bml123
hi @sdruval,
I am using SQL authentication but still not working.
Try changing the datasource settings and unchecking the "Report viewers can only access this data source with their own Power BI identities using DirectQuery." box in the "manage" menu option page. if you are using a SQL authentication, change authentication to be basic, then click sign in.
- bml123
Hi sdruval,
Thank you so much for this. You made my day.
It's working now. Just can't believe that simple untick makes it working.
How did you know this? Thanks alot for this information.
Thank you very much. It saved us lot of time with this working again.
I'll have to try it on my end and see what happens. I know the only time i've gotten this to work is if I assign the report to use a gateway. When it uses the gateway it runs as SQL authentication, so I just assumed SQL Auth in the actuall connection string would work.