topic Re: Unable to connect to data source. (Power BI dataset) in Report Server

Unable to connect to data source. (Power BI dataset)

PhazedMorty — Fri, 07 Jan 2022 06:41:06 GMT

Hi all,

Im getting the error unable to connect to datasource, which is a powerbi dataset in powerbi report builder.

Details: The '19465' locale is not supported.

Re: Unable to connect to data source. (Power BI dataset)

lbendlin — Sun, 09 Jan 2022 16:40:08 GMT

Do you know which locale was used in the queries for the dataset?

Re: Unable to connect to data source. (Power BI dataset)

v-luwang-msft — Tue, 11 Jan 2022 05:51:56 GMT

Hi PhazedMorty ,

Is it possible to download the Pbix file and open the Pbix file with Power BI desktop? Also, if there is no confidential data in that dataset, please share your Pbix file and I will try it locally.

And refer:

https://community.powerbi.com/t5/Desktop/Locale-settings-not-working/m-p/49588

Best Regards

Lucien

Re: Unable to connect to data source. (Power BI dataset)

PhazedMorty — Wed, 19 Jan 2022 13:08:59 GMT

I am not sure. Below is the error I am getting. while trying to import a power bi dataset

Do I need a premium license to import a power bi dataset?

Re: Unable to connect to data source. (Power BI dataset)

lbendlin — Wed, 19 Jan 2022 13:29:25 GMT

You are trying this from excel, right? See if you can use the Analysis Services connection instead.

Re: Unable to connect to data source. (Power BI dataset)

PhazedMorty — Wed, 19 Jan 2022 14:13:13 GMT

The original data source is an oracle database. I can connect to the oracle database from report builder, but i do not have options to create relationships with tables other than through query and i do have custom columns created in the powerbi dataset i would like to recall.

Re: Unable to connect to data source. (Power BI dataset)

chahine1986 — Sat, 18 Jun 2022 09:21:58 GMT

am having the same issue, did you find a solution for that?

Re: Unable to connect to data source. (Power BI dataset)

PhazedMorty — Tue, 12 Jul 2022 11:32:40 GMT

No, i havent found a solution for this. I installed power bi report builder on a different system and it was working there.

Re: Unable to connect to data source. (Power BI dataset)

PhazedMorty — Wed, 13 Jul 2022 06:29:09 GMT

Just as an update. I have found a solution for this in my case.

I have changed the windows regional settings to English (United Kingdom), restarted the system and it started loading without any issue after that.

Locale: 19465 is en-AE (United Arab Emirates)

Re: Unable to connect to data source. (Power BI dataset)

chahineatallah — Sun, 21 Aug 2022 17:04:50 GMT

lol, so strange i did same & it worked, i changed my regional settings from uae to uk and it worked,

very strange like if am in uae it should give an error unless i change settings to uk

Re: Unable to connect to data source. (Power BI dataset)

Abubaker_Ahmed — Sun, 14 Apr 2024 11:55:49 GMT

I faced the same problem , and I do this solution and it works 100%