Forum Discussion

nm17844's avatar
nm17844
Frequent Visitor
2 years ago
Solved

Getting Error as specified method is not supported while using direct query or import from Big Query

Hi Team,   In my model I have one fact table and one calendar table both are in direct query mode, also having relation based on date column, however when am trying to create a simple table visual ...
  • nm17844's avatar
    nm17844
    2 years ago

    Hi Anonymous  

    The issue was due to data type of the columns which we are using for joining the fact table and calendar table , I was trying to change data type from modelling tab which is not working ,however when changed from power query editor the error got resolved .

     

nm17844's avatar
nm17844
Frequent Visitor
2 years ago

Hi lbendlin ,

 

I am not sure of other data source, however this issue has been resolved.

From the error it seems like things has not been supported at source level(Specified method is not supported.), however issue was due to data type.

I was trying to change data type of joining field from the modelling view and it was not working out so i tried to change data type from power query editor and issue got resolved.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, nm17844 

Glad to hear you solved the problem yourself!  
If you can, please share your solution, which will be beneficial for future users to read this post. 

Best Regards

Yongkang Hua

 

  • nm17844's avatar
    nm17844
    Frequent Visitor
    2 years ago

    Hi Anonymous  

    The issue was due to data type of the columns which we are using for joining the fact table and calendar table , I was trying to change data type from modelling tab which is not working ,however when changed from power query editor the error got resolved .