Forum Discussion
Unable to connect to data source. (Power BI dataset)
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.
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)
10 Replies
- lbendlin
Super User
Do you know which locale was used in the queries for the dataset?
- PhazedMortyFrequent Visitor
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?
- lbendlin
Super User
You are trying this from excel, right? See if you can use the Analysis Services connection instead.
- v-luwang-msft
Community Support
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
- chahine1986Frequent Visitor
am having the same issue, did you find a solution for that?
- PhazedMortyFrequent Visitor
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)
- chahineatallah
Helper III
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
- PhazedMortyFrequent Visitor
No, i havent found a solution for this. I installed power bi report builder on a different system and it was working there.