PowerBI Service not detecting formatted excel tables within excel workbook

Hi Anonymous ,

I can't reproduce your scenario, can you show more details like screenshots?

Best Regards,

Jay

Hi,

I do not have permission to upload pictures so I have attatched a google drive folder with the screenshots:

https://drive.google.com/drive/folders/1tIHch4hnno30qtmVVSo7WuwQRxKkJF4F?usp=sharinghttps://drive.google.com/drive/folders/1tIHch4hnno30qtmVVSo7WuwQRxKkJF4F?usp=sharing 

1. This screenshot shows the excel workbook I am uploading to Power BI, from Sharepoint

2. This shows how I am connecting to the Sharepoint excel workbook using Power BI Service

3. This shows the Fields tab after importing the Sharepoint workbook into Power BI. It only shows 2 formatted tables instead of 3. Additionally, I have since changed the names of Table1 and Table2__2 on excel, which has also not been detected.

4. This is the third formatted table in the spreadsheet, using only flat data (the totals list is not within the formated section)

5. This shows two of the PivotTables in the workbook on another spreadsheet. 

After duplicating the excel file and then removing the PivotTables, Power BI properly imported the data in a report. Is there any way to import this workbook into Power BI without having to remove the PivotTables?? Does the data then cease to be 'flat data' if it has connections to PivotTables?? Even though the PivotTables only connect to 2 of the 3 formatted tables?? It would be hugely helpful to find out if there are ways around this as the workbook is shared among my working team where the PivotTables are used by others. 

Thanks,

Alex