Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |