Forum Discussion

PhazedMorty's avatar
PhazedMorty
Frequent Visitor
4 years ago
Solved

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.
reportbuilder
unable to connect
  • PhazedMorty's avatar
    PhazedMorty
    4 years ago

    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)

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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

 

 

PhazedMorty's avatar
PhazedMorty
Frequent Visitor
4 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

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

    • PhazedMorty's avatar
      PhazedMorty
      Frequent Visitor
      4 years ago

      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.