Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi
Charts are not loading in dashboard even when there is data in the backend database.
The data is stored in an SQL server and the tables are all properly created there. Also, i can see the data in the query editor window of the powerbi. But still none of the charts are populating. It shows blank for all.
What could be the reasons for that? Can someone help resolve this?
Regards
Prakhar
Hi, @prakharkasliwal
What’s your connection mode to SqlServer(Direct query or import)? You said that the dashboard can not load data, can you see the data when you go to the original report? According to the data source is SQL Server. I suggest you to use SQL Server Profiler to explore whether there is data interaction between the dashboard and the data source. If you can not you can't do it yourself, you can share your sample pbix file and SQL Server data source file(without sensitive data) so that we can help you in advance. Thanks very much!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@prakharkasliwal , Very difficult to tell with this. There can filter on-page or report or visual. Power query changes are not saved and there can be an error
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Would be easier to debug if you can share your PBIX file. Even if there's data in the query editor that doesn't mean anything will be displayed in a visual.
Did you have visuals that are now not showing?
What data have you selected to display in a visual?
Phil
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!