Forum Discussion
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...
Therefore, in Power BI Desktop, I used the "Get data" --> "Web source" optionDo 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.