Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PhazedMorty
Frequent Visitor

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.

1 ACCEPTED SOLUTION

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)

View solution in original post

10 REPLIES 10
chahine1986
Frequent Visitor

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

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)

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

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

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

v-luwang-msft
Community Support
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

lbendlin
Super User
Super User

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

 

lbendlin_0-1641746399930.png

 

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?

 

PhazedMorty_0-1642597303251.png

 

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

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.