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

Dataset in Power BI not showing all data from excel

I have a table populated form Microsoft Forms via Flow in Excel on Sharepoint.   When I create a dataset in Power BI to pull that information in it will only show a few columns but not all.  I have tried refreshing the data and deleting/recreating the data set.   Also deleted the table and recreated it in Excel.  Any ideas?

 

On a side note when I tried to manage the data in Power BI using Excel, all the data appears.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dataset in Power BI not showing all data from excel

Hi there

Are you creating the dataset directly in the Power BI Service?

If so I would suggest potentially syncing the file with OneDrive and then connecting to it that way in Power BI Desktop?

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

"Proud to be a Datanaut!"


Power BI Blog
2 REPLIES 2
Super User
Super User

Re: Dataset in Power BI not showing all data from excel

Hi there

Are you creating the dataset directly in the Power BI Service?

If so I would suggest potentially syncing the file with OneDrive and then connecting to it that way in Power BI Desktop?

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

"Proud to be a Datanaut!"


Power BI Blog
astockli Frequent Visitor
Frequent Visitor

Re: Dataset in Power BI not showing all data from excel

Yes I am syncing directly to Power BI.  I'll give OneDrive a shot.

 

Thank You!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 259 members 2,917 guests
Please welcome our newest community members: