Forum Discussion
Change the table source automatically in powerBI
Hi, Bromik
It is the same in PBI Service and does not support dynamic changes to the data source. If there is a lot of data, you can try to use Direct Query or Live Connection connection method, if it still does not meet your needs, you can use Fabric Lakehouse/Warehouse in Service, which provides a better data experience.
The Difference Between Power BI Connection Types (popautomation.com)
What is Microsoft Fabric - Microsoft Fabric | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Bromik So, not really going to work that way. Instead, import all three files and add a column for the file name. Append them together as one big table. Use the file name column in your slicer.
I have different columns in my files, So i cannot append tme. Can it be possible to download different files based on the user choice and based on the file downloaded change the visuals and the dashboard?
Hi, Bromik
Thanks for Greg_Deckler's reply. Unfortunately, the current version of PBI Desktop doesn't support the functionality you're looking for, and visual objects are only affected after the data is loaded into the Semantic model.You can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thanks for the comment.
If I do it in Power BI Service, can it be possible there?
I want to automate this process of choosing the dataset that should be used for the charts but I have a lot of tables. I am afraid it is not optimize way to upload all of them into power BI, right?Hi, Bromik
It is the same in PBI Service and does not support dynamic changes to the data source. If there is a lot of data, you can try to use Direct Query or Live Connection connection method, if it still does not meet your needs, you can use Fabric Lakehouse/Warehouse in Service, which provides a better data experience.
The Difference Between Power BI Connection Types (popautomation.com)
What is Microsoft Fabric - Microsoft Fabric | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum