Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have created reports using Sql Server which is in Client Environment. Our clients will use Excel add-in file as a source to create reports.So naturally after selecting the particular fields in excel add in file we will get sql query in the end, We will use the sql query and create reports.
So how can we create PowerBI reports with Live data?
Please suggest
Thanks in advance!
Solved! Go to Solution.
HI @Yasmin1,
If you mean get live data from sql server, I'd like to suggest you direct use power bi sql connector to get data. It support import and directquery mode to get data.
If you mean excel workbook contents, you can use import feature to direct load excel workbook contents to power bi.
Import Excel workbooks into Power BI Desktop
BTW, if your data is from third party excel add-in, I don't think it is possible to load live data on service side through that add-in.
Regards,
Xiaoxin Sheng
HI @Yasmin1,
If you mean get live data from sql server, I'd like to suggest you direct use power bi sql connector to get data. It support import and directquery mode to get data.
If you mean excel workbook contents, you can use import feature to direct load excel workbook contents to power bi.
Import Excel workbooks into Power BI Desktop
BTW, if your data is from third party excel add-in, I don't think it is possible to load live data on service side through that add-in.
Regards,
Xiaoxin Sheng
Thanks
This solution helps me
User | Count |
---|---|
93 | |
83 | |
77 | |
74 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |