Dataset in Power BI not showing all data from excel

[astockli]

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.

[GilbertQ · Accepted solution]

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?

[astockli]

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

Thank You!