Angus has attended:
Excel Advanced course
Power BI Modelling, Visualisation and Publishing course
Folder as data source causing charts to not display correctly wh
Hi there, I have set up a report where the data source is a folder on our shared drive. The folder is filled with CSV files with the same format, that are being transformed by PowerBi into one continuous table. I have set up various charts and filters to show frequency over time - each row in the dataset has a date & time logged to it, so I have used the Advanced Editor to build a Date Table to link to the data.
My issue is that having added a new CSV file (formatted in the same way) to the folder and refreshed the report, the data is displaying correctly in both the Table View and when viewed through Transform Data, but the charts in the report are showing as completely blank white spaces when sliced to look at the new data (I have a slicer to filter by year, month, and week #).
RE: Folder as data source causing charts to not display correctl
Hi Angus,
Thank you for the forum question.
Have you tried to make a new visual after you have added the new CSV file? to check if you can see the new data.
Have you in the query editor checked the data quality after the new CSV file has been added?
Do you have DAX measures which return the values on the chart?
You have used the Advanced Editor to build a Date Table. I do not know how you have build it. Is it dynamic so it generate the dates from the CSV files? If your date table is static and you add CSV files to the folder with dates without a related date in you date table you will get blank white spaces in the chart.
Sorry I am not very helpful, but it can be a lot of different issues which give you the problem.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Folder as data source causing charts to not display correctl
Thanks Jens! Simply creating the visual again was enough to solve the issue. I should have tried that before messaging here!
For the record, the date table is dynamic. But that doesn't seem to have caused the problem.
Thanks again
