unable to join

[powerbiexpert22]

i am unable to join tables , getting error "preview is not available as shown below"

[Anonymous]

Hi @powerbiexpert22 ,

Have you tried clicking the refresh button to see if it works?

Another possible resaon is that if the data source is slow to respond, the preview may not display in time.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbiexpert22]

Hi @Ritaf1983 ,

where to check for below?, please share screenshot if possible

• Load Settings: Verify that the tables are set to load to the model and not only for preview in Power Query.

[Jihwan_Kim]

Hi,

I assume, is it direct query mode?

[powerbiexpert22]

yes , it is in direct query mode

[Ritaf1983]

Hi @powerbiexpert22 

It looks like your tables haven’t been fully loaded into the model, which is likely why you’re seeing the "preview is not available" message. I recommend checking the following:

• Data Source Connection: Ensure that your connection to the data source is active and stable. Sometimes connection issues can prevent tables from loading properly.
• Load Settings: Verify that the tables are set to load to the model and not only for preview in Power Query.
• Data Refresh: Try refreshing the data to see if that resolves the issue.
  If you continue to experience issues, please share more details about your data source and load settings, and we’ll try to help further.
  

  If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly