Forum Discussion
Data Preview not working while creating relationships
Hi Everyone,
I am trying to create relationship between two tables that are connecting to dataflow using direct query. when i try to create relationship in modelling tab, i was not able to see data preview for some reason. Not sure if this is due to large data since my two tables are large with Millions of records.
Please help me know if there is any other way to reduce performance issues. would like to understand if there's any way to get this data in import mode without any issues.
hello vamshikrishna20
if you mean value inside your table by data preview, i believe you can not see in direct query mode as direct query does not store your data inside pbix.
you can see the value using visualization though. or you can summarize all column in new table to see the value.
Thank you.
5 Replies
hello vamshikrishna20
if you mean value inside your table by data preview, i believe you can not see in direct query mode as direct query does not store your data inside pbix.
you can see the value using visualization though. or you can summarize all column in new table to see the value.
Thank you.
Hi vamshikrishna20,
What type of model is it? Are you using import mode, direct query, or direct lake?Direct lake does not preview data.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi vamshikrishna20 ,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Irwan & tayloramy for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hello vamshikrishna20,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hello vamshikrishna20,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
