Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
New_Folder
Helper I
Helper I

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors