98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Folder as data source causing charts to not display correctly wh
Folder as data source causing charts to not display correctly wh
Resolved · Medium Priority · Version 365
Mon 21 Aug 2023, 11:31Delegate 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:34Trainer 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:01Delegate 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
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Optimize Report PerformancePay 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. |
