Forum Discussion
Power BI not loading the data in certain tables
Hello,
I have a Power BI dashboard that pulls daily files from Sharepoint and feeds the Power BI. The report was working properly when all of a sudden it stopped loading the data in the csv files it's feeding from.
The csv files have the data and the power BI is loading the files but instead of data, it's loading all the columns with null values. This is happening with files after July 2024. The rest of the files are loading properly. Do you know how I can fix this?
Thanks in advance!
You would have to modify the CSVDecode step.
But - all of these steps could be part of the Power Query ETL process if you want. You can use things like
try ... otherwise ...
to ingest the raw CSV either with commas or with tabs and then you can delete/discard the columns with the PII.
10 Replies
- lbendlin
Super User
Assuming your data source is Excel files on the sharepoint - are you connecting to Excel sheets, or to named tables?
I'm connecting to a Sharepoint folder that has all the csv files it feeds from. Please see the source settings below:
Then I filter based on the file name:
Then I exctract those files and expand them to see all the rows in them:
That's the data I use to load my report, but as of July this year, it started loading the tables with null values and I don't know why. When I check the files in Sharepoint, the data is there, the problem is in the Power BI.
Thank you for your help.
- lbendlin
Please do not sort the table in Power Query - that is a very expensive operation that likely has no benefit (Power BI is ignoring the Power Query sort order).
Can you you isolate the CSV file that causes the issue or do you only see nulls across all files?
