Forum Discussion
Unable to Connect to Data Source Undefined
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
Hi lbendlin
I am not sure. This new query is referencing to another query with added new steps that does not seem to be the problem. I have added 3 calculated columns for that table with these formulas:
Running Total =
Calculate ( SUM('Cost'[Value]), ALL('Cost'),
'Cost'[Index] <= Earlier('Cost'[Index]))
and
Running Total % =
'Cost'[Running Total]/Sum('Cost'[Value])
and
Group = if('Cost'[Running Total %] <=0.3, "A", if(and('Cost'[Running Total %] > 0.3, 'Cost'[Running Total %] <= 0.6), "B", if('Cost'[Running Total %] > 0.6, "C", "Error")))
They all run just fine and refreshes just fine in Power BI.
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
I have set everything to organizational but it still does not refresh in Power BI services.
I have edited the thread and there's an update to it.
Basically the problem arises when I added an index column in the query. This index column is needed to get what I need so removing it isn't an option for me.
Can you add the index in your data source, before ingesting the data in Power BI?
Hi lbendlin
The query with the index column is created by merging 2 other queries with multiple steps. I can try this but it will be my last resort if there's no other way.
