Video

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.

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

🥳

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. czcams.com/video/fKDqy0SxZLU/video.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

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)

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 czcams.com/video/fKDqy0SxZLU/video.html

ı need help

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

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

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 😀

Glad it was helpful!

😁 AI couldn’t handle my pronunciation

Hi! You can add this string into baseUrl: and created >="yyyy/MM/dd" AND created <="yyyy/MM/dd”. - replace all spaces with %20% - make sure it’s follows project, but is before limit in the base URL. Hope that helps!

Glad it helped!

Sure, I've added link to the video description!

@@introverted.manager thankyou ✨

Thank you! 😊

M approach is for cases when you’re unable to add additional extensions or cannot query DB (for on-prem) but still want to collect data, API on the other hand is *usually* freely accessible

Cau! 🙂

Could you share the exact error you’re getting?

Link is in the description of the video

@@introverted.manager Incredible that I did not see that ! Thanks

It has start/end of week fields or did you mean something else?

@@introverted.manager like an option to see 4/1/24-4/8/24 and so on for example , usually a drill down : year, month/year, week range,

You can add additional field for this using: Table.AddColumn(#”Previous Step name”, "Week Range", each Text.Combine( {DateTime.ToText([Start of the Week], "yyyy-MM-dd"), DateTime.ToText([End of the Week], "yyyy-MM-dd")}, "-"))

Thanks for watching! 😊

It should indeed