Need help for, Data in one of the table not getting REFRESHED out of 4 tables

[VidSagar]

HI All,

I have 4 tables 1) Worklog table

                        2) GetIssues table

                        3) User table

                        4) Project table, all these 4 tables are directly

connected to Web, every hour the data gets updated from the application side, my PBIX file size has 3MB initially, whenever the refreshment will happens the file size gets increased based on data size,, now my PBIX FILE  has 6.6MB. When i have refreshed my report in the power BI desktop the file size gets 6.6MB to 3MB, its getting decreased. Among 4 tables in the application, one table " GetIssues table" not updating the data in the report, but remaining 3 tables works fine..

i have checked below options by searching couple of suggestions in community as well...

    1)  In file menu -- options&settings -- options in GLOBAL/ Data Load maximum allowed(MB) = changed the size from 4096 to 10000 and in CURRENT FILE/ section DataLoad = checked the option "Enable Parallel loading of tables"

    2) In the Query Editor -- checked the option "Enable Load" & "Include in Report Refresh" (by default they already checked)

    3) I have made the Source level changes by increasing the workspace in APPLIED STEPS section -- FetchPages size from 500 to 10000.

    4) And, REFRESHED in QueryEditor for both -- "Refresh Preview" & "Refresh" All options

But still my GetIssues table showing 100 records only,, not yet updated except remaining 3 tables..

Could some one please suggest me how to solve this issue...

Thanks in Advance..

VidyaSagar

[v-sihou-msft]

@VidSagar

Can you create a new .pbix and connect the "GetIssues table" directly to see what you get?

I guess the update from application side may not append to the old records for this table. If it shows correct data, I suggest you capture the Fiddler trace to see detail message for this data refresh requests.

Regards,