Forum Discussion
AdministratorUpload dynamically named table data to Power BI dashboard
Best regards...
I have a database in which every day, a table is automatically generated that is named that day, for example 220801, I want to know how I can do so that my dashboard in power Bi, read that table automatically.
In the same order of ideas, I must filter the data in those tables by date.
I remain attentive, if anyone can help me.
3 Replies
- lbendlin
Super User
Dynamic data sources usually cannot be updated in the Power BI Service. You need to hide that fact (of the table name changes) from Power Query, either via a function, a parameter, or a view.
What should happen if the expected table isn't there?
Syndicate_AdminGood night...
The filter must be a range of dates, what is wanted is that the table that bears the name of the day is loaded daily, which would be part of the date filter. But this is the date in the search means that it does not exixte that table.
I don't know if I make myself understood?...
In the same order of ideas, do you suggest that you have a control in the view that allows you to load the table of that day?
- lbendlin
Yes, in SQL you can run scripts like EXISTS that can figure out which table to link to the view.
