PBI service dataset can't show all sheet

[Qiufen]

Hi all, 

If anyone could help on this.

I have a quarterly update excel file with multiple sheets uploaded into SharePoint folder, and then uploaded into PBI dataset.

What I want to do is to create a report with dashboards to present quarterly, ongoing updating new data.

However, when I try to open the dataset on service itself or from the PBI destop, it won't present all sheets in the file, only a few sheets.

What did I do wrong, how to show all data sheet, or is there any better solution for my scenario?

Thanks a million

[v-xiaoyan-msft]

Hi @Qiufen ,

Can you show the error page without sensitive information, as far as I know, the details of the dataset are not shown in Power BI Service, please check your action.
Also, please note if you have checked these sheets and not hidden them.

Best Regards,
Community Support Team _ Caitlyn

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