Forum Discussion
Solved
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...
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.
lbendlin
Super User
Super UserYou 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.
