cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chef40
New Member

Trying to understand Power BI so I can help a colleague

Hello,

 

I'd be very gratful for any general comments/help with a scario I'm trying to assist with. I have good (old) working knowledge of access and a good understanding of 'IT'. I have a colleague that is runnning power BI and in order for me to help, I need to update my information.

The user is running Power BI on 365 online given Mac usage and the situation is as follows:

1. Power query is used on a separate desktop PC (it's not available on a Mac)

2. Power Automate is used to update the reporting when new entries are made in the database using the 365 online license

3. There are some challenges around particular field issues e.g. two key (mandatory) fields (date and location) are required each time an entry is made to the db, however it is desireable for the previous entry to be retained to facilitate more rapid data entry when multiple entries are to be submitted with no change in this information

 

I'd really love to understand the following:

1. Do you need Power Query to do reporting with Power BI? How does Power Query actually help in this scenario given the desktop PC is not always on? Is the query somehow uplodaed to the online instance?

2. Why would Power Automate need to update the reporting - is this not possible to build into the Power BI instance?

3. Any thoughts on how to retain data for key fields to facilitate multiple data entries?

 

Or any other general information/direction to helpful materials?

 

Thanks very much.

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Chef40 Power Query is the data ingest and transformation engine for Power BI. So, you use Power Query to connect to source systems, transform the data if necessary and import the data into the model. You then generally need to create relationships between tables if you have multiple tables in Power BI Desktop.

 

You do not need Power Automate to update the report. In fact, that's a bit of an odd way of doing it. Generally you just schedule a refresh in the Power BI Service once the data model is published.

 

Not sure what you mean by 3 but if you are talking about reporting on historical values. That is done via Goals.

 

Would need to better understand how you are licensing Power BI to know what your options are.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

Thank you very much for your help. I think I need to play with this to actually understand what is going on. My understanding of what they're doing is using Power Query to develop the basis for the reporting but I don't understand why this can't just be done in Power BI. It doesn't make sense to me that that aspect of it would be done 'offline' (on a desktop PC) when the reports are avalable online in the 365 live environment.

Also thanks - I don't understand why Power Automate is necessary in principle but I really need them to map me a workflow if I'm to see where it fits.

 

The final point - I'm sorry, I haven't explained very well. It's nothing to do with reporting, it's data entry. When the user uses the online interface, a new entry is made by completing a number of fields, two of which are key (mandatory) fields. I think it was something like date and location. Because there could be any number of entries for the same date and location, it would be advantageous if the previously enetred information was retained once the 'submit' button was pressed for an entry to save repitition. Currently, all fields are reset for the next entry once one has been submitted.

 

Thank you very much!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors
Top Kudoed Authors