Import an Azure table with a date restriction

[Dylan_Lemasson]

Hi,

Is there a way to import an azure table with a date restriction ?

It's possible with a SQL database and I'd like to do something similar :

I just get a month of data in this case.

In azure, if I import a table I get this screen :

I have more than 5Go of data in this table and I'd like to only get the last month because it's not efficient and I don't want to download 5Go each time I modify a request.

I have a timestamp in this table I could use.

Is it possible to give some commands before downloading ?

Thanks,

Dylan

[mussaenda]

Have you tried this?

SELECT * FROM  etatspasserelles
WHERE Timestamp  >= DATEADD(day,-30, getdate()) 
and   Timestamp  <= getdate()

[Dylan_Lemasson]

Thanks for your reply.

I can't do SQL request since it's an azure table (I guess ?) and I don't know where to enter a command if possible.

Cordialement,

Dylan

[v-xicai]

Hi @Dylan_Lemasson ,

When you choose Azure SQL database connector to get the Azure data, you can expand the option "Advanced options" to enter into SQL statement.

Best Regards,

Amy

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

[Dylan_Lemasson]

Hello @v-xicai,

The SQL server example is what I'd like to do but I can't with an azure table source.

I juste have this panel :

And then :

I don't know where I can add some restriction to avoid loading the entire table.

Best regards,

Dylan Lemasson

[v-xicai]

Hi @Dylan_Lemasson ,

Your demand is a good idea, while it is not supported to implement in Power BI currently. You can post your new idea in Idea Forum , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Amy

Community Support Team _ Amy

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