Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello, I'm trying to connect a power bi report to two different data sources. Those are a dataset in power bi data hub and an excel sheet containing a lookup table.
The reason I don't add the excel table to the dataset is because the dataset is connected to a sql database and must refresh daily. I tried adding it to the dataset but now the daily refresh fails. Thus I want to add the exccel table to the report seperately. Is this possible?
Thanks in advance.
Solved! Go to Solution.
Hi @314mp_M0th4 ,
As far as I know, everytime Power BI will refresh the data from all data source instead of only specific data souce. If you add data from multiple data source, you need to configure all credential correctly. Or the refresh will fail.
Please make sure you configure the credential of excel data source correctly. I think you need to configure the credential for Gateway.
For referencre: https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @314mp_M0th4 ,
As far as I know, everytime Power BI will refresh the data from all data source instead of only specific data souce. If you add data from multiple data source, you need to configure all credential correctly. Or the refresh will fail.
Please make sure you configure the credential of excel data source correctly. I think you need to configure the credential for Gateway.
For referencre: https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!