Forum Discussion
Query Editor contains data not in table data view (and more...)
Hi NotMyJob ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
I should have kept track of the steps, however the best I can say is that I removed the Applied Steps, Closed and Applied. Refresh Data tossed errors again. I Saved, Refreshed Data, and still the errors. I then closed PBI and re-opened it and Refreshed Data whereupon it did not toss errors, I manually checked the data calculations and it all is good.
Terribly frustrating on my part to have to close an application and re-open it for changes to work. I'm on the July 2022 version, so that should all be good as well... (Version: 2.107.841.0 64-bit (July 2022))
Thanks for the replies! Everything adds to the KB in this muddled head of mine 🙂
Hi NotMyJob ,
Please save the applied codes in Advanced Editor and delete the related query in Power Query Editor. Then connect to the data source again, and paste the codes for the left steps in Advanced Editor. Later check if the data can be loaded into model side and can be seen in data view...
Hello, thank you for checking in. I tried removing and importing new datasets, and for some reason that fixed the problem. I had tried refreshing and closing and opening the document, but neither of those worked, so I just re-imported the datasets and that fixed it. It was weird, but it is working now.
Data in Query Editor and Table View but not in Report
Update: without changing anything in the original pbix, it is working today. The ONLY thing that's different from yesterday on my side is that I rebooted my PC. I don't see, how this would make a difference, though.
If the above one is not working, could you please provide some fake data in the sheet "% Complete" and full applied steps in Advanced Editor in order to make troubleshooting and give you a suitable solution? By the way, the data source is the excel file from Sharpoint? Thank you.
Best Regards
This is suspected as being a network permissions issue as I'd escalated the problem and a week later PBI is behaving as expected. Or... I did something and it fixed the problem. Too many fires to keep track of how it all worked out, unfortunately.
Thank you for the replies and suggestions!
Hi NotMyJob ,
It's glad to hear that it works. And thanks for your feedback and sharing the problem situation. Could you please mark your post as Answered? Thank you.
Best Regards