Forum Discussion

jharv9's avatar
jharv9
Frequent Visitor
9 years ago

Data not showing in Table preview

I'm having issue with a table that I'm pulling from SQL showing data. When I try to preview the data only the column headers show but if I go to Edit Queries the data header and data shows. Does anyo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

jharv9 I assume you are hitting close and apply in the query editor, what happens when you are on the data tab -> right click the table -> and "refresh data"? Does the data populate, or this just stays blank?

Are you mixing data sources in your PBIX? (Not that this should affect anything, just trying to figure out why it isn't presenting)

jharv9's avatar
jharv9
Frequent Visitor
9 years ago

When I try to refresh data

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    jharv9 See if this post helps out.

    Relevant post by Sreekanth

    "I am able to resolve the issue by adding the value in advanced options of edit queries as mentioned in below. Edit Query->Click on Source->Properties and in advanced options mention the value (number of minutes) it can wait to run the query. Please vote if it helps you ."

     

    I'm guessing your data set is large, and the timeout needs to be increased.