Forum Discussion
Data showing up in Excel but not Power Query Editor
I have an Excel spreadsheet that I am trying to reference in a PBIX file, but whenever I make any changes to the file, such as add a constant line to the graph or change the filtering, I can no longer see the data in the Power Query Editor. There is data in the Excel spreadsheet, but it does not show up in the Power Query Editor. I have referenced several posts, including this one, but nothing seems to be working. Both of the columns that are not showing up in the screenshots, in addition to the other columns that aren't showing up in the Power Query Editor, are formula-based in Excel.
I have tried refreshing the dataset in the desktop service, and that did not show the data. One of these screenshots is from the Excel spreadsheet which clearly has data, and the other one is from the Power Query Editor which is showing no data.
2 Replies
- v-eachen-msft
Community Support
Hi Anonymous ,
After my tests, I found a similar issue. Here is my test data in Excel.
After imporing, it will show blank values in Power BI.
When I open the Excel and refresh data in Power BI at the same time, it will show the value( different data type ).
You could refer to my solution, open Excel at first and refresh/import data in Power BI. It may be a bug.
- v-eachen-msft
Hi Anonymous ,
Has your problem been solved? Was my reply helpful to you? If the problem is resolved, you could accept the reply you like.
