cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yacatac Frequent Visitor
Frequent Visitor

Relationship table preview blank

I am trying to create a relationship between two tables, however the CPC table preview is blank, which concerns me because the table is populated in Query.

 

It is a DirectQuery table to SQL.

 

Any ideas on whether this is an issue or the impact - if so, how to resolve?

 

Blank table preview relationship.jpg

4 REPLIES 4
yacatac Frequent Visitor
Frequent Visitor

Re: Relationship table preview blank

Bump

Ross73312 Super Contributor
Super Contributor

Re: Relationship table preview blank

First thing you'll want to check is that the blank table actually contains data.  Create a simple visual that only cares about that single table and see if you get data appearing.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Community Support Team
Community Support Team

Re: Relationship table preview blank

HI @yacatac,

 

I can't reproduce this, can you please share more details?

How to Get Your Question Answered Quickly

 

In addition, if you switch to import mode or test with other data table, did this issue appears?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
DirkFrazier Frequent Visitor
Frequent Visitor

Re: Relationship table preview blank

I'm having this same problem. Dynamic Query accessible table, with data (I made a visual) but the relationship preview for that table is empty. When I select the related columns and click OK, Power BI Desktop locks up completely. I have to kill the task in Task Manager to continue. 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 58 members 1,117 guests
Please welcome our newest community members: