Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a dataset with Salesforce as datasource. It works fine. When I wanted to migrate to Snowflake (just chaging the connector and datasource as the logic and metadata remain the same), all relationships had to be rebuilt and in DAX columns are not found. I am getting an error message - which makes the title to this post.
The paradox is that in Power Query I am not getting any error. Moreover, even DAX is fine when a fewer number of columns are imported. In addition to this, for another dataset for which I perfomed the same procedure I did not get any issues.
Can you advise?
Thank you.
Hi @sergiu2020 ,
According to the error message, it seems that some columns can't be found in the specific table. Did you get the error message when change the data source from Salesforce to Snowflake? Please confirm if the table structure referred in the error message for Snowflake is exactly same with the one in Salesforce. And could you please provide the related screenshot and executed operation with the details? Thank you.
Column cannot be found or may not be used in this expression
The fix for this error message is to find the right column name in case it has been misspelled.
Best Regards
Hello,
Thanks for answering. In my turn:
1. No, I did not get the error message when change the data source from Salesforce to Snowflake?
2. Yes, columns name are the same, dat types are the same
Rebuilding it form scratch - it works, so what you suggested works. But the idea is that is not conveninent because this migration will have to be made for hundreds of datasets - and rebuilding each one from scratch does not make economical sense. I need an explanation of why the columns are not recognized in DAX.
Hi @sergiu2020 ,
If all of the columns which refer in the error message can be seen in the model table? Could you please try to delete the measure/calculated column/table which got the above error message and re-create it with the same formula? Later check if it works or not... Thank you.
Best Regards
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
14 | |
9 |