Forum Discussion
Measures Table Blocking Queries. Cannot convert value "" to type Table.
Hello,
I made a measures table by making a table in the PBI desktop and then adding measures to it. This has worked fine in the past. A few nights ago this happened, and again this morning. It took forever to fix and I don't even know what I did. This is what it shows me in power query. I don't know why it would have a remove columns step for a table with just meaures, there are no columns. But I can't remove that step or the measure table goes away I think.
When I run my query this is what I get:
I have tried refreshing all queries in power query window, didn't help. Any idea?
AmBigsPBI,
Interesting. I don't know if this is the "right" way either but how I usually create my measure table is from the below, then deleting the single, empty column I created.
Maybe you find that less convoluted this way, maybe not. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
7 Replies
I figured out how I fixed it last time, which was to add a new column just to make the query have something new to load in rather than just refresh and then the error didn't occur. Not sure why that would help, and that isn't something I want to do every time this error happens. Any more info or advice on how to avoid this would be helpful.
Wilson_Memorable Member
AmBigsPBI,
Can you share the same screenshot, but after you click Source on the right?
- Wilson_
AmBigsPBI,
You're telling me the first step in your power query is exactly the below?
Source =I asked for a screenshot so we can avoid any ambiguity. If my above understanding is incorrect, please provide a screenshot instead of a written description. 🙂
If I am understanding correctly, even if you added new table under modeling in PBI desktop, the source should not be blank. The reason you are getting that error then is exactly because you're telling Power BI your source is "", which it is correctly telling you it cannot convert to a table. Did you edit the Advanced Editor and clear out what it had after "Source ="?
For example, if I create a new table like you said, like below...
... I still get this in the query editor:
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)