Folder as data source causing charts to not display correctly wh

Resolved · Medium Priority · Version 365

Mon 21 Aug 2023, 11:31 Delegate Angus said...

Angus has attended:
Excel Advanced 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 #).

Tue 22 Aug 2023, 20:34 Trainer Jens said...

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

Wed 23 Aug 2023, 10:01 Delegate Angus said...

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

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Optimize Report Performance

Pay attention to report performance by optimizing your data model and report design. Use the Performance Analyzer tool to identify bottlenecks in your report and improve loading times. Techniques such as using summarisation, avoiding unnecessary visuals, and optimizing DAX queries contribute to a faster and more responsive report.

View all Power BI hints and tips