Forum Discussion
Measures Table Blocking Queries. Cannot convert value "" to type Table.
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?)
Memorable MemberAmBigsPBI,
Can you share the same screenshot, but after you click Source on the right?
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?)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.