The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm trying to migrate my tabular model and semantic layer from Power BI to Azure Analysis services however within Visual studio I'm not finding as many data connectors. For example I have no option to connect to a Web API, or Jira, or a SharePoint Folder (not a SharePoint List).
Can these data sources be connected directly to AAS or do I absolutely need to pass through a database?
Thanks
1. In your server's Overview blade > Web designer, click Open.
2. In Web designer > Models, click + Add.
3. In the New model, type a model name, and then select Power BI Desktop file.
4. Browse for the file you wish to import and then click Import.
At this point, the model inside of your desktop file will be converted to an Azure Analysis Services file. You can then query this file in the web directly, or open it up in the Power BI Desktop as a live connection. Further edits to the model can be made in the Azure Analysis Services web designer or through Visual Studio.
This process also works when you are using windows virtual desktop. If you find this answer helpful please mark it as an answer.