Forum Discussion

darentengmfs's avatar
darentengmfs
Post Prodigy
6 years ago
Solved

Unable to Connect to Data Source Undefined

[UPDATE BELOW] Hi,   I am having this issue when refreshing a report that I have in Power BI Services.   Something went wrong Unable to connect to the data source undefined. Please try again l...
Need Help
  • darentengmfs's avatar
    darentengmfs
    6 years ago

    Hi Anonymous 

     

    I have found the solution.

     

    The problem lies within the Index Column formula itself. Notice that it has 5 parameters, the last one being "type int". The newer Power BI Desktop version automatically adds in the 5th parameter, which is the "type". If you remove that parameter completely, you will be able to refresh in Services. However, if you do not want to remove that parameter, you could simply update your Data Gateway to the latest version. Either one works.

     

    Daren

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi darentengmfs ,

 

Please check the different privacy level settings in Power BI Desktop and Power BI Service. Make sure you have the same privacy level security:

 

In desktop:

Options and Settings --> Data Source Settings

For every Datasource: -->  Edit Permissions

 

In service:

Datasets --> (Choose you Datasets which does not update properly) --> settings --> Gateway Connection --> Actions --> (expand you cluster to show all Data Sources) --> (Choose relevant Datasource) --> Advanced Settings --> Privacy setting

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

darentengmfs's avatar
darentengmfs
Post Prodigy
6 years ago

Hi v-deddai1-msft 

 

I have set everything to organizational but it still does not refresh in Power BI services.