Dataset connected to SharePoint, creating reports by PowerBI Desktop issue

[Qiufen]

Dataset was connected to SharePoint by online service.

When creating reports by PowerBI Desktop, there is no table on the left tab.

As by default, the data in tables by the fields are all in sumarized and I can't choose "Do not summarized" because the table is missing in the panel.

Has anyone meet the situation before? Or what is the best way to connect your data from the SharePoint as an example that the data might be updated by team members constantly?

Many thanks for helping me, if anyone know the best solution would be appreciate your ideas

Cheers

Qiufen

[amitchandak]

@Qiufen , Is it a Power Bi dataset live connection? With a live connection, you can not change. But import data from SharePoint should work as normal import

[Qiufen]

@amitchandak  Hi there, thanks for helping:)

No, it wasn't live connection, just connect to SharePoint with the folder link

[amitchandak]

@Qiufen , Power bi Service App?

[Qiufen]

PowerBI service online