Forum Discussion

pbi101's avatar
pbi101
Frequent Visitor
6 years ago
Solved

Refresh Error in PowerBI Service. No issue refreshing in Desktop

I get the following error while attempting to refresh the dataset in Power Bi Service. I am using the August 2020 version of PBI Desktop. There is no error refreshing in desktop or while publishing ...
pbi101's avatar
pbi101
Frequent Visitor
6 years ago

Hi Anand24,

I checked the code when I got the error. 
I have not used Table.FromRecords explicitly in any of the m queries in my report.
But, I have used Table.AddColumnIndex in two occassions.

From the name "Index" in the error message I think there is some issue with Table.AddColumnIndex which does not appear in PowerBI Desktop.

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

Hi pbi101 ,

 

Did you have steps like 

= Table.AddIndexColumn(#"Added Index", "Index.1", 0, 1, Int64.Type)

in your m query?

 

Try to use the following one:

 

= Table.AddIndexColumn(#"Changed Type", "Index", 0, 1)

 

and try again.

 

For more details, please refer to the similar post:https://community.powerbi.com/t5/Service/Unable-to-Connect-to-Data-Source-Undefined/m-p/1323849/highlight/false#M106794

 

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

 

  • pbi101's avatar
    pbi101
    Frequent Visitor
    6 years ago

    Thanks!  Removed the type and it worked.