Forum Discussion
This report couldn't access the data source, for some users, sometimes
Hi! We're using a setup with SSAS hosted on a azure server, and direct connect Power Bi reports. We use RLS in SSAS and a Gateway (keeps it updated). Some users maybe 10-20 out of ...
I have the same issue (getting the error message: "This report couldn't access the data source. Contact NAME, the report author to get it fixed".) while used Incremental Refresh for a Power BI report with the DirectQuery enabled for the last month of data. I haven't set up any RLS for this report and this error is shown to me who is the owner of the report. The report gets refreshed successfully using the on-Prem gateway to a SQL Server connection and when I re-publish it to a different workspace without the DirectQuery (Import Only) it works fine. Any ideas or solutions?