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
verscev
Frequent Visitor

Force dataset usage

We have a dataset in PowerBi.com that connects through the Enterprise Gateway to an on premise SSAS cube that we access through a direct connection. Security is implemented on the cube, and we can create local reports (PowerBi Desktop) by using this dataset in the service. This is all working as expecting. 

 

At the moment, in PowerBi Desktop people can still create reports linked directly to the SSAS cube instead of using the dataset in PowerBi.com. This is possible because they do have access to the cube. 

 

Is there a way that we can force end users to use this dataset, to avoid that they link directly to the SSAS cube?

Another way would be to avoid that they can publish reports that are created with a link to this SSAS cube?

 

Any suggestions on this topic?

 

Thanks in advance.

Evi Verschueren

1 ACCEPTED SOLUTION
Seth_C_Bauer
Community Champion
Community Champion

@verscev The only thought I have off the top of my head would be to lock down the server that hosts the SSAS instance to only accept calls from the gateway server. That way, any IP that is not the server would fail. I haven't tried that, but I would think it could work.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

1 REPLY 1
Seth_C_Bauer
Community Champion
Community Champion

@verscev The only thought I have off the top of my head would be to lock down the server that hosts the SSAS instance to only accept calls from the gateway server. That way, any IP that is not the server would fail. I haven't tried that, but I would think it could work.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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.