Forum Discussion
Connecting multiple different dynamic data sources in PBI
Hi, TheScrub
Power BI supports mixed data sources (Import/DirectQuery), Live Connection mode usually only supports connecting to a single data source, if there is data from multiple sources consider not using Live Connection connection mode, this is by design.
Related link:
Solved: Live Connection with multiple data source - Microsoft Fabric Community
Best Regards,
Yang
Community Support Team
If 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
And how could I solve my problem of storing 8 Excel files, 1 database cube, 1 Jira project? Probably via DirectQuery? Does that mean that I should create everything in an Excel file, for example, with separate worksheets, create a query for all the original sources and then connect this prepared Excel file to PBI? Then I always have to update the Excel data source and then update the PBI so that the latest data is available? Can this be automated? And is this even the best possible solution? I could query the cube and the individual files in an Excel file if that is the best option. But I don't know if this works dynamically with JIRA. Can JIRA tickets be displayed dynamically in Excel so that they are also connected to PBI? TY very much!