Forum Discussion

Burma's avatar
Burma
Icon for Helper I rankHelper I
6 years ago
Solved

New bug: The column does not exist in the rowset.

Hi, recently I've started getting an error in Power BI Service, which does not happen in Power BI Desktop   I'm getting "column does not exist in the rowset" error when refreshing a published datas...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Burma ,

     

    For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

     

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

venal's avatar
venal
Icon for Memorable Member rankMemorable Member
6 years ago

Burma 

Note:-  Clear the cache from the Power BI Desktop >> File >> Options & Settings >> Options >>Data Cache, Q &A Cache (Clear Cache)

Open the PBIX file in Power BI Desktop.

Home >> Edit Queries >> Edit Queries >> Refresh Preview >> Refresh All >> Close and Apply

Home > Refresh >>Check for the data in all the visuals to all the pages in the report level.

File >> Save As >> with different name and publish.

 

Try to check with "Refresh Now/Schedule Refresh". (If it is required, try to configure the data source to the gateway).

 

If you get any error, please share the error information from the "Refresh History" by clicking on "Show Details".

PowerQA1's avatar
PowerQA1
Frequent Visitor
6 years ago

Clearing the cache just as listed her resolved this issue for me.

 

Thank You!