Forum Discussion
Cannot expand View in Power BI Power Query
What is the definition of your view? Is it simply SELECT * FROM <some single table> WHERE <you want to limit the data> ?
If so, you can do one of two things:
1) Use the original M script, but where it states Item = "VbaDocuments", simply substitute in your view name. Note that the view must have all the columns as the original table.
2) Assuming this is a SQL Server table, put in a filter condtion as the third step (before Expand). Check if your query is folded into SQL Server. Do this by right-clicking on the Applied Steps and selecting View Native Query. See if it wrote in a WHERE Clause for you.
This is probably because that the first expand step didn't reference the correct previous step by name. From your screenshot, it should be dbo_vw_VbaDocuments instead of Readiness_VbaDocuments.
In addition, if the expanded column is brought by the relationship, you need to ensure they still exist when you connecting to this view. You can remove the last two expand column steps, then try to expand the columns manually if they are just there. This won't bring the error.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
This is probably because that the first expand step didn't reference the correct previous step by name. From your screenshot, it should be dbo_vw_VbaDocuments instead of Readiness_VbaDocuments.
In addition, if the expanded column is brought by the relationship, you need to ensure they still exist when you connecting to this view. You can remove the last two expand column steps, then try to expand the columns manually if they are just there. This won't bring the error.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!