Forum Discussion
Power BI Embedded - Non power BI Access to their data - Direct query?
I am currently building a power BI embedded application and essentially want to have NON-Power BI Users log into the system and access data according to their associations with the company.
A couple of questions that I have around this are the following:
1. Do I NEED to use Direct Query for this? Is there an option to NOT user Direct Query?
2. If 1 is the case, does that mean I CAN ONLY USE AZURE SQL database and NOT Azure mySQL database?
3. Is Azure mysql supported by the direct query?
This is directly hindering my project and lightly put it I am screwed if I can't figure this out. Any help will be appreciated.
ae15 wrote:
I am currently building a power BI embedded application and essentially want to have NON-Power BI Users log into the system and access data according to their associations with the company.
A couple of questions that I have around this are the following:
1. Do I NEED to use Direct Query for this? Is there an option to NOT user Direct Query?
2. If 1 is the case, does that mean I CAN ONLY USE AZURE SQL database and NOT Azure mySQL database?
3. Is Azure mysql supported by the direct query?
This is directly hindering my project and lightly put it I am screwed if I can't figure this out. Any help will be appreciated.
- No, you don't have to use DirectQuery. Both DirectQuery and Import modes are OK.
- That DirectQuery limiation is for the being deprecated Power BI workspace collections. In the new Power BI Embedded capacity-based SKUs coming, you deploy the pbix file to Power BI Service, so no such limitation at all.
- You connect to Azure MySQL service via the connector "MySQL" in Power BI Desktop. DirectQuery doesn't support MySQL at this moment, see Data sources supported by DirectQuery in Power BI.
1 Reply
ae15 wrote:
I am currently building a power BI embedded application and essentially want to have NON-Power BI Users log into the system and access data according to their associations with the company.
A couple of questions that I have around this are the following:
1. Do I NEED to use Direct Query for this? Is there an option to NOT user Direct Query?
2. If 1 is the case, does that mean I CAN ONLY USE AZURE SQL database and NOT Azure mySQL database?
3. Is Azure mysql supported by the direct query?
This is directly hindering my project and lightly put it I am screwed if I can't figure this out. Any help will be appreciated.
- No, you don't have to use DirectQuery. Both DirectQuery and Import modes are OK.
- That DirectQuery limiation is for the being deprecated Power BI workspace collections. In the new Power BI Embedded capacity-based SKUs coming, you deploy the pbix file to Power BI Service, so no such limitation at all.
- You connect to Azure MySQL service via the connector "MySQL" in Power BI Desktop. DirectQuery doesn't support MySQL at this moment, see Data sources supported by DirectQuery in Power BI.