Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello help needed.
I was wondering that my excel database formatted into percentage not reflecting in dataset.
For the month of Jan - April was correct output, but in May onwards it shows whole and rounded number.
when I trigger my refresh it shows:
In my Excel Database it shows 0.045
Then in my Data Query shows 0
I already applied the Data Type as Decimal Number in my PowerQuery Editor.
Hi @Anonymous ,
Have you checked the Data Type of this column after refreshing the data? Based on my test, all work normally.
Best Regards,
Tiege
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |