Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
deniztopcu
Frequent Visitor

download in one query

Hi everyone,

 

Her_yıla_Ayrı_Sorguve_birleştirme.PNG

I have a query that downloads data for each symbol for a period.

---------------------------------------------------------------------------------------------------------

Tek_Sorguda_HerşeyPNG.PNG

I want a query where I can download multiple periods (ex. 2022-2018) in the same query. 

-------------------------------------------------------------------------------------------------------

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Hi @deniztopcu ,

 

I have simplified the queries. see the attached solution.

New Solution 

The challenge was the layout to get the rename part to work dynamically.

I create an input table and turn the transformation query to fx.

 

I hope it helps you and put you in the position for your priority matrix.

 

Regards

KT

View solution in original post

7 REPLIES 7
deniztopcu
Frequent Visitor

Hi @KT_Bsmart2gethe 

Thank you so much. You worked hard for this. I'm marking the thread as solved and will try to digest what you wrote.

best regards

The link below has the video I created that provides a similar concept.

Combine multiple file from input table 

KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @deniztopcu ,

 

Please see the below link for the solutions.

Solution 

I modified your existing query by recycling your Financial URL and the SYMBOL table.

Each step should be dynamic and not required to rename.

 

Let me know if that is what you're looking for.

 

Regards

KT

 

Hi @KT_Bsmart2gethe,

Thank you. It's a solution but that's not what I wanted.
The result part is quite complex and I think the manual query I have is easier.

I want to use the template I have and even convert my Template to matrix.

Hi @deniztopcu ,

 

Would you mind explaining a bit more about your desired outcome? (i.e. your end goal)

 

My understanding is:

1. You have a SYMBOL and URL list,

2. You scrubbing off the Balance Sheet from the web,

3. Up to the current step, we have the Balance Sheet. Are you saying that you want to use the template "Bos Bilanco" and turn it into a financial matrix (i.e. the working capital, liquidation ratio and such?)

 

Regards

KT

  • I updated my excel example. As in the example, I want to see the result that I have obtained by combining the simple "senexx" queries. your example is of course a solution but I will need to rearrange this data.
  • My first expectation is to get the following table in one query.
  • deniztopcu_0-1653976335966.png

    this is my priority.matrix will be my next mission

 

Regards

 

 

 

Hi @deniztopcu ,

 

I have simplified the queries. see the attached solution.

New Solution 

The challenge was the layout to get the rename part to work dynamically.

I create an input table and turn the transformation query to fx.

 

I hope it helps you and put you in the position for your priority matrix.

 

Regards

KT

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors