Connecting A Power BI Dashboard to Excel

[Stacker]

I have been able to connect data to excel using publically available APIs and Power Query. Stuff like data from this page and an API like the equivalent downloads for UTLA API. I get data from a Power BI dashboard but they don't have a publically available API like the data above but copying the link fails. I emailed them and they said:

We are pleased to announce Microsoft APIs, Build Permissions and XLMA Endpoints will available for use with the Portal. Please note this is being released as an unsupported functionality, due to us being unable to provide technical support for the implementation of any of the options below locally.

I have excel, power BI and power automate on my PC and what I want to do is:

1) update files by deleting previous data and updating new ones

2) Download daily files and save it using a preset template where only the date is changed and saved to a certain network drive

3) Download some files, filter and paste to new tabs


These three things will be stuff i concern myself with later, for now I just wanna learn how to connect the data to excel, save and automate it.

 

[man239]

Hey did you ever receive a response or did you figure out the answers to your questions? I have the same questions myself and was hoping to find some answers. I use a BI site that automatically pulls the data I need for a schedule, but I'm looking to use that data in an excel sheet that I have created to simplify the data and share with my team.

 

[Stacker]

How to connect to your Power BI Premium Datasets using Excel (with the XMLA End Points) - FourMoo | Power BI | Data Analytics

This blog post details how to connect to Power BI Premium datasets using Excel. This allows users to directly connect to the Power BI Premium dataset.

www.fourmoo.com

This was the closest. It didn't turn out how i imagined..

 

[man239]

Hmm I'll have to give this a shot, appreciate the link! What issue did you have with it?

 

[Stacker]

When i connected the data I would have to build the dashboard manually. I thought when i connected the data to excel it would be identical to how it looks in the dashboard but alas..

 

[man239]

Ah I see, at least you got the data connected, that's further than I was able to get. Have you thought about creating a macro to autoformat your dashboard?

 

[Stacker]

I did but people didn't respond to my thread haha