cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New_Folder
Frequent Visitor

Not all Tables are loaded in Power BI Service (not using Power BI Desktop)

When I go and create the report, I only see these tables:

 

New_Folder_5-1637615924466.png

 

But the actual file has 

 

New_Folder_6-1637615947056.png

 

I would be pleased to see a solution not involving Power BI Desktop App.

 

I loaded/created my data set using the intruction below:

 

New_Folder_1-1637615722230.png

New_Folder_2-1637615747762.png

New_Folder_3-1637615803225.png 

New_Folder_4-1637615853015.png

 

 

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

Hi @New_Folder ,

 

Please make sure all these table have been added to a data model. Otherwise them won't be added to the dataset.

Refresh a dataset created from an Excel workbook - cloud - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

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

View solution in original post

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

Hi @New_Folder ,

 

Please make sure all these table have been added to a data model. Otherwise them won't be added to the dataset.

Refresh a dataset created from an Excel workbook - cloud - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

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

View solution in original post

GilbertQ
Super User
Super User

Hi @New_Folder 

 

What that does work for some cases using the Power BI Service, I would suggest using Power BI Desktop to check and make sure that all the data is loaded as expected.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog


@GilbertQ wrote:

Hi @New_Folder 

 

What that does work for some cases using the Power BI Service


What do you mean by this?

I am trying to do away with the APP, but I will try just to check all the tables are working OK.
If yes, what do I need to do? 

If no, what do I need to do?

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!