Forum Discussion
Load data in table created from a list
Hi Anonymous
1) what you see in Power Query is only a preview of the data so when you implement the logic and you click on close and apply all the data from the data source wille be loaded so that you can see the data in the data model and data view in Power BI Desktop
2) So when you work with cubs as a data source you typicall hav to expand the data to get all of it in detail. in Power Query. Unfortunately I have no cube on my side to show it to you but there are way by clicking or by specific Power Query formulas to expand the data of a cube to the lowest level and by that to get all data which is available from the data source.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi Mikelytics,
thank you for the answer. But I'm not sure we are talking about the same thing.
Let me take an example to illustrate my problem.
I have a date table with a date column containing all the dates from 01/01/2020 till 31/12/2023.
The next column is the Year column with only the years.
Let's forget about the filtering on years.
What I want to do now, is take all distinct years and create a new table with it.
Then, I want to connect to a table in a cube and load all the rows where years match.
I hope my example is understandable.
Maybe I'm taking the problem upside down..