Forum Discussion

Nurry90's avatar
Nurry90
Icon for Helper I rankHelper I
5 years ago
Solved

Power Bi Gateway

Hi All,   I have published a report to the service, scheduled refresh and everything seemed fine until I realised my excel file was not updating. I have added a column to my excel file, and noticed...
Need Help
vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
5 years ago

Hey Nurry90 !

 

Adding a new column in an Excel table and it not reflecting in the Power BI report can be a result of steps applied on Power Query as well. Can you please check if you add/remove/modify rows in the excel table is relflecting in your report? This way you can validate if your gateway refresh is working properly.

 

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

  • Nurry90's avatar
    Nurry90
    Icon for Helper I rankHelper I
    5 years ago

    HI vivran22 ,

     

    I have deleted one of the colums as a test in my excel file and tried to refresh my datasent, and received an error to say that the column was no longer there. So now at least I know the gateway is working. But why would the new data not be showing?