topic Re: Power BI Report Builder unable to connect to dataset in Developer

Power BI Report Builder unable to connect to dataset

patrail — Thu, 06 Jan 2022 17:13:42 GMT

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!

Re: Power BI Report Builder unable to connect to dataset

V-lianl-msft — Mon, 10 Jan 2022 05:49:27 GMT

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.

Re: Power BI Report Builder unable to connect to dataset

patrail — Mon, 10 Jan 2022 22:04:55 GMT

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.

Re: Power BI Report Builder unable to connect to dataset

Sean12321 — Tue, 11 Jan 2022 17:43:34 GMT

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.

Re: Power BI Report Builder unable to connect to dataset

bond — Fri, 04 Mar 2022 08:56:59 GMT

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

Re: Power BI Report Builder unable to connect to dataset

Anonymous — Wed, 03 Aug 2022 11:55:43 GMT

Hello,

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

Thank you