The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello,
I am starting my work with power bi, and first issue i had met is that not all data from dataset is being displayed.
I had imported data from table, choosing import in connection settings.
As a result i had get all data from DB:
then i had created simple report only with table in it. But whatever columns i would choose there are only some rows being displayed:
As i understand the data should not depend on selected columns.
I had of course refreshed data from data set, checked if any filters are active, checked after rightclick display all data, and so on.
Thanks in advance.
Solved! Go to Solution.
Your "Id" column is possibly being summarized on the table. Try clicking the dropdown on the Id field in the Values section of the table and select "Don't summarize".
In desktop as you can see in Power Query Editor all the data is there.
But when I close it and go to table view the percent column is blank. I can create visuals and the data shows up, but why won't it show in table view?
It only does it with this one dashboard. I have tried recreating in a new Power BI, it does the same thing.
Your "Id" column is possibly being summarized on the table. Try clicking the dropdown on the Id field in the Values section of the table and select "Don't summarize".
Thank you very much for help, i think i had tried this, but it needs to be checked on all columns. Now it works.
User | Count |
---|---|
56 | |
54 | |
54 | |
49 | |
30 |
User | Count |
---|---|
173 | |
89 | |
70 | |
46 | |
45 |