Measures Table Blocking Queries. Cannot convert value "" to type Table.

[AmBigsPBI]

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]

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_]

AmBigsPBI,

Can you share the same screenshot, but after you click Source on the right?

[AmBigsPBI]

The source is blank. I used New Table under modeling in PBI desktop and then just added measures to in on the desktop. So in power query there wouldn't be any columns.

[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?)

[AmBigsPBI]

As I said, completely blank. I did not create the table in the power query as you are. I used the New Table button on the modeling tab in desktop as seen below. I left the formula blank and started adding measures to the table. I'm now guessing that this isn't the proper way to create a measures table and the column error is possibly due to it expecting a physical column.

[Wilson_ · Accepted solution]

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?)

[AmBigsPBI]

Well if it has never given you the error I am getting, I'd say that way is more right than my way. I will change to that. Thanks!