Forum Discussion

Dylan_Lemasson's avatar
Dylan_Lemasson
Frequent Visitor
6 years ago

Import an Azure table with a date restriction

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.   ...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

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's avatar
Dylan_Lemasson
Frequent Visitor
6 years ago

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's avatar
    v-xicai
    Community Support
    6 years ago

    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.