Error as Unable to render paginated report

[Kavindya]

Hi all,

I'm using ODBC to connect the dataset and it is showing below error message. 

can anyone help me to find out a solution. 

Thanks in advance. 

[v-rongtiep-msft · Accepted solution]

Hi @Kavindya ,

According to your data refresh error information provided, the reason for your data refresh failure has been clearly pointed out that the configuration credentials of the data source definition or gateway are not enough to provide to the Power BI service to refresh this dataset, you can go to the dataset setting interface in detail, find the "! , select Click Edit credential to re-enter and configure credentials for them, consider using a gateway for on-premises data sources:

For details, you can also check out this official document:
Configure scheduled refresh - Power BI | Microsoft Learn

I have also found some similar posts, please refer to.

Solved: Created a PBI Paginated Report using SQL Query, PB... - Microsoft Power BI Community

Solved: [Report Builder] Could not connect to data source,... - Microsoft Power BI Community

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.