Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dataset refreshed but data not changing

Hi All,

 

I have a report that's being refreshed on my personal gateway on Power BI Service. For a specific visualization, which is connected to Azure SQL DB, the refresh does go through but the data point would not update. But if I refresh this table manually within my .pbix I could see data changing.

 

Any idea why the data is not captured even though dataset was refreshed through gateway?

 

Thanks!

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    need more information -  Is this really import mode?  If so, why?  Did you make structural changes? Did you republish if yes?  Did you press "Reset to defaults"  on the service?

  • v-xicai's avatar
    v-xicai
    Community Support
    5 years ago

    Hi Anonymous ,

     

    If your report dataset doesn't contain any on premise data source, that is to say the dataset only has the cloud data source Azure SQL DB,  then it needn't to use the gateway. Power BI refresh will synchronizes datasets and reports with their source files.

     

    If your dataset contains not only the cloud data source but also the on premise data source, then recommend you use on premise data gateway(Enterprise mode),  and then you can configure schedule refresh. See more : On-premises data gateway , Add a data source ,  Configure scheduled refresh .  Note that you also need to select "Allow user's cloud data sources to refresh through this gateway cluster" option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

     

    In addition, you may go to  Azure portal, go to the Azure SQL database for which you're configuring refresh. At the top of the Overview blade, select Set server firewall. On the Firewall settings blade, make sure that Allow access to Azure services is set to ON. See more: Troubleshooting scheduled refresh for Azure SQL Databases in Power BI.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

  • v-xicai's avatar
    v-xicai
    Community Support
    5 years ago

    Hi  Anonymous  ,

     

    Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy