- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is no gateway to access for a PowerBI Dataset?
I have a dataset in one workspace.
In "My Workspace", I created a report that connects to it.
I am getting the error "There is no gatewar to access the data source message" - which is strange because I thought gateways were for on-Prem. My PowerBi dataset is in the cloud, of course, and PowerBI service won't even let me create a gateway for it (as all data is in the cloud)
What's the issue here?
Thank you!
Michael
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, I think they issue had to do with importing an excel table and connecting it to a DirectQuery model.
The only change I made when rebuilding it was to add the imported table to the original PBIX. Then connecting via DirectQuery was fine and I had no issues.
Subsequently, I've also explored using SSAS connectors to the original file in a premium workspace, as DirectQuery seems to have some serious limitations.
Thank you,
MG
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share datasource details ? as in Type? whether it is within a firewall or not?
If your datasource is within a firewall you may need gateway.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's all on a compnay cloud with no firewalls or access issues. I ended up deleting my work, simplifying the data model and rebuilding. I have no idea why it was throwing this error but I've moved on. I'll post again here if it crops up again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, I think they issue had to do with importing an excel table and connecting it to a DirectQuery model.
The only change I made when rebuilding it was to add the imported table to the original PBIX. Then connecting via DirectQuery was fine and I had no issues.
Subsequently, I've also explored using SSAS connectors to the original file in a premium workspace, as DirectQuery seems to have some serious limitations.
Thank you,
MG
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 04:33 PM | |||
10-04-2024 06:16 AM | |||
09-26-2023 11:03 PM | |||
01-03-2024 05:00 PM | |||
07-08-2024 04:57 AM |
User | Count |
---|---|
51 | |
39 | |
23 | |
19 | |
16 |