Help me do a Power Query in Power BI
Budget: $10 – $30 CAD
Hello,
I am beginner in Power BI and i have an issue doing what i would like.
Table 1 (main table)
Data 1 , Data2, Data3 Data5
Table 2 (equivalent table)
Data 1, Data 4
So i have my main source of data comming from a Webpage then i have a static table with some values to look up (data 4), i succeded using DAX to get the right Data 4 in table 1 so i can create the following url for each line: https://myurl.com/data4/data1
What i would like to do is to add another collumn with the text output from this URL. I tried opening the query and using the formula WEB.CONTENTS but i think i cant because my URL collumn was made by DAX?
So i would need your help to build in power query the same functions i made in DAX or import those collumn in power query. Then i would need your help to test if WEB.CONTENTS is really the good function for my needs.
Thank you,
I am beginner in Power BI and i have an issue doing what i would like.
Table 1 (main table)
Data 1 , Data2, Data3 Data5
Table 2 (equivalent table)
Data 1, Data 4
So i have my main source of data comming from a Webpage then i have a static table with some values to look up (data 4), i succeded using DAX to get the right Data 4 in table 1 so i can create the following url for each line: https://myurl.com/data4/data1
What i would like to do is to add another collumn with the text output from this URL. I tried opening the query and using the formula WEB.CONTENTS but i think i cant because my URL collumn was made by DAX?
So i would need your help to build in power query the same functions i made in DAX or import those collumn in power query. Then i would need your help to test if WEB.CONTENTS is really the good function for my needs.
Thank you,