Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Live connection and static Excel file

Hi folks, not sure if anybody can help me.  I have a PBI file with a live connection to a data cube.  I need to import a static Excel file that contains various sales targets and connect them.  Is this possible?  I have seen Direct Query mode as a possible solution, but it appears this is not possible with the cube that I am using.

 

If anybody has any suggestions, I would be forward grateful! 🙂

2 REPLIES 2
Florent_Fgu
New Member

Hello all,

 

My customers use Power BI Datasets through Excel Application, not with Power BI Reports.

Datasets are in the same Workspace. 

i'm finding a way to collect connexion statistics by users and date for a dataset.  

Do you know how i can do that ?

Currently I use the Premium capacity usage report, but information are not engough (only connexion without distinct)

Thank you for your help.

 

lbendlin
Super User
Super User

Consider connecting to the cube in Import mode (yes, blasphemy, I know).

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.