Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Have you tried this?
SELECT * FROM etatspasserelles
WHERE Timestamp >= DATEADD(day,-30, getdate())
and Timestamp <= getdate()
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
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |