Forum Discussion

irfan_abdrhman's avatar
irfan_abdrhman
Helper II
2 years ago

Column not updated according to Azure

Hi Community, 

I would like to ask if there is a fix or workaround when column is not being updated to the Power BI when get Data from Azure. I am  not able to share directly the data from Azure but I will explain by using excel.

Excel (Azure) : Added a new column 

 

Power BI : Shows only 3 Columns as the Azure is not able to update the power BI

 

Tried to refresh but it will still not update the new row unlike using excel as source.

Please message me if there are confusion about this matter, I will address them, thank you.

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi irfan_abdrhman ,

     

    In Excel in Azure, after adding a new column, is there a successful saving? Sometimes there will be a delay in the success of the auto-save, you can try to manually Ctrl+s to save it again. You can also try to enter the Power Query Editor from Power BI Desktop, and click the refresh all button to refresh the data.

    If that doesn't work above, try reconnecting to this data source to see if the data is up to date.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • irfan_abdrhman's avatar
      irfan_abdrhman
      Helper II
      2 years ago

      Hi Anonymous , yes I have to manually ctrl + S, however it prompts out an error that is not fixable. The method is to create a new power BI and recreate everything from scratch. I would like a workaround for this issue. Do you have an idea? I would like to avoid recreating everything as it would be troublesome and as I'm dealing with client that is viewing the dashboard at times I might not be able to fix. So if you could analyze this issue, would be great. Thanks Stephen.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi irfan_abdrhman ,

         

        Thanks for your reply.

        This sounds like an issue with the data source, not with Power BI. If the data from your data source isn't able to save properly, it really won't be refreshed in Power BI.

        And I have a question, you said that your method is to recreate Power BI, does that mean that when you recreate Power BI, you can successfully connect to the updated data? 

         

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.