Power BI Report Builder unable to connect to dataset

[patrail]

Hi,

I am trying to modify my paginated report dataset for a report connected to PBI datasource.  The query runs fine in the Query Designer but when I close it I get the following error:

Unable to connect to data source. Please verify the connection properties., credentials, and all needed 64-bit versions of data providers are correctly installed. 

I have tried downloading the latest version of Report Builder and logged out and back into my PBI account. Any suggestions are greatly apprciated, thanks!

[Anonymous]

Hello,

Did you find the solution? when yes, could you please share? I'm facing the issue.

Thank you

[bond]

Hi,
Did you find a solution to this?
I have 2 memebers of my team that are experiancing the same issue.

[Sean12321]

Hi Liang,  I am also having the same issue with access to my Power BI dataset in Report Builder.  The exact same messge pops up and I have the most recent versions of the gateway and Report builder.

[V-lianl-msft]

Hi @patrail ,

What is the data source and how do you connect to it?

See if these will help:
https://community.powerbi.com/t5/Power-Query/ODBC-Connection-Error-Driver-Error/td-p/163517 
https://whitepages.unlimitedviz.com/2019/10/fixing-power-bi-report-builder-connection-errors/ 

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

[patrail]

Hi Liang, thanks for the response. I reivewed both links and neither seem to solve the problem.
I'm connecting to a dataset I have stored in Power BI service.