Видео

Omg! Thank you so much!! 😊

@@introverted.manager thank you for the good video, I have a question thou, do health apps need an organization account? and duns number?

Thank you for the feedback! Make sure to check out video about RelativePath, which continues this one.

If I understood correctly, RelativePath function in M might help with that. I have video about it.

@@introverted.manager thank you for the recommendation. I was already using relative path, I just couldn't figure out why calling the next cursor wasn't working. Turns out the API is broken 🙃 Not all bad news though, it lead me to your channel that has some great info on it.

Glad you were able to narrow it down 😉

Thank you for watching 🤗

Indeed! ❤️

I usually use official dev api reference and go from there: shopify.dev/docs/api/admin-rest

@@introverted.manager Thaank you

Let’s say you want last 30 days: In Calculate filters you can specify ‘day offset’ <= 30. That easy.

​@@introverted.manager can you please share this file or code please it's so interesting and useful. I makes the dashboard looks so interesting

Plan to publish it today or tomorrow, will post here once I do

@@introverted.manager Can u share the file please

🥳

Good point, will do

@@introverted.manager Thanks. I'm working through your example, as I am producing a horizontal timeline covering multiple projects. This helped a lot.

Could that be that your admins disabled api access? Have you tried accessing api outside power bi?

Hopefully in a good way 😇

@@introverted.manager definitely! ^^. Would you be willing to share the theme file?

Impressive! But one question, when publishing to the Power BI service, will it be presented in the same way?

It will still show up in Service, yes

Will do on my blog, and share link here once I do.

That usually a sign that you reference some missing step in your M code. Each new step references previous step it relies on - look for this.

You are welcome!

For this please watch my newer video - “Fixing Dynamic Source refresh error”. It specifically addresses refresh in Power BI Service. ruclips.net/video/fKDqy0SxZLU/видео.htmlsi=ZgBbykZVYlz743T9

@@introverted.manager thanks a ton you are awesome

Unfortunately I couldn't figure out how to make that work.. missing something in between it would be helpful if you can share pbix file and if you are ok with it

PBIX is shared on my blog: www.maxanatsko.com/blog

Hi, Hasn’t occurred to me ever, unless those are custom fields - those might require more tailored approach to api calls.

Hopefully if we get the file sometime around this week would be a great help

Apologies, I had other commitments and didn’t have time for the channel. However, I published files for previous videos on my website - you can find it here www.maxanatsko.com/blog (it’s behind password, received in email).

Apologies, I had other commitments and didn’t have time for the channel. However, I published files for previous videos on my website - you can find it here www.maxanatsko.com/blog (it’s behind password, received in email). Hope that helps.

@@introverted.manager thank you so much it worked

Happy to help!

I'm glad!

Sure, in a few days. I’ll leave comment here when I do

@@introverted.manager that would be a great help…Thanks in advance

I'm stuck too if you are ok with it please share the pbix file, Thanks a ton!

@@introverted.manager Please share the pbix file we are still stuck and it's been 2 weeks we have been waiting for it. Would really appreciate if you could help everyone out here.

Apologies, I had other commitments. I have published PBIX in my blog: www.maxanatsko.com/blog - it’s hidden behind password, which you receive in email, along with files for all other videos.

PowerQuery is the same, I believe. So yes, you should be able to

Were you able to use it for Excel? I'm trying to do the same thing. Having to use the jira addin in different tabs is tedious 🫠

@@XLForAnyone Yes I could use it with little modifications

Could you elaborate for which part?

You can specify multiple project via , if needed. If that isn’t sufficient - yes, you can change it to any other JQL.

I published files for previous videos on my website - you can find it here www.maxanatsko.com/blog (it’s behind password, received in email).

Contact them. I called them via the help center there and they unlocked it immediately. This often happens when the credit card that you‘ve paid with isn‘t connected with Apple Pay.

Thank you! 😊

Thanks! I use Adobe Premiere Pro

You can, however it requires using CMD: TabularEditor.exe yourServer yourDB -A > bparesults.txt.

Eg. TabularEditor.exe localhost MyReport -A > bparesults.txt

You can download source file (in the video description) and open it in Power BI Desktop to review. Make sure to change api key and URL in the parameters (click Transform data to get there).

@@introverted.manager where we must change the API KEY please ?

There is parameter called API Key, in Transform Data (power query)

@@introverted.manager I just downloaded the files but there is no such parameter. I'm currently struggle with the authentification as PowerBI is not asking me for any auth info, when I run the script.

Any details on why?

@@introverted.manager I write a debit or credit card, but I get an error that the payment is not approved. I talked to the bank and they don't know anything about it.

I would have to agree with Inna’s comment. In its current state this M script isn’t production ready, as Power BI service applies a lot of limitations to dynamic scripts. Consider this video as an educational about M capabilities and working with APIs, applicable for ad-hoc analysis. If you have opportunity to use custom connector, go with the connector - that would be easier.

@@introverted.manager I found a solution to the problem with publishing. Modify the query based on the article "Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code" by Chris Webb and article "Dynamic Web.Contents() and Power BI Refresh Errors" by Stacia Varga

Yes, I made video about this recently too - Fix 'Dynamic Data Source' Refresh Errors in Power BI Service with RelativePath ruclips.net/video/fKDqy0SxZLU/видео.html

ı need help

This seem like something that should be reported to Apple Support, have you tried them?

Don’t bother lol - they cant do anything- buy an account instead

It supposed to get all worklogs. Is it not working for you?

What seems to be the problem in your case?

You have to add token in api key parameter within Power BI in Power Query

Were you able to fix this? I'm having the same issue. I don't get a request from PBI to provide my API token when I run the script and I'm struggling to include it in the header manually.

@@p337awesome I ran into this same issue and was able to resolve it. Most likely you have already connected to the data source and supplied the API Key in the Header tag or some other method. (At least that was what I had done in my case.) On the Home Ribbon, click "Data source settings", then edit the data source that you are connecting to using Basic, username and API key as the password, just as shown in the video at 13:38 mark. You may need to select "Global permissions" option in the "Data source settings" dialog if you do not see your data source. Once I did that, everything worked. Hope this helps in your case.

@@RichardTeelSys thank you Richard! I managed to include the API token in the header in the meantime - it was just like you explained 👍🏻

Hi, this is indeed the case - there are lots of limitations imposed on refreshes in the service. There are certain workaround, let me have a look whenever I get time.

Thanks for watching!

Thank you so much 😀