Forum Discussion
Uploading to Power BI Embedded with the C# Client with a File Source and Direct Query Source Fails
I'm using Microsoft.PowerBI.Api 4.18 in C# We allow clients to build their own PBIX files in Desktop and upload to our portal. The general upload method is 1. Import File 2. Take Ownership ...
You should not allow file data sources on a user's computer. It requires a gateway, worst case a gateway on that same computer - on every one of them.
Only accept files stored on OneDrive. Those do not require gateways as long as you don't attempt to merge queries with other on-prem data sources.
Thank you for your response.
The goal here is not to allow ongoing accesss to the file, it become static data is works fine by itself. It can't be refreshed from our service and that is well understand and accepted by the client and us.
The problem is that when a file and a Direct Query are in the PBIX the Direct Query gets broken in the import.
This does not occur if I mix a file with a SQL Import or a SQL Import with a Direct Query.