Forum Discussion
Changing Dashboard Data Source Dynamically
Hi v-yueyunzh-msft !
I see what you mean. I guess there is really no option to achieve the desired functionality using imported mode other than basically one report ( and hence dataset ) either per person or by customer which in both cases is way too many instances to take care of ( basically any change in the report would need to be manually replicated in every instance correct? ).
If I am to switch to direct query, do you ( or anyone that can help) know of any data source that can use this mode and is not strictly a database environment? Inputing data into a database is a lot more complex and would most certainly need of another set of transformations/cleaning of the data in order to do it, thus delaying the process.
Many thanks again!
Hi , AutoJL
Yes, for Power BI reports can only be bound to one dataset, not multiple datasets at the same time. If you change one report, you need to change the other reports at the same time. And the current way to modify the data source path under Power BI import mode is only parameter in my experience.
And for your needs, you want different developers to use different data, convert to DQ mode method, I think it is also necessary to maintain the corresponding permission relationship and create multiple datasets, which is not a good method.And Power BI Direct Query is only supported by a few data sources, unlike Import Data, which is supported by all sorts of data sources. A Direct Query connection to an Excel File is not possible. Direct Query mode is usually supported by data sources that are relational database models or have a modeling engine.
For more information, you can refer to :
Understanding Direct Query in Power BI for Beginners (powerbiconsulting.com)For different users to display different data in one dataset, the best way is to use RLS to manage:
Dynamic Row Level Security (Dynamic RLS) - Microsoft Fabric Community
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
And recently Power BI also provides a new way for developers to develop pbip, combining Power BI with Git, you can also check out this feature is all available to meet your needs：
Overview of Fabric git integration - Microsoft Fabric | Microsoft Learn
Manage a workspace with git. - Microsoft Fabric | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
