Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dmoa24
Regular Visitor

Ayuda Informe BI franjas horarias

Buenas noches,

 

Pues quería que me ayudasen con un informe que quiero hacer sobre número de vuelos por franja horaria, fecha y TVs a través de columnas. y que sea continuo tanto en horas como en fechas. Hice algo muy simple ya que no domino la herramienta. También intento que los datos se acumulen en el informe y cada vez que inserto nuevas fechas el informe se actualice pero no pierda las fechas no coincidentes para así ir acumulando fechas.

Copio mi tabla excel por si me pueden ayudar. Muchas gracias de antemano.

 

Date0:001:002:003:004:005:006:007:008:009:0010:0011:0012:0013:0014:0015:0016:0017:0018:0019:0020:0021:0022:0023:00Total día
10/06/202400013192531272530293120192629272519261692439
11/06/2024101262031383131302629251927293028201915112471
12/06/2024001342125372728272932222424223122312514142465
13/06/2024001232122402528322834221824292726151918111446
14/06/2024000242231353127332634301924353723193315153498
15/06/2024001262430383229323128292929313732222813134520
16/06/202400036232439243226283328233232282822231814148
1 ACCEPTED SOLUTION

Hi @dmoa24 ,

 

Because your data source is excel, you can only connect through import mode. After you update the data, you need to refresh it manually, if you add data by day or week, you can try adding a scheduled refresh.Data refresh in Power BI - Power BI | Microsoft Learn

Of course, if your data source is of a different type, supporting direct query or live connection, you can refer to this link:Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

5 REPLIES 5
v-tianyich-msft
Community Support
Community Support

Hi @dmoa24 ,

 

I've done some of the most basic things that I hope will help you:

vtianyichmsft_0-1718348203462.png

vtianyichmsft_1-1718348220172.png

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Hola!!

 

Muchas gracias, esto es lo que buscaba. Si le añado fechas a el archivo de origen, se irá actualizando el informe automáticamente? Gracias. 

Hi @dmoa24 ,

 

Because your data source is excel, you can only connect through import mode. After you update the data, you need to refresh it manually, if you add data by day or week, you can try adding a scheduled refresh.Data refresh in Power BI - Power BI | Microsoft Learn

Of course, if your data source is of a different type, supporting direct query or live connection, you can refer to this link:Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Muchas gracias por su amable respuesta. Ahora sí lo tengo todo más claro. Que tengas un buen día.

lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.