Forum Discussion

PhilB's avatar
PhilB
Kudo Collector
9 years ago

Help understanding Power BI error messages

Hi,   So i have a dataset which is working, i can connect to it from the power BI desktop on my work machine and i have set up a scheduled refresh which is working also.    The data set refreshes...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Phil,

 

I had similar issue before and it came from the column data type (which I hard coded)  not matching with its record data type.  

For example = Table.AddColumn(YearNumber , "Quarter", each "Q" & Number.ToText(Date.QuarterOfYear([Date])),type number), obviously it should type text.:cattongue:

 

Also, I found that it does not like Int64.Type. 

Nor sure if it applies to your case. 

 

Regards,

 

Anna

kyle705's avatar
kyle705
Frequent Visitor
8 years ago

Thanks Anna... Hard coded Int64.Type. seemed to be the problem for me!!!