Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Please can someone help, i have reports that have worked previously and have now stopped.
The error that comes up on the web:
"Couldn't load the data for this visual
The query referenced calculated table 'DateTable' which does not hold any data because evaluation of one of the rows caused an error.
Please try again later or contact support. If you contact support, please provide these details."
When checking the Date Table on Desktop i get:
"The start date or end date in Calendar function can not be Blank value"
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@Gem-M ,
Take out this from min(AllSupportTickets[created]) and check is working or not, what value is it giving ?
CALENDAR (min(AllSupportTickets[created]), eomonth(Today,2)),
or use firstnonblank(AllSupportTickets[created] ,date(2015,01,01)) , that will ensure value you have even it is null.
Also make sure that column is not deleted or rename, if so do the required changes
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Looks like it was a credential problem for the AllSupportTickets table which in turn caused the other errors.
Thank you for your time and assistance everyone.
What is the data source for AllSupportTickets table? - Jira - Rest API i think.
I have checked the All Support Tickets table and it is empty, only the headings.
I am unsure why this has stopped getting the data.
The reports are dynamic which i think the reports were set up with DAX, they report on the previous 12 months from the current month along with other date ranges 😞
Hi @Gem-M ,
Beacuse AllSupportTickets table can't get data, I suggest you could create calendar by calendar(date(2020,1,1),today()), use today() or fixed date, then create relstionship between AllSupportTickets and calendar table, which should work.
You also could check whether AllSupportTickets can't get data is caused by credential problem or network problem.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |