Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Power Query only shows first row

Hello community ! I am writing this post because I am experiencing a Power Query issue today. I have a .xlsx source stored on a Sharepoint location, which I would like to use on Power BI. Therefore...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago
Therefore, in Power BI Desktop, I used the "Get data" --> "Web source" option

Do not do that.  Use the Sharepoint Folder connector.

 

Did you select "sheet"  or "table"  as your source ?   Maybe the table definition is limited to a single row.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

I have the same issue using the Sharepoint Folder connector. The selected source is a "sheet".

Weird thing I saw is that when the .xlsx file is updated by a person, I seem to have all data on the Power BI. But when the file is updated by the "Sharepoint App", I only get the first row.

Could that be possible ?