Thank you! It was a very well laid out video and I was able to easily find what my issue was about the online dataset failing. It was to skip the test.
RelativePath worked brilliantly - thanks. I was actually creating a Dataflow in BI service so that I could use the data on Desktop from a source that auto refreshed and maybe publish the report. In my case I didn't use a created function but had a custom column in which I copied a simple source Web.Contents(url for web page) line from the first step of a trial query. Relative path then allowed me to create a column of tables (one for each football team in my first column) using my [Team] column. Chris Webb is obviously brilliant but 95% of his posts go way over my head. I need people like you to pick out those ideas that are suited to me.
Amazingly well explained, thanks a lot! With your video I had the opportunity to fix my scheduled refresh problem and learn some stuffs in addition. Great video quality, I'm sharing it and your channel with my coworkers.
I have read Chris Webb's blog and plenty others with amazing info. This is the perfect compilation of issues AND explained clearly with great examples, thank you!!!!
EXACTLY what I needed! Only thing I needed to do was in transform data also update the credentials there to say public! Then I deleted the previous report I published and then it let me update the creds to public there also. Then...... I used Power Automate > Scheduled Refresh > Can refresh as often as you want with a Premiere license :) Thanks!
Hi. I'm working with API calls for Reverse Geocode. Do you have any idea how I can make it static with my data set in Google Sheet so I can use the Auto Refresh function?
is there are similar examples for reporting server (on prem)? I have relative path problem with schedued refresh but on reporting server. Datasource is file server.
Great video and awesome hints. Still doesn't work for me because Data source credentials are greyed out. Any idea how to fix it? I don't have to install a gateway, do I?
Hi Parker, can you help me with a similar issue? what about If I need to pass the RelativePath coming from an excel file on sharePoint? I've been trying to do it like that, I had to recreate a native table on PowerBI with date ranges and filters in order to apply them to the original web API because when I try to use the table sourced from sharepoint it works on Desktop but fails on PBI service, it says "Information about a data source is required.. The exception was raised by the IDbCommand interface" any suggestion to work around? thanks in advance I hope you can see the message.
I used RelativePath and now. Creds get saved for main URL, but I have two different creds for same main url. How can we manage using diffrent creds for diffrent file?
great explanation. I am trying to implement the solution in my case where we use tokens (there is no option to have a fixed token). Unfortunately no success so far. DO you think relativepath will work in my case too? Thx!
Great video. Thank you for sharing. I'm noticing though that the RelativePath method is adding a mysterious forward slash "/" in front of my text. I see only one post on the web about this as well, but no solution. Do you have any idea what's going on there?
nice trick it works almost perfect, maybe you shoud add the privacy level configuration if you have another type of sources like a file in a sharepoint
Hey Parker. Spot on content yet again! Have you managed to work out a solution for dynamic file paths for NON web contents? Same experience with the dynamic/static in the service but no options (I know of) to create dynamic (RelativePath) part!!
I did it but it is still showing error, My data is in Server Shared Location like \\server1\shared\BI, Is this asking Excel file password or Server shared location access password ?
Hi, Parker! You’re really crazy man! It’s great tool! Can you advice me, how can I realize this things. I want get information from public web site with goods and price, how I can create dynamic parameter based on refresh date? For example, I get date in 1pm and create fact table, in 2pm I again get date and adding it in my fact table. Sorry for English, and thanks for advice!
Great question, I’ve created a video on just this topic. th-cam.com/video/WgIhsF7kEjI/w-d-xo.html The idea is you can use power bi to query your web source, write the data to SQL, and then pull the data from SQL into Power BI. Hope this helps!
@@BIElite thanks a lot, I thought I watched all the videos on the channel, but it turns out I missed it. Thanks for the content, it turns out cool, don't quit. In my opinion, the best channel on power bi. I've been monitoring TH-cam since 2018 :)
I've watched this about 15 times and I love it, but I cannot seem to work out how to do this when I have to authorize the data with an API key. Any suggestions for the change in code?
I have a requirement where I need to call a python API/script from Power BI each time a filter is applied and need to send data to the API to perform some NLG. The python API/script will return a sentence or set of sentences which I need to display on the Power BI dashboard. Is this possible to achieve in Power BI and if yes, how do I proceed with it. Some additional details: For eg, if I have created a bar chart for employee details with a filter for salary received during a particular month, as soon as the filter changes, I want to call the API/script and send the data for that particular month and get back the NLG analysis from the API/script. I want to print something like "Employee E1 has received 1500/- salary during Jan2022". Here E1, 1500 & Jan2022 are dynamic.
Unfortunately the solution for web.contents does not work for me. Web.Contents is not accepted. Instead it's Web.Page(Web.Contents('...")) Which is "Open as Html page (Legacy)" However, I am still unable to access Data Source Credentials and Schedule the Refresh !!!
Thank you! It was a very well laid out video and I was able to easily find what my issue was about the online dataset failing. It was to skip the test.
RelativePath worked brilliantly - thanks.
I was actually creating a Dataflow in BI service so that I could use the data on Desktop from a source that auto refreshed and maybe publish the report. In my case I didn't use a created function but had a custom column in which I copied a simple source Web.Contents(url for web page) line from the first step of a trial query. Relative path then allowed me to create a column of tables (one for each football team in my first column) using my [Team] column.
Chris Webb is obviously brilliant but 95% of his posts go way over my head. I need people like you to pick out those ideas that are suited to me.
Amazingly well explained, thanks a lot!
With your video I had the opportunity to fix my scheduled refresh problem and learn some stuffs in addition.
Great video quality, I'm sharing it and your channel with my coworkers.
I have read Chris Webb's blog and plenty others with amazing info. This is the perfect compilation of issues AND explained clearly with great examples, thank you!!!!
Thank you! This video helped me to solve the problem which I couldn't solve for a long time
EXACTLY what I needed! Only thing I needed to do was in transform data also update the credentials there to say public! Then I deleted the previous report I published and then it let me update the creds to public there also. Then...... I used Power Automate > Scheduled Refresh > Can refresh as often as you want with a Premiere license :)
Thanks!
Thank you so much. Just saved my life, I was scratching my head trying to redo my whole code
Thanks so much for this, I have been having this problem for years and thought there was no solution
This is super awesome ! Thanks for sharing your learnings Parker ! Keep rocking & shining!
Thanks as always, Abhishek!
Thank you! I came across your channel by chance, clicked on a random video and actually learned sth. 🙂
Hi. I'm working with API calls for Reverse Geocode. Do you have any idea how I can make it static with my data set in Google Sheet so I can use the Auto Refresh function?
is there are similar examples for reporting server (on prem)? I have relative path problem with schedued refresh but on reporting server. Datasource is file server.
Very helpful as usual!
Thanks a lot for the video!
No problem, Jose!
Where are you pulling “pair” from? Is that defined in Dax somewhere? Where do you click on to make a space to define “pair”?
Thank you very much bro! Its the second time you saved me with this tutorial!
Great! How ro import data from GraphQL?
When I do this it works welll, but now it is asking for a Gateway, do we need to install a gateway for this to work properly?
Great video and awesome hints. Still doesn't work for me because Data source credentials are greyed out. Any idea how to fix it? I don't have to install a gateway, do I?
GOD BLESS YOU for the relative path trick !
Please help me the auto refresh is not working
Because the url is blob url.
Hi Parker, can you help me with a similar issue? what about If I need to pass the RelativePath coming from an excel file on sharePoint? I've been trying to do it like that, I had to recreate a native table on PowerBI with date ranges and filters in order to apply them to the original web API because when I try to use the table sourced from sharepoint it works on Desktop but fails on PBI service, it says "Information about a data source is required.. The exception was raised by the IDbCommand interface" any suggestion to work around? thanks in advance I hope you can see the message.
I used RelativePath and now. Creds get saved for main URL, but I have two different creds for same main url. How can we manage using diffrent creds for diffrent file?
hi, could you help us with Source = Csv.Document? thank you. raffalele
great explanation. I am trying to implement the solution in my case where we use tokens (there is no option to have a fixed token). Unfortunately no success so far. DO you think relativepath will work in my case too? Thx!
Great video. Thank you for sharing. I'm noticing though that the RelativePath method is adding a mysterious forward slash "/" in front of my text. I see only one post on the web about this as well, but no solution. Do you have any idea what's going on there?
Retiring a workaround over here! Very clever.
Hah that’s nice to hear!
Love your contents, helps a lot :)
nice trick it works almost perfect, maybe you shoud add the privacy level configuration if you have another type of sources like a file in a sharepoint
Hey Parker. Spot on content yet again!
Have you managed to work out a solution for dynamic file paths for NON web contents?
Same experience with the dynamic/static in the service but no options (I know of) to create dynamic (RelativePath) part!!
Ah very interesting. I’ll look into this!
I did it but it is still showing error, My data is in Server Shared Location like \\server1\shared\BI,
Is this asking Excel file password or Server shared location access password ?
Hi, Parker! You’re really crazy man! It’s great tool! Can you advice me, how can I realize this things.
I want get information from public web site with goods and price, how I can create dynamic parameter based on refresh date? For example, I get date in 1pm and create fact table, in 2pm I again get date and adding it in my fact table. Sorry for English, and thanks for advice!
Great question, I’ve created a video on just this topic. th-cam.com/video/WgIhsF7kEjI/w-d-xo.html
The idea is you can use power bi to query your web source, write the data to SQL, and then pull the data from SQL into Power BI. Hope this helps!
@@BIElite thanks a lot, I thought I watched all the videos on the channel, but it turns out I missed it. Thanks for the content, it turns out cool, don't quit. In my opinion, the best channel on power bi. I've been monitoring TH-cam since 2018 :)
You save me. Thanks for share
I've watched this about 15 times and I love it, but I cannot seem to work out how to do this when I have to authorize the data with an API key. Any suggestions for the change in code?
Hi did you get this working as I too need to pass two headers.
6:09 connection to the data source from PBI web service
7:37 without gateway!!!
I have a requirement where I need to call a python API/script from Power BI each time a filter is applied and need to send data to the API to perform some NLG.
The python API/script will return a sentence or set of sentences which I need to display on the Power BI dashboard.
Is this possible to achieve in Power BI and if yes, how do I proceed with it.
Some additional details: For eg, if I have created a bar chart for employee details with a filter for salary received during a particular month, as soon as the filter changes, I want to call the API/script and send the data for that particular month and get back the NLG analysis from the API/script.
I want to print something like "Employee E1 has received 1500/- salary during Jan2022". Here E1, 1500 & Jan2022 are dynamic.
THanks for the video! It saved my ass!!!
Thanks man! I was struggling with this for days now.
Unfortunately the solution for web.contents does not work for me.
Web.Contents is not accepted. Instead it's Web.Page(Web.Contents('..."))
Which is "Open as Html page (Legacy)"
However, I am still unable to access Data Source Credentials and Schedule the Refresh !!!
any suggestion on how to deal with Source = Json.Document(Web.Contents("bla,bla.bla"))?