Refreshing a Single Table in a Power BI Dataset via XMLA Endpoint

No video

Refreshing a Single Table in a Power BI Dataset via XMLA Endpoint

Рет қаралды 12,445

BI Elite

Күн бұрын

Пікірлер: 45

@kostaszogo21 2 жыл бұрын

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...

@saurabhmundada7422 3 жыл бұрын

Hey Parker, Thats amazing. Could you plz show us how to automate this.

@abhishekstatus_7 3 жыл бұрын

Thats awesome Parker ! Just got to know that Excel source has been removed from Power BI in the latest version !LOL!

@robbief1 3 жыл бұрын

That's pretty awesome..... I assume you could use this to now work around the 48 daily refresh limit?

@BIElite 3 жыл бұрын

I believe so! I'll have to look into this to confirm though.

@kunalr_ai 3 жыл бұрын

Thanks...need to solve the world resource management issues

@BIElite 3 жыл бұрын

Haha agreed!

@samikshajain895 3 жыл бұрын

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.

@vikramkukkadapu9761 2 жыл бұрын

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?

@HavensConsulting 3 жыл бұрын

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.

@BIElite 3 жыл бұрын

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.

@HavensConsulting 3 жыл бұрын

@@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.

@abhayverma2585 3 жыл бұрын

@@HavensConsulting can you share the link of that video please?

@BIElite 3 жыл бұрын

Ah yes, I like that little workaround for small data tables. Abhay, here's the link: kzfaq.info/get/bejne/rttyma5h1LDRp2w.html

@juancarlosarayaportuguez6932 3 жыл бұрын

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?

@sanket91000 2 жыл бұрын

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?

@scottsampson399 9 ай бұрын

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.

@iambajpaisonam 2 жыл бұрын

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?

@roberttyler2861 3 жыл бұрын

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?

@BIElite 3 жыл бұрын

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.

@jeramzPC 2 жыл бұрын

Thank you. really helpful

@BIElite 2 жыл бұрын

That's great to hear!

@AvikMukherjee1984 2 жыл бұрын

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?

@aaronzw77 2 жыл бұрын

Thanks! Can you please show how to automate with SQL Server Agent?

@singhrakeshr 3 жыл бұрын

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?

@riazuddin7493 3 жыл бұрын

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?