Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
This has to be simple. I have a cell value with the string "TBD" in a simple two column Table in an excel file stored locally. Strings are formatted as "general" in Excel. I import into Power BI Service as a data set (Get Files / Local Files/ Import) and do a simple table visualisation for the two columns. Here is my data in Excel:
Here is my data in Power BI Service Table visualisation.
TBD and N/A are being replaced with blanks... remember these are NOT the result of formulas in Excel - they are hard coded strings.... Appreciate any suggestions.
Sample result in other visualisation too (TBD and N/A being considered blank).
"Show items with no data" does not seem to make a difference
Gerard
@Anonymous,
I can reproduce your issue in Power BI Service. I will report this issue internally and post back once I get any updates.
In addition, you can use Power BI Desktop to connect to the Excel file, then create reports in Power BI Desktop and publish reports to Power BI Service, everything works well and table visual shows value as expected in this case.
Regards,
Lydia
@v-yuezhe-msftThanks for confirming, I thought I was losing my mind There could be other textual instances that dont work, I just stumbled across two (TBD and NA).
Can you give me a sense when this might get fixed? Are we talking days/weeks/months?
I dont use Power BI Desktop, so I will probably wait for a fix to Service and work around this issue in the interim. Appreciate if you could update this thread when a fix is available.
Thanks again for confirming the issue.
Regards
Ger
@Anonymous
The fix may not comes very soon. No ETA is possible today.
As a workaround, please load the Excel file into a PBIX file and publish the PBIX file.
Best Regards,
Herbert
@Anonymous,
The team is investigating this issue. Once I get any updates about this issue, I will post back.
Regards,
Lydia
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
51 | |
35 | |
29 | |
14 | |
12 |