Forum Discussion
Load data in table created from a list
Hi Anonymous
If I understand I would to the following. Please be aware tha in my smaple I have no flag column so you habe to do the filter in step two which you do not see in my screenshots.
1) Create a separate query by referencing to your orignial one
2) in the new query filter the data by the flag column, then remove all the other columns and the remove the duplicates
the you should have the table in a seperate query which you can re-use
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 your message. All the steps are good so far. But my problem now is to be able to connect to a cube in order to load more data.
Not sure if I'm right, but if I have the Table icon in the top left corner of my Table, I cannot load more data from a Cube. If I have the Cube icon, I can.
vs
Is there a way to load data from the cube anyway ?
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..