Forum Discussion

love_numbers's avatar
love_numbers
Frequent Visitor
3 years ago

Data source errorExpression.Error: The column of the table wasn't found...

Hi, dear community members,

I am facing data refresh issues in one of my report.

When I refresh the datas at Power BI Desktop, it woks fine.

 

But getting similar error at power bi service - for both on demand refresh and schedule refresh.

It says, they are not getting a column in the table, but IT EXISTS THERE 

 

 

Data source error:Expression.Error: The column '<ccon>provider_business_mailing_address_state_name' of the table wasn't found.. provider_business_mailing_address_state_name. </ccon>. The exception was raised by the IDbCommand interface. Table: nppes.
Cluster URI:WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID:9601cadc-4b6e-495f-90d5-668be8d20feb
Request ID:f9684f6b-2e19-4604-9351-125d45f923ef
Time:2023-07-19 18:20:53Z

 

Need Help

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    Hi, love_numbers 

     

    here is what you can do

     

    1. Confirm the column name: Ensure it matches exactly on both your Power BI Desktop and Service.
    2. Check your Data Source Settings in the Power BI service. The service might be looking at an older version of your data.
    3. Re-publish the PBIX file to Power BI service.
    4. Update your Data Gateway if you're using one, as outdated versions can cause issues.
    5. Inspect your Query transformations, they might cause issues if complex.
    6. Ensure no Data Type mismatches between Power BI Desktop and Service