Forum Discussion

JanKolo's avatar
JanKolo
Frequent Visitor
10 years ago

Records not visible in table visualization

hi,   I'm reading data directly from SQL Server 2012 into a table visualization. In total there's around 340000 records. The problem I'm having is that not all of the data is visible, although it i...
Need Help
Vicky_Song's avatar
Vicky_Song
Impactful Individual
10 years ago

JanKolo, I tried but failed to reproduce your issue. How about you scroll down the scrollbar? More data is loaded when I scroll down the scrollbar. If you always have this problem, it is better if you can show me one sample PBIX file. BTW, what is the version number of your Power BI Desktop?

JanKolo's avatar
JanKolo
Frequent Visitor
10 years ago

hi Vicky_Song,

thanks for taking a look. I still have the same issue and I'm happy to share the pbix file however, I wouldn't want to upload it publically here. Can I send it by private message, or email to you?

 

 

Just to show on screenshots. As you can see I have a table, where the records count up to ca 340k and I want to apply filters to actually show only 300-900 records.

However, after applying the first filter on the RegionCode (= MRK), what should already limit me to 995 records, I get an empty table:

 

  • Vicky_Song's avatar
    Vicky_Song
    Impactful Individual
    10 years ago

    JanKolo, it is better if you can provide me one pbix file with which I can check what's wrong with your report file. You can send it via email (visong at microsoft dot com).

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi All

       

      I am getting the same issue,for SQL tables not visible in Power BI Navigator. 

      SQL TablesPower BI Navigator

      I am considering two tables from SQL ,the tables names are KRONUS UK Ltd_$Customer and KRONUS UK Ltd_$Cust_ Ledger Entry. I am trying to Get Data from Power BI for Desktop and on Power BI Navigator i can't see the first table while the second table is visible two times. I am attaching the SQL and Power Bi Navigator both to make it more clear.