Great video as always Parker!!! But you know, people are greedy. We need the automate version of the process! We count on you in order to look good on our bosses...
@saurabhmundada74223 жыл бұрын
Hey Parker, Thats amazing. Could you plz show us how to automate this.
@abhishekstatus_73 жыл бұрын
Thats awesome Parker ! Just got to know that Excel source has been removed from Power BI in the latest version !LOL!
@robbief13 жыл бұрын
That's pretty awesome..... I assume you could use this to now work around the 48 daily refresh limit?
@BIElite3 жыл бұрын
I believe so! I'll have to look into this to confirm though.
@kunalr_ai3 жыл бұрын
Thanks...need to solve the world resource management issues
@BIElite3 жыл бұрын
Haha agreed!
@samikshajain8953 жыл бұрын
Hi, This video helps alot however is there any video to automate it? because this still seems to be a manual way to refresh a table.
@vikramkukkadapu97612 жыл бұрын
Yes. Hi BI ELITE i also need this automatic process. Can you pls.. do a video on this ?
@garvitkumar3013 Жыл бұрын
Did you find any way to automate this process?
@garvitkumar3013 Жыл бұрын
@@vikramkukkadapu9761 Did you find any way to automate this process?
@HavensConsulting3 жыл бұрын
Hey Parker, great video showing XMLA endpoints! To get the report to refresh in the service could you not also disable the "Include in Refresh" option for the local query in the query editor? Then the scheduled refresh in the service should run successfully.
@BIElite3 жыл бұрын
Hi Reid, unless that’s changed in the last few months, that doesn’t work unfortunately. While you can uncheck “include in refresh” locally, it doesn’t affect the refresh process in Power BI Service.
@HavensConsulting3 жыл бұрын
@@BIElite ah you're right! The one other work around was a video you did as well, where you converted a local table into a json table embedded directly into the PBIX file.
@abhayverma25853 жыл бұрын
@@HavensConsulting can you share the link of that video please?
@BIElite3 жыл бұрын
Ah yes, I like that little workaround for small data tables. Abhay, here's the link: kzfaq.info/get/bejne/rttyma5h1LDRp2w.html
@juancarlosarayaportuguez69323 жыл бұрын
Hey Parker, big fun of your videos, it would be super helpful if you can publish on how to automate the process, I tried SSIS but it seems that I can't connect to the Service analysis using the same method I use for another cube data sources.
@garvitkumar3013 Жыл бұрын
Hey mate, did you find any solution for the automation?
@EMB3D Жыл бұрын
great video, but where is the follow up, where you do the same with automated scripts?
@sanket910002 жыл бұрын
Great video, one quick question: I am trying to schedule automated refresh from SSMS of one table from my dataset. Can you create a video or share some data related to it?
@scottsampson3999 ай бұрын
Can you process running as a Service Principal? I have not been able to get this to work but don't want to run this as a human user id.
@iambajpaisonam2 жыл бұрын
Hey Parker, could you also share the link for automating the xmla refresh in the description?
@feng3625 Жыл бұрын
If I have other databases like AWS, snowflake, could I use XMLA to refresh data?
@roberttyler28613 жыл бұрын
I've heard alot about XMLA endpoints so intrigued to see what else it can be used for in practical examples. Thanks ! Potentially a bad question, could you not just right click the specific table and not refresh it?
@BIElite3 жыл бұрын
Very good question, Robert. And I meant to explain this in the video... when you right click the table and select Refresh, it simply refreshes the metadata within your SSMS instance. For example, if someone published a new version of the dataset with new columns, you would need to “refresh” your connection either to the individual tables or more practically by refreshing your entire database connection. It would then show you the new columns the other user added, but would not refresh the data within the dataset as we demo’d in this video.
@jeramzPC2 жыл бұрын
Thank you. really helpful
@BIElite2 жыл бұрын
That's great to hear!
@AvikMukherjee19842 жыл бұрын
Hi there just wondering if you indeed manage to come up with the next video you mentioned here about automating this script execution via SQL job or so?
@aaronzw772 жыл бұрын
Thanks! Can you please show how to automate with SQL Server Agent?
@singhrakeshr3 жыл бұрын
For the refresh datetime, is there a way to set the order of refresh tables? So that the getdate query runs after rest of the queries are completed, giving an accurate refresh time instead of 'start' of refresh time?
@riazuddin74933 жыл бұрын
I have created a report and in this report there are two visuals i.e. Exits by Grade and Exits and Turnover by Department. The former visual displays the grade wise number of leavers whereas the latter displays the data related to number of leavers and turnover percentage. If I select a articular grade in Exits by Grade then the visuals of Exits and Turnover by Department displays data correctly related to 1. Overall Turnover percentage of departments. 2. Highlighted Turnover percentage of the particular grade which was selected from the previous visuals for a particular department. 3. The total number of leavers of the department. But I also want to see 4. The total number of leavers in selected grade for the particular department. How can I achieve this?
@tigsik31283 жыл бұрын
Amazing!
@BIElite3 жыл бұрын
Thanks! Glad you liked it
@paragkhandalkar3 жыл бұрын
Hi..can you tell if we have sap bw as dasource,in that case how this will work?
@BIElite3 жыл бұрын
Yes it will! This will work for any data source
@godude69503 жыл бұрын
Need the automate how to video ASAP!
@BIElite3 жыл бұрын
I'll get on it then ;)
@godude69503 жыл бұрын
@@BIElite also noticing that if the table has relationships, you need to do FULL instead of just Data
@godude69503 жыл бұрын
Soooooo.. how's it going ?
@MrPranavpatel723 жыл бұрын
Hi, is the automation related video ready?? any conceptual idea if you can give that will be really handy.
@godude69503 жыл бұрын
@@MrPranavpatel72 still waiting here too
@MohdMoin-uw1ng3 жыл бұрын
Hi sir, could you please help me get power bi remote job