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
I'd say that the poster shouldn't have to do this, and it isn't necessarily possible. I have the exact same issue. Same error message. I've run through some basic debugging and wanted to share it.
I can create a simple dataset referring to one table in a db. Make a quick visual and publish. Works fine.
I create a duplicate and add an index column. Refreshes fine in Desktop but once published and connected through a gateway it will not refresh, with the error message as posted originally. I tried this with two different source databases. The gateway has the same Organizational security level in both instances, just as a check.
Is this a bug in Power BI? I can't see how I could be breaking anything by adding an index column.
Sam.
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 darentengmfs ,
Thank you for sharing the solution . Would you please Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
