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...
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.
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.
@@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.
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.
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?
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?
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?
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.
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?
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?
Hey Parker, Thats amazing. Could you plz show us how to automate this.
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...
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.
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.
@@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.
@@HavensConsulting can you share the link of that video please?
Ah yes, I like that little workaround for small data tables. Abhay, here's the link: ua-cam.com/video/xuBfK0oJmw8/v-deo.html
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.
Hey mate, did you find any solution for the automation?
That's pretty awesome..... I assume you could use this to now work around the 48 daily refresh limit?
I believe so! I'll have to look into this to confirm though.
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.
Yes. Hi BI ELITE i also need this automatic process. Can you pls.. do a video on this ?
Did you find any way to automate this process?
@@vikramkukkadapu9761 Did you find any way to automate this process?
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?
Thank you. really helpful
That's great to hear!
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?
Hey Parker, could you also share the link for automating the xmla refresh in the description?
Thats awesome Parker ! Just got to know that Excel source has been removed from Power BI in the latest version !LOL!
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?
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.
great video, but where is the follow up, where you do the same with automated scripts?
Thanks! Can you please show how to automate with SQL Server Agent?
If I have other databases like AWS, snowflake, could I use XMLA to refresh data?
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.
Thanks...need to solve the world resource management issues
Haha agreed!
Amazing!
Thanks! Glad you liked it
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?
Hi..can you tell if we have sap bw as dasource,in that case how this will work?
Yes it will! This will work for any data source
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?
Need the automate how to video ASAP!
I'll get on it then ;)
@@BIElite also noticing that if the table has relationships, you need to do FULL instead of just Data
Soooooo.. how's it going ?
Hi, is the automation related video ready?? any conceptual idea if you can give that will be really handy.
@@MrPranavpatel72 still waiting here too
Hi sir, could you please help me get power bi remote job