Sharepoint list connection returns only 197 rows [IN Sharepoint list is 388 Rows and updating daily]

[MKRANCS]

Hello,

I did set-up a data Connection:

• MS Forms -> Power Automate to Sharepoint list -> Sharepoint list to PowerBI

I set-it up at beginning of 01/10, everything worked with daily refreshes till 12/10.

Then since 12/10 doing daily refreshes PowerBI Data does not get more data from SharePoint list (Stopped @ 197 rows): What have I done to figure this out?

• MS Forms & Power automate is working and syncing fine -> records appear in SharePoint list (In the attachment below, we can see that new data from 22/10 is appearing)

• Column proofing is based on the entire data set, so no issue there.

     3. All credentials and authentification is working good -> When pressing refresh, download happens, but still nothing more than 197 rows appears.

Im confused & Stuck + Cant find a solution in other posts, and I don't want to create an entire data set-up again, just to try if it will be working now.

Really, looking forward to some simple help.

Thank You!

Martins

[jcastr02]

@MKRANCS  @lbendlin  @v-deddai1-msft Hello did you ever know what caused this , I am experiencing the same issue-source coming from SharePoint 

@lbendlin - For below I get ~199 rows

When I do implementation 2.0 - then I get this error message

[Syndicate_Admin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[v-deddai1-msft]

Hi @MKRANCS ,

Would you please check if you have applied filter when loading data to power bi from sharepoint list?

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

Best Regards,

Dedmon Dai

[lbendlin]

post your power query code for that data source.